SET profiling=1;
DESCRIBE SELECT * FROM USER;
SHOW PROFILES;
SHOW PROFILE FOR QUERY 1;
SHOW PROFILE block io FOR QUERY 27;
query_id 就是 77
SHOW PROFILE block io FOR QUERY 77;
这几个sql可以查看 io 的使用次数
SET profiling=1;
DESCRIBE SELECT * FROM USER;
SHOW PROFILES;
SHOW PROFILE FOR QUERY 1;
SHOW PROFILE block io FOR QUERY 27;
query_id 就是 77
SHOW PROFILE block io FOR QUERY 77;
这几个sql可以查看 io 的使用次数