Post

MySQLのスロークエリを手軽に監視する

Posted
By rengotaku
1 min read

How

#!/usr/bin/bash PASS=input_user_passowrd HOST=db_host_domain_or_ip SQL='SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE INFO IS NOT NULL AND INFO not like "SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST%"' while true; do echo "=== $(date +"%m/%d %H:%M:%S") =====================" >> /tmp/slowquery.log mysql -u root -p$PASS -h $HOST -e "$SQL" >> /tmp/slowquery.log sleep 3 done
database
mysql shell
This post is licensed under CC BY 4.0 by the author.