多实例 mysql 数据库的巡检脚本
[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
参考：
