The Slow Queries. Chances are the query is on that component somewhere. SELECT creation_time last_execution_time total_physical_reads total_logical_reads total_logical_writes execution_count total_worker.
The slow query logs will show you a list of queries that have been identified as slow based on the given values in the system variables as mentioned earlier. Mysqldumpslow -a varlogmysql-slowlog. Note that if your queries contain users passwords the slow query log may contain passwords too.
Slow Query Log Overview.
Mysqldumpslow -a varlogmysql-slowlog. Having slow queries means your users are more likely to see spinners or loading screens instead of the information theyve requested. To analyze the slow query log file you can parse it directly to review its contents. It lists data with the slowest performing first.