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…