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…
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: …
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…
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…
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…
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.