--source include/master-slave.inc

#can be duplicate of 67202

connection slave;
stop slave;
change master TO MASTER_AUTO_POSITION = 1;
start slave;
sleep 10;

connection master;
CREATE TABLE `item` (`id` int(11) NOT NULL AUTO_INCREMENT,`item` varchar(10), PRIMARY KEY (`id`)) ENGINE=myisam DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

insert into item(item) values ('test1') ;
insert into item(item) values ('test2') ;
insert into item(item) values ('test3') ;
insert into item(item) values ('test4') ;
insert into item(item) select item from item;
insert into item(item) select item from item;
insert into item(item) select item from item;
insert into item(item) select item from item;
insert into item(item) select item from item;
insert into item(item) select item from item;
insert into item(item) select item from item;
insert into item(item) select item from item;
insert into item(item) select item from item;
insert into item(item) select item from item;

--sync_slave_with_master
--vertical_results
show slave status;

stop slave;
start slave;

sleep 10;

show slave status;