lefred's blog


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

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


Migrating to MySQL 8.0 for WordPress – episode 1

Yesterday I decided to upgrade the database server of lefred.be running the latest WordPress to MySQL 8.0. The previous version was 5.7.19. My dedicated server is still running on CentOS 6.x, and I had just to enable the MySQL Community 8.0 yum repository and upgrade the rpms: # yum update mysql-community-server –enablerepo=mysql80-community After the upgrade, I had to modify my.cnf … 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


Learn from the bests at the MySQL track of Oracle Open World

Do you want to hear how popular, innovative and leading companies are using MySQL to scale their large workload ? Join Oracle Open World to learn from these successful players how to achieve strong business constraints using the most popular Open Source database ! We have the honor to welcome some of the most famous companies in the Web and … Read More


Annual MySQL Community Reception at Oracle OpenWorld

Like every year, the a MySQL Community Reception will take place during Open World. If  you are using or interested in learning more about MySQL? And if  you are attending Oracle OpenWorld and looking for an opportunity to meet and exchange ideas or experiences with MySQL users? Then join the MySQL team on Tuesday, October 3rd at Jillians to celebrate … Read More


recent

Last Tweets Last Tweets

    Locations of visitors to this page
    categories