percona-toolkit工具pt-query-digest分析mysql慢查询
定期抓取慢慢查询日期及打印
0 9 * * * /data/backup/scripts/pt-query-digest.sh > /dev/null 2>&1
#!/bin/bash
perconatoolkit_home=/u01/software/mysql/percona-toolkit-2.2.14/bin
date=date "+%Y%m%d"
slowlog=/u01/mysql/mylog/MYORCL/slow.log
$perconatoolkit_home/pt-query-digest --since=24h date"".log" 2>&1
if [ date"".log" /opt/ptyf_bak/slowlogs/206.103 2>&1
else
exit
fi