lefred's blog


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

MySQL: size of your tables – tricks and tips

Many of you already know how to retrieve the size of your dataset, schemas and tables in MySQL. To summarize, below are the different queries you can run: Dataset Size I the past I was using something like this : But now with sys schema being installed by default, I encourage you to use some of the formatting functions provided … Read More


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


recent

Last Tweets

Locations of visitors to this page
categories