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

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

    Details

    • Type: Bug
    • Status: Done
    • Priority: Critical
    • Resolution: Reopened
    • Affects Version/s: 3.0.10
    • Fix Version/s: 3.0.13
    • Component/s: None
    • Labels:
      None
    • Environment:

      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 mysql_common@127.0.0.1 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 mysql_common@127.0.0.1 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 mysql_common@127.0.0.1 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 mysql_common@127.0.0.1 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.
         

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                carlos.salguero Carlos Salguero
                Reporter:
                Wen Liu
              • Votes:
                0 Vote for this issue
                Watchers:
                3 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