[MDEV-6680] Performance of domain_parallel replication is disappointing Created: 2014-09-02 Updated: 2014-11-13 Resolved: 2014-11-13 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Replication |
| Affects Version/s: | 10.0.13 |
| Fix Version/s: | 10.0.15 |
| Type: | Bug | Priority: | Major |
| Reporter: | Kristian Nielsen | Assignee: | Kristian Nielsen |
| Resolution: | Fixed | Votes: | 2 |
| Labels: | parallelslave, performance, replication | ||
| Description |
|
In March, Axel performed some benchmarks on parallel replication, as well as MySQL 5.6 parallel replication corresponds more or less to setting domain_id This needs to be investigated. It seems likely that there is a bottleneck or One possible explanation is related to the --slave-parallel-max-queued [Since Axel's benchmark works on an already generated master binlog, this This needs to be fixed somehow, for example simply by more frequently There might be other issues as well, needs to be investigated. Here is a pointer into the mail thread on maria-developers@ where this was https://lists.launchpad.net/maria-developers/msg07089.html (I thought I had filed this bug already, but did not find it in search, sorry |
| Comments |
| Comment by Daniel Black [ 2014-10-09 ] |
|
While it seems there can be more that slave_parallel_max_queued used for various reasons in the documentation can we have a global status variable to indicate how much is actually in the queue? I had a great success in increasing this to 512M (mixed replication where there are some fairly heavy multi row updates). |
| Comment by Kristian Nielsen [ 2014-11-13 ] |
|
Pushed to 10.0.15: http://lists.askmonty.org/pipermail/commits/2014-November/006975.html |