gaodaima.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&r本文来源gao($daima.com搞@代@#码8网^squo;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 gaodaima.com
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：MySQL SQL语句性能分析_MySQL
转载请注明原文链接：MySQL SQL语句性能分析_MySQL
