STOP SLAVE [thread_types]thread_types:    [thread_type [, thread_type] ... ]thread_type: IO_THREAD | SQL_THREAD

Stops the slave threads. STOP 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.12, "The Shutdown Process", for more information).

When using the row-based logging format: You should execute STOP SLAVE or STOP SLAVE SQL_THREAD on the slave prior to shutting down the slave server if you are replicating any tables that use a nontransactional storage engine (see the Note later in this section).

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.7, STOP SLAVE causes an implicit commit of an ongoing transaction. See Section 13.3.3, "Statements That Cause an Implicit Commit".

Beginning with MySQL 5.7.1, gtid_next must be set to AUTOMATIC before issuing this statement (Bug #16062608).


In MySQL 5.7, STOP SLAVE waits until the current replication event group affecting one or more nontransactional 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 very old versions of MySQL (before 4.0.5), this statement was called SLAVE STOP. In MySQL 5.7, that syntax produces an error.

Spec-Zone.ru - all specs in one place