MySQL Forums
Forum List  »  Optimizer & Parser

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
3063
March 29, 2010 01:02AM
Re: slave low speed in replication
1787
March 30, 2010 08:28AM
1719
March 30, 2010 06:43PM
1425
March 30, 2010 09:48PM
1604
March 31, 2010 01:05AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.