Does not appear to be playing back correctly
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MOVED - Percona Playback |
Expired
|
Undecided
|
Unassigned |
Bug Description
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_
innodb_
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_
innodb_
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).
percona-playback
Version: 0.7