CyberBit

Python+MySQL

32. pt-visual-explain

 


mysql -e "explain select name from db01.t01 where code>1" |pt-visual-explain

 

 

echo "select name from t01 where code>1" >pt-explain.sql

pt-visual-explain --host 192.168.100.101 --port 3306 --user admin --password admin \
--database db01 \
--clustered-pk \
--connect pt-explain.sql

 

posted on 2018-12-01 09:35  CyberBit  阅读(194)  评论(0编辑  收藏  举报

导航