rpl_drop_temp.result 420 Bytes
Newer Older
1 2 3 4 5 6 7
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 database if not exists mysqltest;
8 9
create temporary table mysqltest.t1 (n int)ENGINE=MyISAM;
create temporary table mysqltest.t2 (n int)ENGINE=MyISAM;
10 11 12
show status like 'Slave_open_temp_tables';
Variable_name	Value
Slave_open_temp_tables	0
unknown's avatar
unknown committed
13
drop database mysqltest;