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…
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…
Yesterday, Bhuvanesh published an article about how to verify the difference between allocated diskspace for a tablespace and the the data in it. I commented with an old post explaining how to get some similar info only using SQL in…
Do you know that it’s possible to get information from the CPUs of your MySQL Server from SQL ? If you enable the status for the INNODB_METRICS table in INFORMATION_SCHEMA, you will be able to query CPU information.
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…