MySQL SQL语句性能分析_MySQL
程序员文章站
2022-05-24 15:02:32
...
bitsCN.com
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.PROFILINGWHERE QUERY_ID = @query_idGROUP BY STATEORDER BY Total_R DESC; 作者 bengda bitsCN.com
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.PROFILINGWHERE QUERY_ID = @query_idGROUP BY STATEORDER BY Total_R DESC; 作者 bengda bitsCN.com