mysql status monitoring

10초 단위로 table status 와 innodb 관련 항목 로깅. 

cat mysql_status_check.sql

show table status\G

SHOW STATUS LIKE 'innodb%';

cat logmysqlstat.sh*

#!/bin/bash

for x in {1..6}

do

        mysql -u root -p'password' -D mydb < mysql_status_check.sql > logs/mysqlstat_`date +%F_%T`;

        sleep 10;

done

crontab -l

* * * * * /home/ubuntu/logmysqlstat.sh