List:General Discussion« Previous MessageNext Message »
From:Jim Lyons Date:March 19 2009 8:24pm
Subject:why is this happening?
View as plain text  
I have a rather odd problem with a replication slave.

The slave has been down for a number of hours.  Of course, both io and sql
threads are stopped - from SHOW SLAVE STATUS:

           Slave_IO_Running: No
          Slave_SQL_Running: No


However, the relay logs are still being written to.  I was under the
impression that the slave's io thread was what brought data from the
master's bin log to the slave's relay log.  With the io thread stopped, the
relay logs should stop filling up - right?  Mine are definitely filling up.


Does anyonee know why the relay logs keep filling up after replication has
broken?

Thanks

-- 
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com

Thread
why is this happening?Jim Lyons19 Mar
  • Re: why is this happening?David Giragosian19 Mar
  • RE: why is this happening?Martin Gainty19 Mar
  • Re: why is this happening?Claudio Nanni19 Mar
    • Re: why is this happening?Jim Lyons21 Mar
      • RE: why is this happening?Martin Gainty22 Mar