0℃
#!/bin/bash
status=`mysql -uroot -p12345 -e"show slave status\G" | grep "Running" | awk '{if ($2 != "Yes") {print "No";exit 1}}'`
if [ "$status" == "No" ];then
echo "slave is not working!"
[ ! -f "/tmp/slave" ] && echo "Slave is not working!" | mail -s "Warn!MySQL Slave is not working" slave@centos.bz
touch /tmp/slave
else
echo "...
mysql主从监控, shell阅读全文
0℃
抓哪个进程干坏事前要先停掉syslog
/etc/init.d/syslog stop
echo 1 > /proc/sys/vm/block_dump
dmesg | egrep "READ|WRITE|dirtied" | egrep -o '([a-zA-Z]*)' | sort | uniq -c | sort -rn | head
1423 kjournald
1075 pdflush
209 indexer
3 cronolog
1 rnald
1 mysqld
不要忘记在抓完之后关掉block_dump和启动syslog
echo 0 > /proc/sys/vm/block_dump
/etc/init.d/syslog start
来源:http://space.itpub.net/16978544/viewspace-696756
IO等待阅读全文
0℃
需要从binlog里面找一条6月15创建的记录的修改历史,从6月15日到6月20日,一共有几十个mysql 的binlog,如果是人工操作,需要操作几十次,我们可以用shell来加快处理的速度
来到mysqlbinlog的目录 /u01/mysql/log,先列出最近5天被访问过的binlog文件列表
find . -atime -5 -print | grep mysql-bin.00 | xargs ls -lh
-rw-rw---- 1 mysql dba 501M Jun 14 18:04 ./mysql-bin.001090
-rw-rw---- 1 mysql dba 501M Jun 15 01:12 ./mysql-bin.001091
-rw-rw---- 1 mysql dba 501M Jun 15 02:10 ./mysql-bin.001...
binlog找到某条记录阅读全文