STOP SLAVE [thread_type
[,thread_type
] ... ]thread_type
: IO_THREAD | SQL_THREAD
Stops the slave threads. STOP
SLAVE
requires the
SUPER
privilege.
Like START SLAVE
, this statement
may be used with the IO_THREAD
and
SQL_THREAD
options to name the thread or
threads to be stopped.
In MySQL 5.5, STOP SLAVE
waits
until the current replication event group affecting one or
more non-transactional tables has finished executing (if there
is any such replication group), or until the user issues a
KILL QUERY
or
KILL
CONNECTION
statement. (Bug#319, Bug#38205)
In old versions of MySQL (before 4.0.5), this statement was
called SLAVE STOP
. This usage is still
accepted in MySQL 5.5 for backward compatibility,
but is deprecated.