mysql锁表后如何解决_mysql大量锁表,不重启的情况下处理办法

最新推荐文章于 2022-05-04 19:41:13 发布

hhsssshh higob

最新推荐文章于 2022-05-04 19:41:13 发布

阅读量123

点赞数

文章标签： mysql锁表后如何解决

本文链接：https://blog.csdn.net/weixin_34604756/article/details/113344406

版权

mysql -u root -e "show processlist"|grep -i "Locked" >> locklist.txt;

for line in awk ‘{print $1}‘ locklist.txt

echo "kill $line;">>lock_kill.sql

done

查看mysql数据库表大小#!/bin/bash

database=cms

user=root

password=‘123456‘

mysql -u${user} -p${password} -e "use $database;show tables;" | sed ‘1d‘ | while read line; do mysql -u$user -p${password} $database -e "SELECT ‘${line}‘,ROUND(SUM(data_length/1024/1024),2) as data_length ,‘MB‘,round(SUM(index_length/1024/1024),2) as index_length,‘MB‘ FROM information_schema.TABLES WHERE information_schema.TABLES.TABLE_SCHEMA = ‘${database}‘ AND information_schema.TABLES.TABLE_NAME = ‘$line‘";done | grep -v data_length | awk ‘{print $1"\t"$2$3"\t"$4$5}‘ | sort -nrk2