pre-FOSDEM MySQL Days 2023
Hello dear MySQL Community ! As you may already know FOSDEM 2023 is again going to be held in-person. FOSDEM will take place February 4th and 5th 2023. We have also decided to put our pre-FOSDEM MySQL Day on track…
Journée MySQL Innovation et Cloud
Next week, November 16th, I will participate to the MySQL Innovation and Cloud Virtual Day in French. My colleagues will present what’s new in MySQL 8.0.31 and also summarize all the big news that was announced at Oracle Cloud World…
Generating Slow Query Log with MySQL Shell
Recently, I wrote three articles on how to analyze queries and generate a slow query log for MySQL Database Service on OCI: In these post, we were generating a slow query log in text or JSON directly in Object Storage.…
Intersect and Except in MySQL 8.0
With the latest MySQL release (8.0.31), MySQL adds support for the SQL standard INTERSECT and EXCEPT table operators. Let’s have a look how to use them. We will use the following table: For our team meeting, we will order tacos…
MySQL 8.0.31: thank you for the contributions
Once again, the latest version of MySQL 8.0 includes several contributions from the MySQL Community. MySQL 8.0.31 was released on October 11th 2022. I would like to thank all contributors on behalf of the entire Oracle MySQL team ! This…
Analyzing queries in MySQL Database Service – Slow Query Log (part 2)
In the previous part, we created our application and our 2 functions. Now we need to create an API Gateway to be able to call these functions from outside OCI. Using a third party scheduler, our laptop, etc… Before creating…
Analyzing queries in MySQL Database Service – Slow Query Log (part 1)
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…
Analyzing queries in MySQL Database Service
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…
OCI MySQL Database Service – Using a backup as source for a new instance
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…
MySQL 8.0 – Operations and Optimization (in Chinese)
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…
OCI MySQL Database Service – Backup Policy and Tags
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.…
MySQL Books: SQL Antipatterns, Volume 1
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…
