From: Martin Gainty Date: March 22 2009 4:13pm Subject: RE: why is this happening? List-Archive: http://lists.mysql.com/mysql/216843 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_138a5c0f-3ce3-45ea-8262-326145677916_" --_138a5c0f-3ce3-45ea-8262-326145677916_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Jim can you verify the process is quiesced from MySQL (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: Sat=2C 21 Mar 2009 08:57:11 -0500 > Subject: Re: why is this happening? > From: jlyons4435@stripped > To: claudio.nanni@stripped > CC: mysql@stripped >=20 > No=2C there's only one mysqld process running. Thanks=2C tho. >=20 > On Thu=2C Mar 19=2C 2009 at 3:56 PM=2C Claudio Nanni wrote: >=20 > > I am afraid you have two mysql instances up on the same host. > > > > ps -ef | grep mysql ? > > > > > > Claudio > > > > > > Jim Lyons wrote: > > > >> I have a rather odd problem with a replication slave. > >> > >> The slave has been down for a number of hours. Of course=2C both io a= nd sql > >> threads are stopped - from SHOW SLAVE STATUS: > >> > >> Slave_IO_Running: No > >> Slave_SQL_Running: No > >> > >> > >> 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 fillin= g > >> up. > >> > >> > >> Does anyonee know why the relay logs keep filling up after replication= has > >> broken? > >> > >> Thanks > >> > >> > >> > > > > >=20 >=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. http://windowslive.com/online/hotmail?ocid=3DTXT_TAGLM_WL_HM_70faster_03200= 9= --_138a5c0f-3ce3-45ea-8262-326145677916_--