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…
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…
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…
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…
With this post we are reaching the end of our journey to HA for WordPress & MySQL 8.0 on OCI. If you have not read the two previous articles, this is just the right time. MySQL 8.0 InnoDB ReplicaSet with…
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.