Find slowest queries

from the Artful MySQL Tips List


Performance_schema must be enabled.


SELECT 

  digest_text, count_star, first_seen, last_seen

  avg_timer_wait/1024/1024/1024/1024 as avg_wait_secs

FROM performance_schema.events_statements_summary_by_digest 

ORDER BY avg_timer_wait DESC

LIMIT 10;






Return to the Artful MySQL Tips page