From: Jim Lyons (jlyons4435gmail.com)
Date: Thu Mar 19 2009 - 15:24:43 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]