MySQL 8.0 on Intel Optane SSDs
If you are interested in MySQL Performance and you are looking for an optimal storage, you should have a look at this presentation by Frank Ober where you will be able to see how MySQL behaves on Intel Optane SSDs:…
MySQL 8.0: Statements Latency Histograms
At the end we all agree that what really matters is the Query Response Time, isn’t it ? MySQL 8.0 engineers have added more visibility in the summary tables as explained in this previous post. But to add more details,…
MySQL InnoDB Cluster & Group Replication: how to upgrade safely your cluster
Recently on MySQL Forums, somebody was looking for documentation or procedure to upgrade a MySQL InnoDB Cluster (or Group Replication cluster) to a newer version. In this post I am illustrating the best practices to achieve this task safely.
Migrating to MySQL 8.0 without breaking old application
Recently I blogged about the new default authentication plugin in MySQL 8.0 and I got some comments complaining that this new authentication plugin is breaking half of applications. So first of all, if you are using an old connector or…
MySQL 8.0 : Digest Query Samples in Performance_Schema
Today, yet another blog post about improvements in MySQL 8.0 related to Performance_Schema. Before MySQL 8.0 it was not always easy to get an example of the queries you could find in Performance_Schema when looking for statements summaries. You had…
MySQL 8.0 : New Error Logging
With MySQL 8.0, the error logging subsystem has been redesigned to use the new component architecture. Thanks to this new redesign, now the log events can be filtered, the output can be sent to multiple destinations (different formats like JSON).…
MySQL 8.0 : meta-data added to Performance_Schema’s Instruments
In MySQL 8.0, the engineers have added useful meta-data to the table SETUP_INSTRUMENT. This table lists the classes of instrumented objects for which events can be collected. To the NAME, ENABLES and TIMED columns, were added PROPERTIES, VOLATILITY and DOCUMENTATION.…
MySQL : command delimiter curiosity – go & ego
Recently, I received a question related to GO as delimter to send a query. The user got some generated statements from a third party tool that looked like this:
MySQL 8.0 : more about new authentication plugin and replication
MySQL 8.0’s new default authentication plugin means more secure connections for users connections but also for replication… but you need to be aware of it ! Yesterday Giuseppe – the datacharmer – Maxia, submitted a bug related to a strange…
MySQL 8.0 : Data Locking Visibility
With MySQL 8.0, engineers improved the visibility of data locking. Usually it was not that easy to deal with the output of SHOW ENGINE INNODB STATUS and mixing Information_Schema tables like INNODB_LOCKS and INNODB_LOCK_WAITS. So in MySQL 8.0 we instrument…
MySQL 8.0: Listing Roles
As you may already know, MySQL 8.0 is coming with SQL Roles . I’ve already quoted them before in some posts (here and here). Giuseppe Maxia is doing a great job testing and promoting them (thank you for that!). Of…
MySQL 8.0 Histograms
Prior to MySQL 8.0, MySQL was missing a very well know feature in other RDBMS: optimizer histograms. The Optimizer Team implemented this feature as more and more MySQL DBAs were requesting it. Definition But what are histograms ? For wikipedia,…