Currently percona-playback relies on thread_id to be present in the log to be able to differentiate between different sessions

[Ovais Tariq]

Currently percona-playback relies on Thread_id to be present in the log to be able to differentiate between the sessions. Upstream MySQL doesn't log the thread_id and hence percona-playback cannot be used to replay a realistic workload using upstream's slow log, because in that case all the queries are replayed using a single thread.

[Marek G (m-gizynski)]

You can use

sed 's/] Id:/] Thread_id:/'

as workaround.

[Ovais Tariq (ovais-tariq)]

This workaround will not work with every MySQL version. See a snippet of slow query log from MySQL 5.1 below:

# Time: 141009 16:51:35
# User@Host: msandbox[msandbox] @ localhost []
# Query_time: 0.015884 Lock_time: 0.000045 Rows_sent: 10 Rows_examined: 10
SET timestamp=1412866295;
select * from perm_conf limit 10;