release/src/router/mysql/mysql-test/suite/engines/funcs/t/rpl_start_stop_slave.test

   1 source include/master-slave.inc;
   2
   3 #
   4 # Bug#6148 ()
   5 #
   6 connection slave;
   7 stop slave;
   8
   9 # Let the master do lots of insertions
  10 connection master;
  11 create table t1(n int);
  12 let $1=5000;
  13 disable_query_log;
  14 while ($1)
  15 {
  16  eval insert into t1 values($1);
  17  dec $1;
  18 }
  19 enable_query_log;
  20 save_master_pos;
  21
  22 connection slave;
  23 start slave;
  24 sleep 1;
  25 stop slave io_thread;
  26 start slave io_thread;
  27 sync_with_master;
  28
  29 connection master;
  30 drop table t1;
  31 save_master_pos;
  32
  33 connection slave;
  34 sync_with_master;
  35
  36 # End of 4.1 tests