MySQL profile 性能分析

在msyql高性能中发现此代码，摘录自此，方便自己用

set @query_id = 1;

select state,sum(duration) as total_R,
round( 100*sum(duration)/(select sum(duration) from information_schema.PROFILING where QUERY_ID=@query_id),2) as pct_R,
count(*) as calls,
sum(duration)/count(*) as 'r/call'
from information_schema.PROFILING
where QUERY_ID = @query_id
group by STATE
order by total_R desc

flush status;

select * from teacher;

show status where variable_name like 'Handler%'
or variable_name like 'Created%'