mysql tips两则,都可以用来查看当前执行的语句
1
mysql -e "SHOW PROCESSLIST" | grep -v -i "sleep"
2
watch -n1 'mysql -e "SHOW FULL PROCESSLIST" | grep -v -i "Sleep"'
1
mysql -e "SHOW PROCESSLIST" | grep -v -i "sleep"
2
watch -n1 'mysql -e "SHOW FULL PROCESSLIST" | grep -v -i "Sleep"'