# create sequence with nocache

drop   sequence s ;

create sequence s increment=0 cache=0 ;

show create sequence s ;

# create procedure for the test

DROP PROCEDURE IF EXISTS seq_test;

DELIMITER $$

CREATE PROCEDURE seq_test(IN num_of_turn int, IN slp float)

BEGIN

    DECLARE finished  char(1);

	DECLARE cnt int;

	SET cnt=0;

    WHILE cnt <= num_of_turn DO

        SELECT NEXTVAL(s);

        SET cnt=cnt+1;

        SELECT SLEEP(slp);

    END WHILE;

END $$

DELIMITER ;

# node 1

call seq_test(1000, 0.3);

# node 2

call seq_test(1000, 0.2);