If like me you are an old experienced MySQL DBA, to analyze your
MySQL workload, you certainly have used the slow query
long_query_time set to
The slow query log is a file that contains all the queries whose
execution time is greater than the value of
long_query_time. This file can be huge and uses up
all available disk space on busy systems.
Constantly writing to that file can also add an overhead to the server.
For those reasons, the slow query log is not available in MySQL Database Service (HeatWave) in OCI.
Plan B ?
As a DBA, what are my options for finding the queries that need to be optimized? As usual, the queries that consume the most time are the ones that need some attention
It can be a very long query or a short query executed too many times.
Currently the MySQL DBAs use …[Read more]