29. pt-table-usage


pt-table-usage --query="select * from t01 join t02 on t01.id=t02.id where t01.code=2"


pt-table-usage /data/mysql3306/data/slow.log

简单分析下语句结构,不如explain有用。


Query_id: 0xCAE49665073A58D1.1
SELECT t01
SELECT t02
JOIN t01
JOIN t02
WHERE t01

wechat: nick753159 qq: 417966852 email: nzq42@qq.com base: shanghai
原文地址:https://www.cnblogs.com/cyberbit/p/pt-table-usage.html