Parallel replication performance
Hi!
I use row based replication, and in some (rather rare) circumstances the slave lags behind. Since I use a mechanical disk and the cpu load is low I assume that the disk is the bottleneck.
However, when enabling parallel replication the performance doubled. This surprised me, and seems to indicates that mysql didn’t manage to fully utilize the disk with one thread. Can anyone help me shed some light on this?
/Magnus Jäverberg
Subject
Views
Written By
Posted
Parallel replication performance
1550
October 29, 2015 09:48AM
737
October 29, 2015 09:21PM
844
October 30, 2015 03:09AM
872
October 30, 2015 02:37PM
828
November 12, 2015 03:24AM
854
November 26, 2015 09:57PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.