Re: Relay log Question

2013-01-17 Thread Nitin Mehta
: Akshay Suryavanshi akshay.suryavansh...@gmail.com To: Wayne Leutwyler wleut...@columbus.rr.com Cc: mysql@lists.mysql.com Sent: Wednesday, January 9, 2013 1:42 AM Subject: Re: Relay log Question Also, you may want to see, if at all new file is really getting every hour exactly, if any cron'd script

Re: Relay log Question

2013-01-08 Thread Akshay Suryavanshi
Hi, Please re-phrase your question. The relay logs are created as and when required by the Slave_SQL thread. Once all the events in the relay logs are executed the relay log would be purged by the Slave_SQL thread. By setting relay_log_purge=0 you are disabling this automatic purge option. So

Re: Relay log Question

2013-01-08 Thread Akshay Suryavanshi
Also, you may want to see, if at all new file is really getting every hour exactly, if any cron'd script runs, which executes flush logs on the slave server. That will also rotate relay log. Cheers On Wed, Jan 9, 2013 at 1:35 AM, Akshay Suryavanshi akshay.suryavansh...@gmail.com wrote: Hi,