pt5 mysql预处理_pt-quey-digest分析mysql 5.7 慢日志

# Time: 2016-01-22T02:58:34.696629Z

# User@Host: root[root] @ localhost []  Id: 53549

# Query_time: 35.915969  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0

SET timestamp=1453431514;

UPDATE sbtest1 SET k=k+1 WHERE id=499794;

# Time: 2016-01-22T02:58:34.696676Z

# User@Host: root[root] @ localhost []  Id: 53556

# Query_time: 35.916041  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0

SET timestamp=1453431514;

UPDATE sbtest1 SET k=k+1 WHERE id=458683;

# Time: 2016-01-22T02:58:34.696735Z

# User@Host: root[root] @ localhost []  Id: 53554

# Query_time: 35.911712  Lock_time: 0.000000 Rows_sent: 0  Rows_examined: 0

SET timestamp=1453431514;

UPDATE sbtest1 SET k=k+1 WHERE id=504478;

# Time: 2016-01-22T02:58:34.696664Z

# User@Host: root[root] @ localhost []  Id: 53553

time列有个新变化，日期与时间之间加了个T 导致pt-query-digest 无法按时间段分析使用

官方解读

Timestamps are written using ISO 8601 / RFC 3339 format: YYYY-MM-DDThh:mm:ss.uuuuuu plus a tail value of Z signifying Zulu time (UTC) or±hh:mm (an offset from UTC).

解决方案：

修改pt-query-digest源码中正则匹配 如下：

my $slow_log_ts_line = qr/^# Time: ([0-9: ]{15})/;

修改为如下匹配

my $slow_log_ts_line = qr/^# Time: ([0-9:\-.ZT]{27})/;