mysql 性能收集脚本_mysql 收集状态和性能数据的脚本来自于高性能mysql

最新推荐文章于 2021-02-01 23:46:04 发布

宿管淑女坊

最新推荐文章于 2021-02-01 23:46:04 发布

阅读量72

点赞数

文章标签： mysql 性能收集脚本

本文链接：https://blog.csdn.net/weixin_33378570/article/details/113346269

版权

mysql 收集状态和性能数据的脚本

#!/bin/sh -x INTERVAL=10 PASSWORD='-uroot -proot' PREFIX=$INTERVAL-sec-status RUNFILE=/home/benchmarks/running mysql -e 'SHOW GLOBAL VARIABLES' $PASSWORD >> mysql-variables while test -e $RUNFILE; do file=$(date +%F_%I) sleep=$(date +%s.%N | awk "{print $INTERVAL - (\$1 % $INTERVAL)}") sleep $sleep ts="$(date + "TS %s.%N %F %T")" loadavg="$(uptime)" echo "$ts $loadavg" >> $PREFIX-${file}-status mysql -e 'SHOW GLOBAL STATUS' $PASSWORD >> $PREFIX-$(file)-status & echo "$ts $loadavg" >> $PREFIX-${file}-innodbstatus echo -e 'SHOW ENGINE INNODB STATUS\G' >> $PREFIX-${file}-innodbstatus & echo "$ts $loadavg" >> $PREFIX-${file}-processlist mysql -e 'SHOW FULL PROCESSLIST\G' $PASSWORD >> $PREFIX-${file}-processlist & echo $ts done echo Exiting because $RUNFILE does not exist.