Add support for thread id format present in Percona Server 5.6 and MySQL 5.6 slow log

Bug #1197042 reported by Przemek on 2013-07-02
22
This bug affects 4 people
Affects Status Importance Assigned to Milestone
MOVED - Percona Playback
High
Unassigned

Bug Description

Since thread id information in slow log entries was introduced in upstream MySQL 5.6, though in different format than the existing one in Percona Server 5.5 and earlier, Percona Server 5.6 in sake of compatibility also uses the same format as MySQL 5.6.
Percona Playback (0.6) does not recognize the new format, so in case of slow log coming from MySQL or Percona Server 5.6 - the tool does not create threads based on that information, but executes all transactions in single thread.

Please add support for new thread id information present in MySQL 5.6.
Percona Server pre 5.6 format:
# Thread_id: 3 Schema: test Last_errno: 0 Killed: 0

5.6 format:
# User@Host: root[root] @ localhost [] Id: 3

tags: added: i33059
Changed in percona-playback:
status: New → Confirmed
Stewart Smith (stewart) on 2013-10-07
Changed in percona-playback:
milestone: none → 0.8
importance: Undecided → High
status: Confirmed → Triaged
Kenny Gryp (gryp) wrote :
tags: added: i49245
sidh (1-michael-l) wrote :

I'm concerned with this problem too.

It seems if you replace "Thread_Id:" by "Id:" on line 269 of the file :

percona-playback-0.7/percona_playback/query_log/query_log.cc

The problem is fixed .

Enclosed, the smallest "patch" we've ever seen

P.S. #1 Thanks to tanj who advises me to figure out the problem.

P.S. #2 I've been told that percona-playback is mostly unmaintained and we can't expect any bugfix in the future.

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers