1# ==== Purpose ==== 2# 3# Stop all dump threads on the server of the current connection. 4# 5# ==== Usage ==== 6# 7# --source include/stop_dump_threads.inc 8 9--let $include_filename= stop_dump_threads.inc 10--source include/begin_include_file.inc 11 12 13--let $_sdt_show_rpl_debug_info_old= $show_rpl_debug_info 14--let $show_rpl_debug_info= 1 15--disable_query_log 16--disable_result_log 17 18--let $_sdt_dump_thread_id= `SELECT ID FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND = 'Binlog dump'` 19 20while ($_sdt_dump_thread_id != '') 21{ 22 eval KILL $_sdt_dump_thread_id; 23 --let $wait_condition= SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE ID = $_sdt_dump_thread_id 24 --source include/wait_condition.inc 25 26 --let $_sdt_dump_thread_id= `SELECT ID FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND = 'Binlog dump'` 27} 28 29--let $show_rpl_debug_info= $_sdt_show_rpl_debug_info_old 30 31--let $include_filename= stop_dump_threads.inc 32--source include/end_include_file.inc 33