Innotop for MySQL 8.0
Recently, I did some maintenance on Innotop and I merged several pull requests including one to support MySQL 8.0 (thank you yoku0825 for the contribution). As you know, Innotop is written in Perl and to be able to use it…
Deploy an Asynchronous Replication setup with MySQL 8.0 in 2 mins
There are multiple way to setup replication with MySQL 8.0 and our replication offer as never been so rich: asynchronous, semi-synchronous, group replication, multi-source, … and much more options ! But if you want to setup a very quick Master-Replics…
MySQL and Memory: a love story (part 2)
We saw in the previous post that MySQL likes memory. We also saw how to perform operating system checks and some configuration changes for Swap and NUMA. Today, we will check what MySQL server can tell us about its memory…
MySQL and Memory: a love story (part 1)
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…
sysbench for MySQL 8.0
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…
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 :…
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…
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…
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…
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…
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…
MySQL at Oracle Open World and Oracle Code One Oct 22-25 2018 !
This year again, the MySQL Team is eager to participate in the Oracle Open World conference. This is a great opportunity for our engineers and the entire MySQL Team to highlight what we’ve done, and also what we are working…
