lefred's blog

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

MySQL Shell : the best DBA tool?

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

How to backup your InnoDB Cluster ?

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.

MySQL 8.0 and user password management

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.

How to grant privileges to users 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

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 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


Last Tweets

Locations of visitors to this page