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%'