多实例 mysql 数据库的巡检脚本

最新推荐文章于 2024-05-30 10:20:21 发布

weixin_34203426

最新推荐文章于 2024-05-30 10:20:21 发布

阅读量173

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/u/1403438/blog/177495

版权

2019独角兽企业重金招聘Python工程师标准>>>

[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

转载于:https://my.oschina.net/u/1403438/blog/177495