Extra writes to slave_worker_info table with duplicate GTIDs
Bug #1712911 reported by
Sveta Smirnova
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Invalid
|
Undecided
|
Unassigned | |||
5.7 |
Triaged
|
Medium
|
Unassigned |
Bug Description
After fix of bug #1669928 if one uses slave-parallel-
How to repeat:
1. Start 1 mysqld server (master)
2. Create 1 or more slaves of 1
3. Create one more slave of 1 and of 2 using multiple channels
4. Run write load on 1
5. Compare number of writes to table slave_worker_info on 2 and 3
Suggested fix:
Update slave_worker_info only once for each of unique GTIDs
tags: | added: performance |
To post a comment you must log in.
Upstream bug is still https:/ /bugs.mysql. com/bug. php?id= 85141, linked with bug #1669928, because it is still not fixed.