Syntax:
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.

*Note*: The transactional behavior of STOP 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 KILL
CONNECTION statement. (Bug #319, Bug #38205)

URL: http://dev.mysql.com/doc/refman/5.0/en/stop-slave.html

