lefred's blog


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

What is the best practice to get a list of all the queries running in MySQL (processlist) ?

If you are a MySQL DBA for a long time (like me), it’s very complicated to get rid of bad habits. One of them I really need to change is the way to retrieve the list of all the running queries (processlist). Usually, I use SHOW FULL PROCESSLIST which is very convenient, but like querying the Information_Schema, this statement has … Read More


MySQL at Oracle Open World and Oracle Code ONE

We are 6 weeks away of Oracle Open World and Oracle Code ONE in San Francisco. Once again, and maybe even more than ever, the MySQL Team and MySQL Community will present you very interesting sessions, tutorials and hands-on labs ! The Official Agenda is available here and here. If you plan to attend this conference, I prepared one single … Read More


How to know if a user never connected to the MySQL server since last boot ?

Performance_Schema is used most of the time to get metrics about queries and connections. But it can also provide other very useful information. So today, I will show you how you can see a list of users that didn’t connect to MySQL since we restarted it (since last reboot). SELECT DISTINCT mu.user FROM mysql.user mu LEFT JOIN performance_schema.users psu ON … Read More


MySQL InnoDB Cluster: upgrade from 8.0.11 to 8.0.12

In April, I already posted an article on how to upgrade safely your MySQL InnoDB Cluster, let’s review this procedure now that MySQL 8.0.12 is out. To upgrade all the members of a MySQL InnoDB Cluster (Group), you need to keep in mind the following points: upgrade all the nodes one by one always end by the Primary Master in … Read More


MySQL InnoDB Cluster 8.0.12 – avoid old reads on partitioned members

We received feedback about how a member should act when leaving the group. And the majority of users wanted that when a node drops out of the group, it should kill all connections and shutdown. I totally agree with that behavior and it’s now the default in MySQL 8.0.12. This new feature is explained in WL#11568. Before this change, the … Read More


recent

Last Tweets

Locations of visitors to this page
categories