lefred's blog

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

MySQL: who’s filling my error log?

This morning, a user asked in the MySQL Community Slack if somebody had an idea why the error log was filled up continuously with a warning messages like this one: 2020-07-24T06:54:00.877128Z 46 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ”sha256_password’ is deprecated and will be removed in a future release. Please use caching_sha2_password instead’ The context was that the user upgraded … Read More

MySQL – Keep an eye on your auto_increment values

In MySQL, it’s very common and recommended to you an auto_increment as Primary Key. However that integer can have different types each having their size limitation, and they can also be signed or not. Many people when creating a table use by default the following syntax do define their auto_increment primary key: id int auto_increment primary key This is a … Read More

MySQL 8.0 – Who stopped mysqld and how long did it take ?

In MySQL 8.0.21, we can see who and how mysqld was stopped and when the process ended. Let’s have a look at different scenarios in this article. SHUTDOWN SQL statement The first test is to initiate the shutdown of MySQL from a SQL client: mysql> shutdown; In the error log (log_error_verbosity is set to 2, the default), we can see: … Read More

MySQL 8.0.21: thank you for the contributions

MySQL 8.0.21 has been released today, wooohooo \o/ As usual, this release contains contributions and let me thanks all the contributors on behalf of the MySQL Team. MySQL 8.0.21 includes contributions from Edgars Irmejs, DaniĆ«l van Eeden, Jeremy Cole, Wenfeng Shih, Billy O’Neal, Lou Shuai, Tsubasa Tanaka and Facebook. Thank you all for your great contributions. MySQL is an Open … Read More

Sysbench 1.0.20 for MySQL 8.0

As proven again very recently by my colleague and friend Dimitri K, with the TPCC “Mystery”, sysbench made by a former colleague and friend Alexey K, is really the recommended framework to benchmark your system. I use sysbench of course to benchmark MySQL but also my OS and hardware capabilities. For those willing to benchmark MySQL 8.0 with sysbench using … Read More

I deeply value the diversity of MySQL developers, users, community and my blog readers. I cannot agree the suffering, oppression, and systemic racism the Black community faces every day. Black lives matter.