shell脚本实现mysql锁表监控

可以使用以下shell脚本实现mysql锁表监控：

#!/bin/bash

# MySQL连接信息
MYSQL_USER="your_mysql_user"
MYSQL_PASS="your_mysql_password"
MYSQL_HOST="your_mysql_host"
MYSQL_PORT="your_mysql_port"
MYSQL_DB="your_database_name"

# 获取锁表数据
LOCK_TABLES=$(mysql -u $MYSQL_USER -p$MYSQL_PASS -h $MYSQL_HOST -P $MYSQL_PORT -e "SELECT CONCAT(TABLE_SCHEMA,'.',TABLE_NAME) AS TABLE_NAME, COUNT(*) AS LOCK_COUNT FROM INFORMATION_SCHEMA.INNODB_LOCKS WHERE LOCK_MODE = 'X' GROUP BY TABLE_SCHEMA,TABLE_NAME ORDER BY LOCK_COUNT DESC" $MYSQL_DB)

# 检查是否存在锁表
if [[ -z "$LOCK_TABLES" ]]; then
  echo "No tables are currently locked."
else
  echo "Locked tables:"
  echo "$LOCK_TABLES"
fi

将上述脚本保存为一个文件，例如`mysql_lock_monitor.sh`，然后在命令行中执行该文件即可，如下所示：

sh mysql_lock_monitor.sh

该脚本会连接到指定的MySQL数据库，并查询当前被锁定的表数据。如果不存在锁表，则输出"No tables are currently locked."，否则输出"Locked tables:"及具体的锁表数据。