mysql主从复制巡检脚本_多实例 mysql 数据库的巡检脚本

最新推荐文章于 2023-03-10 17:11:35 发布

申敏妍SophiaSwan

最新推荐文章于 2023-03-10 17:11:35 发布

阅读量136

点赞数

文章标签： mysql主从复制巡检脚本

本文链接：https://blog.csdn.net/weixin_27146053/article/details/114828805

版权

[root@mysql-back ~]# cat mysql_check.sh

#!/bin/bash

TXT=system_check_$(date +%F-%H:%M).txt

echo '

memory

' >> $TXT

free -m >> $TXT

echo '

disks information

' >> $TXT

df -h >> $TXT

echo '

mysql status

' >> $TXT

netstat -nlp|grep mysql >> $TXT

echo '

3306

' >> $TXT

mysql -t -S /data/mysql/mysqldata3306/sock/mysql.sock -phabby -e "SHOW VARIABLES LIKE '%connection%';select substring_index(host,':',1),time,count(*)from INFORMATION_SCHEMA.processlist group by substring_index(host,':',1);SHOW STATUS LIKE '%connection%';" >> $TXT

echo '

3307

' >> $TXT

mysql -t -S /data/mysql/mysqldata3307/sock/mysql.sock -phabby -e "SHOW VARIABLES LIKE '%connection%';select substring_index(host,':',1),time,count(*)from INFORMATION_SCHEMA.processlist group by substring_index(host,':',1);SHOW STATUS LIKE '%connection%';" >> $TXT

echo '

3308

' >> $TXT

mysql -t -S /data/mysql/mysqldata3308/sock/mysql.sock -phabby -e "SHOW VARIABLES LIKE '%connection%';select substring_index(host,':',1),time,count(*)from INFORMATION_SCHEMA.processlist group by substring_index(host,':',1);SHOW STATUS LIKE '%connection%';" >> $TXT

echo '

3309

' >> $TXT

mysql -t -S /data/mysql/mysqldata3309/sock/mysql.sock -phabby -e "SHOW VARIABLES LIKE '%connection%';select substring_index(host,':',1),time,count(*)from INFORMATION_SCHEMA.processlist group by substring_index(host,':',1);SHOW STATUS LIKE '%connection%';" >> $TXT

cat $TXT