In my previous post, I explained how to deal with Performance_Schema and Sys to identify the candidates for Query Optimization but also to understand the workload on the database. In this article, we will see how we can create an…
If like me you are an old experienced MySQL DBA, to analyze your MySQL workload, you certainly have used the slow query log with long_query_time set to 0. The slow query log is a file that contains all the queries…
Let’s continue our journey of deploying the MySQL Database System on OCI with Terraform.This time we will see how we can use a backup (see [1] and [2]) as a source (initial data) for a new instance. Within the oci_mysql_mysql_db_system…
Today I would share a nice book related to MySQL 8.0 for our Chinese users. The original title of this book by Scott Yao, is MySQL 8.0 运维与优化 I had the chance to read parts of the book before it…
Recently I wrote an article on how to define a backup policy for MySQL Database Service in OCI using Terraform. We saw that it was possible to define tags (defined_tags and freeform_tags) in the backup_policy section of a oci_mysql_mysql_db_system resource.…
I recently had the chance to read in preview Bill Karwin‘s new book: SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming. This book is a rework of Bill’s best seller from 2010. The new book can be considered…
Last Wednesday, at MySQL Day in Rome, my colleague Marco Carlsessi was very proud to show me the gift his wife had given him for when he had to make presentations: the Logitech Spotlight presentation remote. I found it very…
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…
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…
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…
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…
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.