您的当前位置:首页>全部文章>文章详情

mysql一些排查语句

gathin发表于:2023-07-11 09:32:21浏览:270次TAG: #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
腾讯云采购季云服务器一折促销