Re: slave low speed in replication
Posted by:
Rick James
Date: March 30, 2010 08:28AM
Looking at the SlowLog on the Master can point to INSERT/UPDATE/REPLACE/DELETE queries that cause replication to be slow. Note that the Slave will be executing such queries one at a time. Also do SHOW PROCESSLIST (repeatedly) on the Slave -- lock for locks, slow SELECTs, etc. This could indicate interference between replication and readonly traffic.
And, yes, an 8-minute trigger is terrible.
Subject
Views
Written By
Posted
3143
March 29, 2010 01:02AM
Re: slave low speed in replication
1834
March 30, 2010 08:28AM
1768
March 30, 2010 06:43PM
1473
March 30, 2010 09:48PM
1651
March 31, 2010 01:05AM
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.