# 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: 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})/;