Details
-
Bug
-
Status: Done
-
Critical
-
Resolution: Reopened
-
3.0.10
-
None
-
None
-
CentOS 6.5
MySQL 5.7.21
Description
The pt-query-digest tool does not work if this parameter is configured.
my.cnf
log_timestamps = SYSTEM
pt-query-digest --type=genlog general.log
- No events processed.
default --> log_timestamps = UTC /usr/local/mysql-5.7.21/bin/mysqld, Version: 5.7.21-log (MySQL Community Server (GPL)). started with: Tcp port: 5721 Unix socket: /tmp/mysql5721.sock Time Id Command Argument 2018-06-26T14:27:28.337313Z 8 Connect [email protected] on using TCP/IP 2018-06-26T14:27:28.337556Z 8 Query set autocommit=0 2018-06-26T14:27:28.337915Z 8 Query set autocommit=1 2018-06-26T14:27:28.338096Z 8 Query show global status like 'Threads_connected' 2018-06-26T14:27:28.340302Z 8 Quit 2018-06-26T14:27:28.407973Z 9 Connect [email protected] on using TCP/IP 2018-06-26T14:27:28.408263Z 9 Query set autocommit=0 2018-06-26T14:27:28.408600Z 9 Query set autocommit=1 2018-06-26T14:27:28.408803Z 9 Query show global status like 'Com\_%' 2018-06-26T14:27:28.411209Z 9 Query show global status like 'Qcache_hits' 2018-06-26T14:27:28.413957Z 9 Quit
after --> log_timestamps = SYSTEM /usr/local/mysql-5.7.21/bin/mysqld, Version: 5.7.21-log (MySQL Community Server (GPL)). started with: Tcp port: 5721 Unix socket: /tmp/mysql5721.sock Time Id Command Argument 2018-06-26T22:25:04.564339+08:00 1029727 Quit 2018-06-26T22:25:10.986467+08:00 1029730 Connect [email protected] on using TCP/IP 2018-06-26T22:25:10.986724+08:00 1029730 Query set autocommit=0 2018-06-26T22:25:10.987120+08:00 1029730 Query set autocommit=1 2018-06-26T22:25:10.987284+08:00 1029730 Query show global status like 'Threads_connected' 2018-06-26T22:25:10.989675+08:00 1029730 Quit 2018-06-26T22:25:11.056126+08:00 1029731 Connect [email protected] on using TCP/IP 2018-06-26T22:25:11.056878+08:00 1029731 Query set autocommit=0 2018-06-26T22:25:11.057106+08:00 1029731 Query set autocommit=1 2018-06-26T22:25:11.057267+08:00 1029731 Query show global status like 'Com\_%' 2018-06-26T22:25:11.059806+08:00 1029731 Query show global status like 'Qcache_hits' 2018-06-26T22:25:11.062095+08:00 1029731 Quit
pt-query-digest --type=genlog general.log
- No events processed. --type=genlog general.log
- No events processed.