CREATE DATABASE IF NOT EXISTS test;
USE test;

DROP TABLE IF EXISTS `t2`;
CREATE TABLE `t2` (
  `a` int(11) NOT NULL AUTO_INCREMENT,
  `b` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `c` int(11) DEFAULT NULL,
  PRIMARY KEY (`a`),
  KEY `b` (`b`),
  KEY `c` (`c`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO t2(c) VALUES(0);
INSERT INTO t2(c) VALUES(1);
INSERT INTO t2(c) SELECT c FROM t2;
SELECT SLEEP(1);
INSERT INTO t2(c) SELECT c FROM t2;
SELECT SLEEP(1);
INSERT INTO t2(c) SELECT c FROM t2;
SELECT SLEEP(1);
INSERT INTO t2(c) SELECT c FROM t2;
SELECT SLEEP(1);
INSERT INTO t2(c) SELECT c FROM t2;
SELECT SLEEP(1);
INSERT INTO t2(c) SELECT c FROM t2;
SELECT SLEEP(1);
INSERT INTO t2(c) SELECT c FROM t2;
SELECT SLEEP(1);
INSERT INTO t2(c) SELECT c FROM t2;
SELECT SLEEP(1);
INSERT INTO t2(c) SELECT c FROM t2;
SELECT SLEEP(1);
INSERT INTO t2(c) SELECT c FROM t2;
SELECT SLEEP(1);
INSERT INTO t2(c) SELECT c FROM t2;
SELECT SLEEP(1);
INSERT INTO t2(c) SELECT c FROM t2;
SELECT SLEEP(1);
INSERT INTO t2(c) SELECT c FROM t2;
SELECT SLEEP(1);