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

LP #1299387: 5.6 slow query log Thead_id becomes Id

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Kenny Gryp last update 08-08-2014 13:07:43

      The logging format of the thread id is changed in Percona Server 5.6

      1. Time: 140328 9:25:23
      2. User@Host: sbtest[sbtest] @ bench1 [10.116.191.113] Id: 652
      3. Schema: sbtest Last_errno: 0 Killed: 0
      4. Query_time: 0.000050 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0
      5. Bytes_sent: 11 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
      6. QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No
      7. Filesort: No Filesort_on_disk: No Merge_passes: 0
      8. No InnoDB statistics available for this query
        SET timestamp=1395998723;
        BEGIN;

      It's in the line with User@Host, Percona Server 5.5 had a separate Thread_id field. This prevents tools like pt-query-digest and percona-playback from working properly.

      See Bug: https://bugs.launchpad.net/percona-server/+bug/1298881

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: