MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

Re: slave downloads server-relay-logs until hard drive fills and crashes server
Posted by: Harrison Fisk
Date: March 18, 2005 07:38PM

Hi,

There is a setting called relay_log_space_limit which can specify the total amount of space that replication can use for storing relay logs. If it reaches the limit than the IO_THREAD will wait for the SQL_THREAD to catch up and delete the relay logs.

Normally it isn't too important as the SQL_THREAD cleans up after it has used the logs. Is there any reason that your slave is getting so far behind? That sounds like an unusual situation.

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
slave downloads server-relay-logs until hard drive fills and crashes server
2957
nate meyer
March 17, 2005 04:12PM
Re: slave downloads server-relay-logs until hard drive fills and crashes server
2192
nate meyer
March 17, 2005 04:22PM
Re: slave downloads server-relay-logs until hard drive fills and crashes server
2227
Harrison Fisk
March 18, 2005 07:38PM


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.