lefred's blog

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

MySQL 8.0: changing configuration easily and cloud friendly !

Changing configuration settings in MySQL wasn’t always easy. Of course it’s possible to change things (hopefully), but keeping track of everything is not always obvious. This is where configuration management systems like puppet, chef, ansible, … excels in making our life easier. /etc/my.cnf With MySQL 8.0, we worked in making your life easier (and the life of configuration management systems … Read More

pre-FOSDEM MySQL Day 2018: the schedule

Happy New Year everybody ! All your wishes should come true with 2018.0 ! As announced previously in this post, this year we will have the second edition of the MySQL Day just before FOSDEM. All speakers confirmed their talk and I’ve the pleasure to share the announce the schedule ! Start End Event Speaker Company Topic Friday 2nd February … Read More

Overview of fragmented MySQL InnoDB tables

The major engine for MySQL is InnoDB, it complies with the ACID properties for a transactional database engine. Even if InnoDB is the most recommended engine for MySQL, it has also some caveats. The biggest criticism lies in the amount of disk space used. And even when we remove data, tablespaces don’t shrink. This post is about those tables that … Read More

pre-FOSDEM MySQL Day 2018

As last year, we will take advantage of the mass presence of our engineers during FOSDEM to organize a MySQL Day once again. The Agenda is not yet known, but save the date and schedule your trip to Brussels keeping in mind that Friday February 2nd 2018, there will be a full day dedicated to MySQL ! More to come … Read More

From MySQL 5.6 partitioning to 5.7 and beyond

As you may already know,  since MySQL 5.7.17, the generic partitioning handler in the MySQL server is deprecated, and is completely removed in MySQL 8.0. So now, in MySQL 5.7, the storage engine used for a given table is expected to provide its own (“native”) partitioning handler. Currently, only the InnoDB and NDB storage engines do. MySQL 5.7 supports generic … Read More


Last Tweets Last Tweets

    Locations of visitors to this page