TOP 10 MySQL 8.0 features for DBAs & OPS
Today, let’s have a look at the TOP 10 new features in MySQL 8.0 that will improve DBA’s life. To shrink the list to 10 only items wasn’t an easy task, but here is the top 10: Temporary Tables Improvements…
TOP 10 MySQL 8.0 features for developers
MySQL 8.0 RC2 has just been released with a lot of new features compared to MySQL 5.7. In this blog post, I will list the top 10 new features that should excite developers. These functionalities are presented in descending order…
MySQL 8.0 Roles and Graphml
You may already know that MySQL 8.0 is coming with a nice requested feature : ROLES A role is a named collection of privileges. When you watch some slidedeck about MySQL 8.0 and ROLES, some times you can see a…
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…
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…
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…
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…
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…
MySQL 8.0 Data Dictionary Tables… and why they should stay protected
With MySQL 8.0, one key feature is the new Data Dictionary. The system tables that were previously in MyISAM are now replaced by new protected ones in the DD. My friend Giuseppe already explained how you could see those tables…
Where does my MySQL configuration variable value come from ?
As you may already know, there are many different places where a MySQL configuration variables can be initialized. In MySQL 8.0, we added in performance_schema a table allowing you to easily find where a variable was defined. Let’s check this…
MySQL Clients and emojis !
As you probably already know, MySQL 8.0 supports Unicode 9.0 and our default charset moved from latin1 to utf8mb4. Recently, Gabi (certainly working on an amazing presentation for PHPWorld) asked me something about how the client deals with the emojis…
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…
