1# ==== Purpose ==== 2# 3# Provide a earier way to restart SQL thread when you want to stop sql thread 4# and then start it immediately. 5# 6# Sources stop_slave_sql.inc to stop SQL thread on the current connection. 7# Then issues START SLAVE SQL_THREAD and then waits until 8# the SQL threads have started, or until a timeout is reached. 9# 10# Please use this instead of 'STOP|START SLAVE SQL_THREAD', to reduce the risk of 11# test case bugs. 12# 13# 14# ==== Usage ==== 15# 16# [--let $slave_timeout= NUMBER] 17# [--let $rpl_debug= 1] 18# --source include/restart_slave_sql.inc 19# 20# Parameters: 21# $slave_timeout 22# See include/wait_for_slave_param.inc 23# 24# $rpl_debug 25# See include/rpl_init.inc 26 27 28--let $include_filename= restart_slave.inc 29--source include/begin_include_file.inc 30 31 32if (!$rpl_debug) 33{ 34 --disable_query_log 35} 36 37source include/stop_slave_sql.inc; 38START SLAVE SQL_THREAD; 39source include/wait_for_slave_sql_to_start.inc; 40 41 42--let $include_filename= restart_slave.inc 43--source include/end_include_file.inc 44