Does not appear to be playing back correctly

[monty solomon]

I created two new slaves and loaded the LRU from the master. One slave was using SSD with twice the RAM and buffer pool as the other.

I caused the two slaves to fail at the same place by forcing a replication error and then rotated the slow log on the master to start a fresh one using long_query_time=0.

I ran Percona Playback on two slaves using the slow log from the master.

It appears that the queries were not played back correctly. I expected the queries to complete properly in approximately the same amount of time and to return the same number of rows as expected. I don't understand why most of the queries were slower and there was such a significant different in row count.

non-SSD slave
innodb_buffer_pool_instances = 4
innodb_buffer_pool_size = 11G
Server version: 5.5.38-35.2-log Percona Server (GPL), Release 35.2, Revision 674

Report
------
Executed 674409 queries
Spent 00:12:21.451975 executing queries versus an expected 00:02:11.076691 time.
21830 queries were quicker than expected, 652578 were slower
A total of 12306 queries had errors.
Expected 8429352 rows, got 30856775 (a difference of 22427423)
Number of queries where number of rows differed: 434727.

Average of 1091.28 queries per connection (618 connections).

SSD slave
innodb_buffer_pool_instances = 7
innodb_buffer_pool_size = 23G
Server version: 5.5.38-35.2-log Percona Server (GPL), Release 35.2, Revision 674

Report
------
Executed 674409 queries
Spent 00:16:32.119805 executing queries versus an expected 00:02:11.076691 time.
26983 queries were quicker than expected, 647425 were slower
A total of 13477 queries had errors.
Expected 8429352 rows, got 30631436 (a difference of 22202084)
Number of queries where number of rows differed: 433642.

Average of 1091.28 queries per connection (618 connections).

[monty solomon (monty+launchpad)]

percona-playback
Version: 0.7

[Valerii Kravchuk (valerii-kravchuk)]

Please, specify the exact percona-playback command used. I specifically wonder if you had used --dispatcher-plugin thread-pool ?

[Launchpad Janitor (janitor)]

[Expired for Percona Playback because there has been no activity for 60 days.]