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…
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…
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…
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…
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…
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…
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…
In MySQL 8.0, we have now a new way of storing tables definitions: the Data Dictionary ! Thanks to the Data Dictionary, DDLs in MySQL 8.0 are now Atomic. This means tat we have some changes in the behavior of…
Now that MySQL 8.0.3 RC1 is installed and that we saw how to verify the workload, it’s time to see if we can optimize some of the queries. As explained before, rewriting queries when using a product like WordPress is…
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…
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…
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…
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…
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.