首页 > 代码库 > mysql常用脚本
mysql常用脚本
整理了部分mysql常用脚本,可用于监控。不定期更新。。。
检查锁:
more check_lock.sh #!bin/bash while true do mysql -u root -p123456_ -H < ~/script/check_lock.sql >> ~/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/check_proc.sql >> ~/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常用脚本
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。