Roel Van de Paar, Author at Percona Database Performance Blog Fri, 16 Feb 2024 22:55:33 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png Roel Van de Paar, Author at Percona Database Performance Blog 32 32 76301791 MySQL 8.0 GA: Quality or Not? https://www.percona.com/blog/mysql-8-0-ga-quality-or-not/ https://www.percona.com/blog/mysql-8-0-ga-quality-or-not/#comments Fri, 27 Apr 2018 19:36:26 +0000 https://www.percona.com/blog/?p=49874 What does Anton Ego – a fictional restaurant critic from the Pixar movie Ratatouille – have to do with MySQL 8.0 GA?When it comes to being a software critic, a lot.In many ways, the work of a software critic is easy. We risk very little and thrive on negative criticism, which is fun to read […]]]> https://www.percona.com/blog/mysql-8-0-ga-quality-or-not/feed/ 3 49874 Thoughts on MySQL 8.0.3 RC – The First MySQL 8.0 Release Candidate https://www.percona.com/blog/thoughts-on-mysql-8-0-3-rc-the-first-mysql-8-0-release-candidate/ https://www.percona.com/blog/thoughts-on-mysql-8-0-3-rc-the-first-mysql-8-0-release-candidate/#comments Tue, 12 Dec 2017 18:47:48 +0000 https://www.percona.com/blog/?p=46279 Percona’s Technical Director of Quality Assurance Roel Van de Paar shares his findings on the quality of MySQL 8.0.3 RC.On 21 September 2017, our upstream friends at Oracle released MySQL 8.0.3 RC as the first MySQL 8.0 Release Candidate.I tested the MySQL 8.0.3 Release Candidate branch with selected Percona bugfixes applied and built it as […]]]> https://www.percona.com/blog/thoughts-on-mysql-8-0-3-rc-the-first-mysql-8-0-release-candidate/feed/ 4 46279 ProxySQL Admin Configuration https://www.percona.com/blog/proxysql-admin-configuration/ https://www.percona.com/blog/proxysql-admin-configuration/#comments Wed, 25 Jan 2017 23:15:51 +0000 https://www.percona.com/blog/?p=40403 ProxySQL Admin (proxysql-admin) is a powerful tool for configuring Percona XtraDB Cluster nodes into ProxySQL. The proxysql-admin tool comes with the ProxySQL package from Percona apt/yum repositories.ProxySQL 1.3.2-1 is now available from the Percona repositories. This release is based on ProxySQL v1.3.2a and introduces the following new changes: proxysql-admin_v1.3.2a.md.Installing on Red Hat or CentOSIf you are […]]]> https://www.percona.com/blog/proxysql-admin-configuration/feed/ 7 40403 MySQL 8.0.1: The Next Development Milestone https://www.percona.com/blog/mysql-8-0-1-next-development-milestone/ https://www.percona.com/blog/mysql-8-0-1-next-development-milestone/#comments Mon, 09 Jan 2017 16:49:01 +0000 https://www.percona.com/blog/?p=40200 This post discusses the next MySQL development milestone: MySQL 8.0.1.From the outset, MySQL 8.0 has received plenty of attention. Both this blog (see the MySQL 8.0 search) and other sites around the Internet have covered it. Early reviews seem positive (including my own MySQL 8.0 early bugs review). There is plenty of excitement about the new features.As for early […]]]> https://www.percona.com/blog/mysql-8-0-1-next-development-milestone/feed/ 1 40200 Percona Monitoring and Management (PMM) Information Script https://www.percona.com/blog/percona-monitoring-and-management-pmm-information-script/ Tue, 01 Nov 2016 20:30:02 +0000 https://www.percona.com/blog/?p=39060 This blog post discusses an information script for the Percona Monitoring and Management (PMM) tool.In recent news, we announced the fresh-of-the-press Percona Monitoring and Management (or PMM for short) platform. Given the interaction of the different components that together make up PMM, I developed a script that helps provide you information about the status of your PMM installation.You can use this script yourself, or one of our support might […]]]> 39060 7 Fresh Bugs in MySQL 8.0 https://www.percona.com/blog/7-fresh-bugs-in-mysql-8-0/ https://www.percona.com/blog/7-fresh-bugs-in-mysql-8-0/#comments Wed, 28 Sep 2016 18:19:52 +0000 https://www.percona.com/blog/?p=38329 This blog post will look at seven bugs in MySQL 8.0.Friday afternoon is always ideal for a quick look at the early quality of MySQL 8.0! Last Friday, I did just that.If you haven’t heard the news yet, MySQL 8.0 DMR is available for download on mysql.com!Tools to the ready: pquery2, updated 8.0 compatible scripts in Percona-qa […]]]> https://www.percona.com/blog/7-fresh-bugs-in-mysql-8-0/feed/ 1 38329 Regular Expressions Tutorial https://www.percona.com/blog/regular-expressions/ https://www.percona.com/blog/regular-expressions/#comments Wed, 21 Sep 2016 13:48:16 +0000 https://www.percona.com/blog/?p=38134 This blog post highlights a video on how to use regular expressions.It’s been a while since I did the MySQL QA and Bash Training Series. The 13 episodes were quite enjoyable to make, and a lot of people watched the video’s and provided great feedback.In today’s new video, I’d like to briefly go over regular expressions. The session will cover the basics […]]]> https://www.percona.com/blog/regular-expressions/feed/ 1 38134 MySQL 8.0 https://www.percona.com/blog/mysql-8-0/ https://www.percona.com/blog/mysql-8-0/#comments Tue, 05 Jul 2016 22:18:25 +0000 https://www.percona.com/blog/?p=36565 If you haven’t heard the news yet, MySQL 8.0 is apparently the next release of the world-famous database server.Obviously abandoning plans to name the next release 5.8, Percona Server’s upstream provider relabelled all 5.8-related bugs to 8.0 as follows:Reported version value updated to reflect release name change from 5.8 to 8.0 What will MySQL 8.0 bring […]]]> https://www.percona.com/blog/mysql-8-0/feed/ 11 36565 MySQL 5.7 By Default 1/3rd Slower Than 5.6 When Using Binary Logs https://www.percona.com/blog/binary-logs-make-mysql-5-7-slower-than-5-6/ https://www.percona.com/blog/binary-logs-make-mysql-5-7-slower-than-5-6/#comments Fri, 03 Jun 2016 16:11:22 +0000 https://www.percona.com/blog/?p=35923 Researching a performance issue, we came to a startling discovery:MySQL 5.7 + binlogs is by default 37-45% slower than MySQL 5.6 + binlogs when otherwise using the default MySQL settings.Test server MySQL versions used: i7, 8 threads, SSD, Centos 7.2.1511 mysql-5.6.30-linux-glibc2.5-x86_64 mysql-5.7.12-linux-glibc2.5-x86_64mysqld –options: [crayon-664c8c034cba7714656257-i/]Run details: Sysbench version 0.5, 4 threads, socket file connectionSysbench Prepare:  [crayon-664c8c034cbad204226548/] Sysbench Run: […]]]> https://www.percona.com/blog/binary-logs-make-mysql-5-7-slower-than-5-6/feed/ 12 35923 MySQL is crashing: a support engineer’s point of view https://www.percona.com/blog/mysql-is-crashing-a-support-engineers-point-of-view/ https://www.percona.com/blog/mysql-is-crashing-a-support-engineers-point-of-view/#comments Mon, 17 Aug 2015 11:38:02 +0000 https://www.percona.com/blog/?p=31313 https://www.percona.com/blog/mysql-is-crashing-a-support-engineers-point-of-view/feed/ 1 31313 MySQL Quality Assurance: A Vision for the Future by Roel Van de Paar (Final Episode 13) https://www.percona.com/blog/mysql-quality-assurance-a-vision-for-the-future-by-roel-van-de-paar/ https://www.percona.com/blog/mysql-quality-assurance-a-vision-for-the-future-by-roel-van-de-paar/#comments Thu, 13 Aug 2015 17:13:54 +0000 https://www.percona.com/blog/?p=30774 Welcome to the final – but most important – episode in the MySQL QA Series.In it, I present my vision for all MySQL Quality Assurance – for all distributions – worldwide.Episode 13: A Better Approach to all MySQL Regression, Stress & Feature Testing: Random Coverage Testing & SQL Interleaving1. pquery Review 2. Random Coverage Testing 3. […]]]> https://www.percona.com/blog/mysql-quality-assurance-a-vision-for-the-future-by-roel-van-de-paar/feed/ 2 30774 MySQL QA Episode 12: My server is crashing… Now what? For customers or users experiencing a crash https://www.percona.com/blog/mysql-qa-episode-12-server-crashing-now-customers-users-experiencing-crash/ https://www.percona.com/blog/mysql-qa-episode-12-server-crashing-now-customers-users-experiencing-crash/#comments Tue, 11 Aug 2015 10:00:11 +0000 https://www.percona.com/blog/?p=30771 https://www.percona.com/blog/mysql-qa-episode-12-server-crashing-now-customers-users-experiencing-crash/feed/ 2 30771 MySQL QA Episode 11: Valgrind Testing: Pro’s, Con’s, Why and How https://www.percona.com/blog/mysql-qa-episode-11-valgrind-testing-pros-cons/ https://www.percona.com/blog/mysql-qa-episode-11-valgrind-testing-pros-cons/#comments Tue, 04 Aug 2015 10:00:26 +0000 https://www.percona.com/blog/?p=30766 Today’s episode is all about Valgrind – from the pro’s to the con’s, from the why to the how! This episode will be of interest to anyone who is or wants to work with Valgrind on a regular or semi-regular basis. Pro’s/Why Con’s How Using the latest version sudo [yum/apt-get] install valgrind #OR# sudo [yum/apt-get] remove […]]]> https://www.percona.com/blog/mysql-qa-episode-11-valgrind-testing-pros-cons/feed/ 5 30766 MySQL QA Episode 10: Reproducing and Simplifying: How to get it Right https://www.percona.com/blog/mysql-qa-episode-10-reproducing-simplifying-get-right/ https://www.percona.com/blog/mysql-qa-episode-10-reproducing-simplifying-get-right/#comments Fri, 31 Jul 2015 10:00:22 +0000 https://www.percona.com/blog/?p=30764 Welcome to the 10th episode in the MySQL QA series! Today we’ll talk about reproducing and simplifying: How to get it Right.Note that unless you are a QA engineer stuck on a remote, and additionally difficult-to-reproduce or difficult-to-reduce bug, this episode will largely be non-interesting for you.However, what you may like to see – especially […]]]> https://www.percona.com/blog/mysql-qa-episode-10-reproducing-simplifying-get-right/feed/ 3 30764 MySQL QA Episode 9: Reducing Testcases for Experts: multi-threaded reducer.sh https://www.percona.com/blog/mysql-qa-episode-9-reducing-testcases-experts-multi-threaded-reducer-sh/ https://www.percona.com/blog/mysql-qa-episode-9-reducing-testcases-experts-multi-threaded-reducer-sh/#comments Tue, 28 Jul 2015 10:00:24 +0000 https://www.percona.com/blog/?p=30762 https://www.percona.com/blog/mysql-qa-episode-9-reducing-testcases-experts-multi-threaded-reducer-sh/feed/ 2 30762 MySQL QA Episode 8: Reducing Testcases for Engineers: tuning reducer.sh https://www.percona.com/blog/mysql-qa-episode-8-reducing-testcases-engineers-tuning-reducer-sh/ https://www.percona.com/blog/mysql-qa-episode-8-reducing-testcases-engineers-tuning-reducer-sh/#comments Thu, 23 Jul 2015 10:00:12 +0000 https://www.percona.com/blog/?p=30702 https://www.percona.com/blog/mysql-qa-episode-8-reducing-testcases-engineers-tuning-reducer-sh/feed/ 2 30702 MySQL QA Episode 7: Reducing Testcases for Beginners – single-threaded reducer.sh! https://www.percona.com/blog/mysql-qa-episode-7-single-threaded-reducer-sh-reducing-testcases-for-beginners/ https://www.percona.com/blog/mysql-qa-episode-7-single-threaded-reducer-sh-reducing-testcases-for-beginners/#comments Tue, 21 Jul 2015 10:00:13 +0000 https://www.percona.com/blog/?p=30580 https://www.percona.com/blog/mysql-qa-episode-7-single-threaded-reducer-sh-reducing-testcases-for-beginners/feed/ 6 30580 MySQL QA Episode 6: Analyzing and Filtering https://www.percona.com/blog/mysql-qa-episode-6-analyzing-and-filtering/ https://www.percona.com/blog/mysql-qa-episode-6-analyzing-and-filtering/#comments Wed, 15 Jul 2015 07:00:41 +0000 https://www.percona.com/blog/?p=30481 https://www.percona.com/blog/mysql-qa-episode-6-analyzing-and-filtering/feed/ 7 30481 MySQL QA Episode 5: Preparing Your QA Run with pquery https://www.percona.com/blog/mysql-qa-episode-5-preparing-your-qa-run-with-pquery/ https://www.percona.com/blog/mysql-qa-episode-5-preparing-your-qa-run-with-pquery/#comments Mon, 13 Jul 2015 07:00:09 +0000 https://www.percona.com/blog/?p=30478 https://www.percona.com/blog/mysql-qa-episode-5-preparing-your-qa-run-with-pquery/feed/ 2 30478 MySQL QA Episode 4: QA Framework Setup Time! https://www.percona.com/blog/mysql-qa-episode-4-qa-framework-setup-time/ https://www.percona.com/blog/mysql-qa-episode-4-qa-framework-setup-time/#comments Wed, 08 Jul 2015 07:00:05 +0000 https://www.percona.com/blog/?p=30470 https://www.percona.com/blog/mysql-qa-episode-4-qa-framework-setup-time/feed/ 1 30470