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.1.35. Previously, it took effect immediately. Beginning with MySQL
5.1.35, it waits until any 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
(http://bugs.mysql.com/bug.php?id=319), Bug#38205
(http://bugs.mysql.com/bug.php?id=38205))

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

