Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1573

pt-query-digest log_timestamps = SYSTEM # No events processed

Details

    • Bug
    • Status: Done
    • Critical
    • Resolution: Reopened
    • 3.0.10
    • 3.0.13
    • 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

      1. 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

      1. No events processed. --type=genlog general.log
      1. No events processed.
         

      Attachments

        Activity

          People

            carlos.salguero Carlos Salguero (Inactive)
            Wen Liu
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour, 15 minutes
                1h 15m

                Smart Checklist