MySQL SQL话语性能分析

MySQL SQL语句性能分析
set profiling = 1;

select * from g_staff;

show profiles

SHOW profile CPU,BLOCK IO  FOR query 88;

select * from NFORMATION_SCHEMA.PROFILING
将 MySQL’s SHOW PROFILES 命令的结果转成适合阅读的格式
SET @query_id := 5;
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;