整理了部分mysql常用脚本,可用于监控。不定期更新。。。
检查锁:more check_lock.sh
#!bin/bash
while true
do
mysql -u root -p123456_ -H > ~/script/html/`date +"%Y%m%d"`w11.html
sleep 1
done
more check_lock.sql
SELECT r.trx_id waiting_trx_id,
r.trx_mysql_thread_id waiting_thread,
r.trx_query waiting_query,
b.trx_id blocking_trx_id,
b.trx_mysql_thread_id blocking_thread,
b.trx_query blocking_query,
now()
FROM information_schema.innodb_lock_waits w
INNER JOIN information_schema.innodb_trx b ON
b.trx_id = w.blocking_trx_id
INNER JOIN information_schema.innodb_trx r ON
r.trx_id = w.requesting_trx_id;
检查进程check_proc.sh
#!/bin/bash
while true
do
mysql -u root -p123456_ -H > ~/script/html/proc_`date +"%Y%m%d%H"`.html
sleep 2
done
cat check_proc.sql
select now(),id,user,host,db,command,time,state,info from information_schema.processlist where command not in (‘Sleep‘,‘Binlog Dump‘) and INFO not like ‘%information_schema.processlist%‘;
本文出自 “刚刚出壳的小鸟” 博客,请务必保留此出处http://qhd2004.blog.51cto.com/629417/1920342
mysql常用脚本
标签:mysql script monitor
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉
本文系统来源:http://qhd2004.blog.51cto.com/629417/1920342