Bug #69585 | low-priority-updates not working on replication slave | ||
---|---|---|---|
Submitted: | 26 Jun 2013 11:23 | Modified: | 22 Jul 2014 18:40 |
Reporter: | adrian smith | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: MyISAM storage engine | Severity: | S1 (Critical) |
Version: | 5.5.30 x64, 5.5.39, 5.6.21, 5.7.5 | OS: | Any (MS Windows W2K8 64bit, Linux) |
Assigned to: | CPU Architecture: | Any | |
Tags: | low-priority-updates, myisam, RBR, row-based replication |
[26 Jun 2013 11:23]
adrian smith
[1 Aug 2013 8:35]
adrian smith
Hi, I've upgraded this to S1 because the issue is creating total unresponsiveness for customers on a regular basis when running reports. Our workaround alleviates the situation somewhat but it is impractical to implement fully to totally remove the issue. Thanks Adrian
[22 Jul 2014 18:38]
Sveta Smirnova
Thank you for the report. Verified as described. One more workaround: use SBR.
[22 Jul 2014 18:41]
Sveta Smirnova
test case for MTR
Attachment: rpl_bug69585.test (application/octet-stream, text), 479 bytes.
[22 Jul 2014 18:41]
Sveta Smirnova
option file for slave
Attachment: rpl_bug69585-slave.opt (application/octet-stream, text), 45 bytes.