mysql一些排查语句

进程锁查看

 #~: mysql -uroot -e "show processlist"  |grep -i "Locked" >> lock.log

LogBin排查

#~: sudo /usr/local/mysql/bin/mysqlbinlog  --no-defaults --base64-output=decode-rows -vv --start-position=377826176  /mysql/3306/binlog/mysql-bin.021038 -r ~/bin.sql