--source include/have_innodb.inc --source include/have_sequence.inc --disable_abort_on_error --disable_warnings CREATE TABLE `oltp3` ( `id` int(10) unsigned NOT NULL auto_increment, `c` char(250) NOT NULL default '', PRIMARY KEY (`id`)) ENGINE=innodb /* E_R Gendata QNO 19 CON_ID 6 */ ; INSERT INTO oltp3 VALUES (NULL, REPEAT('a',250)); let $num = 10; while ($num) { INSERT INTO oltp3 (c) SELECT c FROM oltp3; OPTIMIZE TABLE `oltp3` /* E_R Thread1 QNO 231 CON_ID 12 */ ; --echo $num dec $num; } # OPTIMIZE TABLE `oltp3` /* E_R Thread1 QNO 231 CON_ID 12 */ ; --enable_abort_on_error CREATE TEMPORARY TABLE t13 (col1 INT); DROP TABLE t13; DROP TABLE `oltp3`; --die