For performance, having a warm InnoDB Buffer Pool is very important. What does that mean ? A warm buffer pool means that the most used pages (working set) required by the production workload are already loaded in memory (in the…
If you decided to move your data from Amazon Aurora to the real MySQL Database Service on OCI you can use the nice MySQL Shell Dump & Load utility to dump the data or the full instance. This is the…
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…
To avoid infinite replication loops MySQL doesn’t allow you to have log_slave_updates and replicate-same-server-id. When using GTIDs that may lead to something not expected that you may not be aware of. In this scenario, we have 2 MySQL servers using…
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.