mysql使用sys和performance_schema查看慢查询

?

1 2 3 4 5 6 7 8 9 10 11 12 13

select     schema_name,     format_pico_time(total_latency) total_latency,     exec_count,     format_pico_time(total_latency/exec_count) latency_per_call,     query_sample_text from     sys.x$statements_with_runtimes_in_95th_percentile as t1     join performance_schema.events_statements_summary_by_digest as t2 on t2.digest = t1.digest where     schema_name not in ( 'performance_schema', 'sys' ) order by     ( total_latency / exec_count ) desc;

　　

?

1	select * from sys.statement_analysis where db not in ('performance_schema', 'sys') order by avg_latency desc;