本文通过一系列MySQL命令展示了如何进行查询性能分析，包括设置查询跟踪、使用EXPLAIN分析查询计划、展示查询配置文件以及查看全局状态等操作。
SHOW PROCESSLIST;
SET profiling=1;
EXPLAIN SELECT uid FROM sns_doing GROUP BY uid ORDER BY dateline DESC LIMIT 0,10
SHOW PROFILE FOR QUERY 13;
SHOW PROFILES;
SHOW GLOBAL STATUS;
SHOW PROCESSLIST;
SET profiling=1;
EXPLAIN SELECT uid FROM sns_doing GROUP BY uid ORDER BY dateline DESC LIMIT 0,10
SHOW PROFILE FOR QUERY 103;
SHOW PROFILES;
SHOW GLOBAL STATUS LIKE '%prio%';
SELECT uid FROM sns_doing GROUP BY uid ORDER BY dateline DESC LIMIT 0,10
SELECT uid FROM sns_doing GROUP BY uid ORDER BY dateline DESC LIMIT 0,10
SHOW GLOBAL VARIABLES;
SET GLOBAL concurrent_insert=2;
SET profiling=1;
EXPLAIN SELECT uid FROM sns_doing GROUP BY uid ORDER BY dateline DESC LIMIT 0,10
SHOW PROFILE FOR QUERY 13;
SHOW PROFILES;
SHOW GLOBAL STATUS;
SHOW PROCESSLIST;
SET profiling=1;
EXPLAIN SELECT uid FROM sns_doing GROUP BY uid ORDER BY dateline DESC LIMIT 0,10
SHOW PROFILE FOR QUERY 103;
SHOW PROFILES;
SHOW GLOBAL STATUS LIKE '%prio%';
SELECT uid FROM sns_doing GROUP BY uid ORDER BY dateline DESC LIMIT 0,10
SELECT uid FROM sns_doing GROUP BY uid ORDER BY dateline DESC LIMIT 0,10
SHOW GLOBAL VARIABLES;
SET GLOBAL concurrent_insert=2;
扫一扫
2339
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
