STOP SLAVE [
thread_type] ... ]
thread_type: IO_THREAD | SQL_THREAD
Stops the slave threads.
SLAVE requires the
SUPER privilege. Recommended best
practice is to execute
STOP SLAVE on the
slave before stopping the slave server (see
Section 5.1.10, “The Server Shutdown Process”, for more information).
START SLAVE, this statement
may be used with the
SQL_THREAD options to name the thread or
threads to be stopped.
The transactional behavior of
SLAVE changed in MySQL 5.0.82. Previously, it took
effect immediately; beginning with MySQL 5.0.82, it waits
until the current replication event group (if any) has
finished executing, or until the user issues a
KILL QUERY or
CONNECTION statement. (Bug #319, Bug #38205)
In old versions of MySQL (before 4.0.5), this statement was
SLAVE STOP. This usage is still
accepted in MySQL 5.0 for backward compatibility,
but is deprecated and is removed in MySQL 5.6.