STOP SLAVE ["connection_name"] [thread_type [, thread_type] ... ] STOP ALL SLAVES [thread_type [, thread_type]] thread_type: IO_THREAD | SQL_THREAD
Stops the slave threads.
STOP SLAVE requires the
START SLAVE, this statement may be used with the
SQL_THREAD options to name the thread or threads to be stopped. In almost all cases, one never need to use the
STOP SLAVE 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.
STOP SLAVE doesn't delete the connection permanently. Next time you execute
START SLAVE or the MariaDB server restarts, the slave connection is restored with it's
original arguments. If you want to delete a connection, you should execute
STOP ALL SLAVES stops all your running slaves. It will give you a
note for every stopped connection. You can check the notes with
If there is only one nameless master, or the default master (as specified by the
default_master_connection system variable) is intended,
connection_name can be omitted. If provided, the
STOP SLAVE statement will apply to the specified master.
connection_name is case-insensitive.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.