From: Martin Gainty Date: March 19 2009 8:36pm Subject: RE: why is this happening? List-Archive: http://lists.mysql.com/mysql/216821 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_421a9791-67ee-429b-a1ac-7c215f7142c0_" --_421a9791-67ee-429b-a1ac-7c215f7142c0_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable what does the master db show for processlist ? master_mysql>show processlist ? Martin=20 ______________________________________________=20 Disclaimer and confidentiality note=20 This message is confidential and may be privileged. If you are not the inte= nded recipient=2C we kindly ask you to please inform the sender. Any unaut= horised dissemination or copying hereof is prohibited. This message serves = for information purposes only and shall not have any legally binding effect= . Given that e-mails can easily be subject to manipulation=2C we can not ac= cept any liability for the content provided. > Date: Thu=2C 19 Mar 2009 15:24:43 -0500 > Subject: why is this happening? > From: jlyons4435@stripped > To: mysql@stripped >=20 > I have a rather odd problem with a replication slave. >=20 > The slave has been down for a number of hours. Of course=2C both io and = sql > threads are stopped - from SHOW SLAVE STATUS: >=20 > Slave_IO_Running: No > Slave_SQL_Running: No >=20 >=20 > However=2C 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=2C= the > relay logs should stop filling up - right? Mine are definitely filling u= p. >=20 >=20 > Does anyonee know why the relay logs keep filling up after replication ha= s > broken? >=20 > Thanks >=20 > --=20 > Jim Lyons > Web developer / Database administrator > http://www.weblyons.com _________________________________________________________________ Hotmail=AE is up to 70% faster. Now good news travels really fast.=20 http://windowslive.com/online/hotmail?ocid=3DTXT_TAGLM_WL_HM_70faster_03200= 9= --_421a9791-67ee-429b-a1ac-7c215f7142c0_--