lefred's blog

There Are 10 Types of People in the World....

MySQL InnoDB Cluster: how to handle performance issue on one member ?

  Sometimes when you are using a MySQL InnoDB Cluster, you might encounter some performance issue because one node becomes dramatically slow. Why ? First of all, why ? A node can apply the transactions slower than the other nodes for many different reasons. The most frequents are for example, slower disks (remember, it’s advised to have nodes with the … Read More

Migrating to MySQL 8.0 for WordPress – episode 2: workload analysis

Now that MySQL is upgraded to 8.0 RC1, let’s have a look on how we could check the workload and see if we can optimize something by adding indexes for example. The same technique can be used to find inefficient queries requiring rewriting. The first thing we will check is some information regarding the usage of the user used for … Read More

👋 🐛 199 – bye bye bug #199, MySQL auto_increment is fixed !

It was expected for a long time…. here is the fix for bug #199 !! The bug #199 submitted by PeterZ has been fixed in 8.0. Thank you to Zhang Simon for his contribution that inspired us to implement the fix. Let’s have a look at the test case described in the bug report, I will reproduce it on MySQL … Read More

MySQL Team speaking at Percona Live Dublin 2017

From September 25th to 27th 2017, the MySQL engineers and community team will be speaking at Percona Live Europe in Dublin. MySQL is also part of the contributing sponsors. For the conference, we tried to bring new faces to the Community. Usually, it’s always the same famous team leaders speaking at the conferences, this time, it’s not. A lot of … Read More

MySQL Group Replication: read your own write across the group

Today is my last day in Asia (China and Taiwan), and between the sessions I had the time to code a small proof-of-concept for people that are asking how they could read their writes on all nodes and ensure the read consistency with their last write ? The usual (and easier) answer to this particular question is to read on … Read More


Last Tweets Last Tweets

    Locations of visitors to this page