5.6 slow query log Thead_id becomes Id
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
Medium
|
Frank Cizmich |
Bug Description
The logging format of the thread id is changed in Percona Server 5.6
# Time: 140328 9:25:23
# User@Host: sbtest[sbtest] @ bench1 [10.116.191.113] Id: 652
# Schema: sbtest Last_errno: 0 Killed: 0
# Query_time: 0.000050 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 Rows_affected: 0
# Bytes_sent: 11 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
# QC_Hit: No Full_scan: No Full_join: No Tmp_table: No Tmp_table_on_disk: No
# Filesort: No Filesort_on_disk: No Merge_passes: 0
# No InnoDB statistics available for this query
SET timestamp=
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:/
Related branches
- Daniel Nichter: Approve
-
Diff: 484 lines (+200/-49)9 files modifiedbin/pt-index-usage (+23/-9)
bin/pt-query-digest (+12/-6)
bin/pt-table-usage (+41/-16)
bin/pt-upgrade (+23/-9)
lib/SlowLogParser.pm (+14/-6)
t/lib/SlowLogParser.t (+64/-0)
t/lib/samples/slowlogs/slow060.txt (+10/-0)
t/lib/samples/slowlogs/slow061.txt (+10/-0)
t/pt-query-digest/since_until.t (+3/-3)
Changed in percona-toolkit: | |
status: | New → In Progress |
importance: | Undecided → Medium |
assignee: | nobody → Frank Cizmich (frank-cizmich) |
milestone: | none → 2.2.10 |
Changed in percona-toolkit: | |
status: | In Progress → Fix Committed |
Changed in percona-toolkit: | |
status: | Fix Committed → Fix Released |
Attached is a very basic patch:
- it doesn't work on non 56
- renames Id from slow query log to Thread_id (as everything is built to work with this event name)
- SlowLogParser and SlowLogWriter need changes, not only the bin/pt-query-digest