performance_schemaを使用したスロークエリー抽出

slow_query.sql

-- ORDER BYとLIMITは必要応じて適宜修正
-- VIEWを作成すると便利
SELECT
  count_star AS cnt,
  sum_timer_wait/1e12 AS sum,
  min_timer_wait/1e12 AS min,
  avg_timer_wait/1e12 AS avg,
  max_timer_wait/1e12 AS max,
  sum_rows_sent AS sumRows,
  sum_rows_sent/count_star AS avgRows,
  schema_name AS db,
  digest_text AS query
FROM performance_schema.events_statements_summary_by_digest
ORDER BY sum DESC
LIMIT 10;