Alexey made this amazing tool that the majority of MySQL DBAs are using, but if you use sysbench provided with your GNU/Linux distribution or its repository on packagecloud.io you won’t be able to use it with the new default authentication plugin in MySQL 8.0 (caching_sha2_password). This is because most of the sysbench binaries are compiled with the MySQL 5.7 client … Read More
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
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
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
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
comments