stop slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; reset master; reset slave; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; start slave; create temporary table t1 (n int); insert into t1 values(1); show status like 'Slave_open_temp_tables'; Variable_name Value Slave_open_temp_tables 1 delete from t1; show status like 'Slave_open_temp_tables'; Variable_name Value Slave_open_temp_tables 1 truncate t1; show status like 'Slave_open_temp_tables'; Variable_name Value Slave_open_temp_tables 1 show status like 'Slave_open_temp_tables'; Variable_name Value Slave_open_temp_tables 0