As you may know, sometimes MySQL can be memory-hungry. Of course having data in memory is always better than disk… RAM is still much faster than any SSD disk. This is the reason why we recommended to have the working…
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…
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 :…
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…
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…
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.