MySQL Day Roma 2022 – review
The subtitle of this post could have been “Review of an awesome MySQL event”. I’ve been invited by the MySQL Italian team to deliver a session about MySQL Shell during the MySQL Day in Roma. This was the very first…
Define the Backup Policy when deploying MySQL Database Service in OCI
Let’s continue the discovery of the MySQL Database Resource when deploying on Oracle Cloud Infrastructure using Terraform. Last week, we saw how to create custom configurations and define user variables. Today we will see how we can define a backup…
Define your MySQL Configuration Variables on OCI with Terraform
With Terraform OCI provider 4.90.0 (released August 24th, 2022), we have added the possibility to specify the value of editable configuration variables directly from Terraform. These variables must be defined in a resource of type oci_mysql_mysql_configuration like this: We can…
MySQL & UUIDs
More and more people are using UUID’s to identify records in their database. As you already know, for MySQL’s storage engine (InnoDB) the primary key is very important ! (for performance, memory and disk space). See the following links: …
Always use MySQL Shell
You know how much I praise and like MySQL Shell but if like me, for you too, old habits die hard, I advise you to create these different aliases in your ~/.bashrc (or ~/.bash_aliases) file to force yourself to use…
MySQL 8.0: How to display long transactions
Recently, somebody asked me how he can find the long running transactions in MySQL. I already have one MySQL Shell plugin that allows you to find the current transactions sorted by time. The plugin allows you to also get the…
Dynamic InnoDB Redo Log
Since 8.0.30, you have the possibility to modify the InnoDB Redo Log Capacity online. An undersized Redo Log Capacity is problematic and lead to performance issues. However, it’s not recommended to oversize the Redo Log either. Redo Log files consume…
MySQL 8.0.30: thank you for the contributions
During my summer holidays, we released MySQL 8.0.30. MySQL 8.0.30 was released on July 26th 2022. If you are using 8.0.29, it’s highly recommended to upgrade as there was a bug corrupting InnoDB files in a rare and specific case.…
From email to myTinyTodo
Usually, I receive a lot of emails, and sometimes I read them on my phone and then… I forgot about them.. (shame on me). On my Linux desktop, I used to use Get Things Gnome for a long time, due…
How to build MySQL 8.0 C API (libmysqlclient)
If you write C applications that need to connect to MySQL, you can use the MySQL C API aka libmysqlclient. The MySQL C API replaces the outdated MySQL-Connector-C. If you want to use MySQL 8.0 as a Document Store with…
MySQL InnoDB Redo Log Archiving
When performing physical backup on system that are heavily used, it can happen that the backup speed cannot keep up with the redo log generation. This can happen when the backup storage is slower than the redo log storage media…
A graph a day, keeps the doctor away ! – Full Table Scans
Full table scans can be problematic for performance. Certainly if the scanned tables are large. The worst case is when full table scans are involved in joins and particularly when the scanned table is not the first one (this was…