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
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