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