#!/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 "...

抓哪个进程干坏事前要先停掉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

需要从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...