MySQL Slow Queries
Performance Schema
Performance Schema
events_statements_current
events_statements_history
events_statements_history_long
events_statements_summary_by_digest
events_statements_summary_by_user_by_event_name
events_statements_summary_by_host_by_event_name
Percona Toolkit
Percona Toolkit
pt-query-digest slow.log
pt-query-digest --processlist -h=myhost
pt-query-digest slow.log --report-histogram
Show slowest queries from slow.log
Show slowest queries from processlist on myhost
Show the distribution of query time in histogram form
Bibliography
Bibliography