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 $slowlog>/data/backup/scripts/slowlogs/"repor{t}_{2}06.103_{3}306_{"}"$date"".log" 2>&1
if [ $?-eq0];thencp/data/backup/scripts/slowlogs/"repor{t}_{2}06.103_{3}306_{"}"$date"".log" /opt/ptyf_bak/slowlogs/206.103 2>&1
else
exit
fi