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