EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL 8.0

 | July 5, 2016 |  Posted In: MySQL

MySQL 8

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 […]

Read More

MySQL 5.7 By Default 1/3rd Slower Than 5.6 When Using Binary Logs

 | June 3, 2016 |  Posted In: MySQL

binary logs make MySQL 5.7 slower

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_64 mysqld –options: --no-defaults --log-bin=mysql-bin --server-id=2 Run details: Sysbench version 0.5, 4 threads, socket file connection […]

Read More

MySQL is crashing: a support engineer’s point of view

and  | August 17, 2015 |  Posted In: Insight for DBAs, MySQL, Percona Server, Percona Software

In MySQL QA Episode #12, “MySQL is Crashing, now what?,” Roel demonstrated how to collect crash-related information that will help Percona discover what the issue is that you are experiencing, and fix it. As a Support Engineer I (Sveta) am very happy to see this post – but as a person who better understands writing than recording – […]

Read More

MySQL Quality Assurance: A Vision for the Future by Roel Van de Paar (Final Episode 13)

 | August 13, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

MySQL Quality Assurance

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 Interleaving 1. pquery Review 2. Random […]

Read More

MySQL QA Episode 12: My server is crashing… Now what? For customers or users experiencing a crash

 | August 11, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

My server is crashing… Now what? This special episode in the MySQL QA Series is for customers or users experiencing a crash. A crash? Cheat sheet: https://goo.gl/rrmB9i Sever install & crash. Note this is as a demonstration: do not action this on a production server! sudo yum install -y http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm sudo yum install -y Percona-Server-client-56 Percona-Server-server-56 sudo service […]

Read More

MySQL QA Episode 11: Valgrind Testing: Pro’s, Con’s, Why and How

 | August 4, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

MySQL QA Episode 11

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 […]

Read More

MySQL QA Episode 10: Reproducing and Simplifying: How to get it Right

 | July 31, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

MySQL QA Episode 10

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 […]

Read More

MySQL QA Episode 9: Reducing Testcases for Experts: multi-threaded reducer.sh

 | July 28, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

Welcome to MySQL QA Episode 9. This episode will go more in-depth into reducer.sh: Reducing Testcases for Experts: multi-threaded reducer.sh We will explore how to use reducer.sh to do true multi-threaded testcase reduction – a world’s first. Topics: Expert configurable variables & their default reducer.sh settings PQUERY_MULTI PQUERY_MULTI_THREADS PQUERY_MULTI_CLIENT_THREADS PQUERY_MULTI_QUERIES PQUERY_REVERSE_NOSHUFFLE_OPT Full-screen viewing @ 720p resolution […]

Read More

MySQL QA Episode 8: Reducing Testcases for Engineers: tuning reducer.sh

 | July 23, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

Welcome to MySQL QA Episode 8: Reducing Testcases for Engineers: tuning reducer.sh Advanced configurable variables & their default/vanilla reducer.sh settings FORCE_SKIPV FORCE_SPORADIC TIMEOUT_COMMAND & TIMEOUT_CHECK MULTI_THREADS MULTI_THREADS_INCREASE QUERYTIMEOUT STAGE1_LINES SKIPSTAGE FORCE_KILL Some examples FORCE_SKIPV/FORCE_SPORADIC TIMEOUT_COMMAND/TIMEOUT_CHECK Full-screen viewing @ 720p resolution recommended.

Read More

MySQL QA Episode 7: Reducing Testcases for Beginners – single-threaded reducer.sh!

 | July 21, 2015 |  Posted In: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

Welcome to MySQL QA Episode #7 – Reducing Testcases for Beginners: single-threaded reducer.sh! In this episode we’ll learn how to use reducer.sh. Topics discussed; reducer.sh introduction/concepts Basic configurable variables & their default reducer.sh settings INPUTFILE options MODE=x TEXT=”text” WORKDIR_LOCATION & WORKDIR_M3_DIRECTORY MYEXTRA MYBASE PQUERY_MOD & PQUERY_LOC MODE5_COUNTTEXT, MODE5_ADDITIONAL_TEXT & MODE5_ADDITIONAL_COUNTTEXT How to learn more about each […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.