监控数据库锁的脚本

四、长稳everdb随机时间产生锁超标，用于锁定位的脚本

适用场景：长稳中从监控查看everdb随机时间产生锁超标，everdb查询锁的SQL只能在锁

脚本内容：
catch_lock.sh host pwd times

参数说明：
host数据节点ip
pwd mysql root的密码
times执行的次数，间隔10秒取一次，所以用times控制执行时长，比如执行10分钟600秒，times传入60

 

脚本内容：

host=$1

pwd=$2

times=$3

echo "Host: $host, Password: $pwd, Exec times: $times."

for i in `seq 1 $times`

do

echo "##############################################"

date

echo "# show processlist;"

mysql -uroot -p$pwd -P16315 -h$host -e "show processlist;"

echo "# select blocking_pid from sys.schema_table_lock_waits;"

mysql -uroot -p$pwd -P16315 -h$host -e "select blocking_pid from sys.schema_table_lock_waits;"

echo "# select * from information_schema.innodb_trx\G"

mysql -uroot -p$pwd -P16315 -h$host -e "select * from information_schema.innodb_trx\G"

echo "# select * from sys.innodb_lock_waits\G"

mysql -uroot -p$pwd -P16315 -h$host -e "select * from sys.innodb_lock_waits\G"

echo "# select * from information_schema.innodb_lock_waits\G"

mysql -uroot -p$pwd -P16315 -h$host -e "select * from information_schema.innodb_lock_waits\G"

echo "# select * from information_schema.innodb_locks\G"

mysql -uroot -p$pwd -P16315 -h$host -e "select * from information_schema.innodb_locks\G"

sleep 10s

done