Last week I presented the following session at the pre-FOSDEM MySQL Day: The audience seemed very interested on how the MySQL Shell can be extended. During the presentation I showed how I extended the MySQL Shell with two new modules in Python: mydba innotop Both projects are on github and are waiting for ideas, feature requests, pull requests, … Here … Read More
MySQL InnoDB is more and more popular. The adoption of it is even faster than I expected. Recently, during my travel in Stockholm, Sweden, a customer asked me what was the best practice to backup a cluster.
I already covered some information related to users password recently (see this post and this one). Today, let’s have a look at the password management features available in MySQL 8.0.
It seems, that this is a question that regularly shows up in forums or stackoverflow. To start, let’s highlight the fact that in MySQL 8.0 it’s not any more possible to create a user directly from the GRANT command (ERROR 1410 (42000): You are not allowed to create a user with GRANT). This means that to grant some privileges, the … Read More
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 usage. Introduced in MySQL 5.7 and enabled by default in MySQL 8.0, the Performance_Schema‘s Memory instrumentation allows us to have … Read More