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.