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