MySQL Forums
Forum List  »  Replication

Re: Replication modules
Posted by: James Day
Date: March 28, 2005 08:17PM

One performance improvement for replication with a very big lag - days and many log files. I sometimes stop the IO thread, so its disk activity isn't interfering with the SQL thread. It may be useful to have the IO thread be less active when there is a big replication lag. Perhaps sleeping for 30 seconds times the number of relay log files-1 if there was no change on the master since the last check.

Periodic replication like that could also be helpful for reporting slaves, in part because of caching effects.

Options: ReplyQuote


Subject
Views
Written By
Posted
2947
November 29, 2004 10:28AM
2166
March 28, 2005 04:42AM
Re: Replication modules
2097
March 28, 2005 08:17PM
1940
May 02, 2005 04:53PM
2066
May 02, 2005 05:23PM


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.