| Morten Kallesøe 2006-01-26, 4:56 pm |
| ------ _=_NextPart_001_01C6
21FD.D5D42832
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
that would make both
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
go to "No"
i only want to stop the Slave_SQL_Running and keep the Slave_IO running
so my show slave status would report the following:
Slave_IO_Running: Yes
Slave_SQL_Running: No
=20
=20
it happens if the mysql recives an update and failes during the update.
ive tried reading the documentation about mysql replication, but i =
cannot find what i am looking for.
____________________
____________
Fra: sheeri kritzer & #91;mailto:awfief@gm
ail.com]
Sendt: on 25-01-2006 22:56
Til: Morten Kalles=F8e
Cc: mysql@lists.mysql.com
Emne: Re: replication
SLAVE STOP;
or
STOP SLAVE;
work equally well.
Or am I not understanding your question correctly?
-Sheeri
On 1/25/06, Morten Kalles=F8e <morten@ngdc.net> wrote:
> Hi
>
> on a slave, is it possible to only stop the SQL Thread? =
(Slave_SQL_Running: Yes/No)
>
>
> i need to do some testing with my script and i got to make sure it =
reads that value correctly.
>
> regards
> Morten
>
>
------ _=_NextPart_001_01C6
21FD.D5D42832--
|