1CREATE PROCEDURE populate_t1() 2BEGIN 3DECLARE i INT DEFAULT 1; 4while (i <= 40000) DO 5insert into t1 values (i, 'a', 'b'); 6SET i = i + 1; 7END WHILE; 8END | 9create table t1 10(keyc int, c1 char(100), c2 char(100), 11primary key(keyc)) engine = innodb; 12begin; 13call populate_t1(); 14delete from t1 where keyc < 20000; 15update t1 set c1 = 'mysql' where keyc > 20000; 16update t1 set c2 = 'oracle' where keyc > 20000; 17set global debug = "+d,ib_undo_trunc_before_checkpoint"; 18commit; 19set global innodb_fast_shutdown=0; 20Pattern "ib_undo_trunc_before_checkpoint" found 21# restart 22drop table t1; 23create table t1 24(keyc int, c1 char(100), c2 char(100), 25primary key(keyc)) engine = innodb; 26begin; 27call populate_t1(); 28delete from t1 where keyc < 20000; 29update t1 set c1 = 'mysql' where keyc > 20000; 30update t1 set c2 = 'oracle' where keyc > 20000; 31set global debug = "+d,ib_undo_trunc_before_ddl_log_start"; 32commit; 33set global innodb_fast_shutdown=0; 34Pattern "ib_undo_trunc_before_ddl_log_start" found 35# restart 36drop table t1; 37create table t1 38(keyc int, c1 char(100), c2 char(100), 39primary key(keyc)) engine = innodb; 40begin; 41call populate_t1(); 42delete from t1 where keyc < 20000; 43update t1 set c1 = 'mysql' where keyc > 20000; 44update t1 set c2 = 'oracle' where keyc > 20000; 45set global debug = "+d,ib_undo_trunc_before_truncate"; 46commit; 47set global innodb_fast_shutdown=0; 48Pattern "ib_undo_trunc_before_truncate" found 49# restart 50drop table t1; 51create table t1 52(keyc int, c1 char(100), c2 char(100), 53primary key(keyc)) engine = innodb; 54begin; 55call populate_t1(); 56delete from t1 where keyc < 20000; 57update t1 set c1 = 'mysql' where keyc > 20000; 58update t1 set c2 = 'oracle' where keyc > 20000; 59set global debug = "+d,ib_undo_trunc_before_ddl_log_end"; 60commit; 61set global innodb_fast_shutdown=0; 62Pattern "ib_undo_trunc_before_ddl_log_end" found 63# restart 64drop table t1; 65create table t1 66(keyc int, c1 char(100), c2 char(100), 67primary key(keyc)) engine = innodb; 68begin; 69call populate_t1(); 70delete from t1 where keyc < 20000; 71update t1 set c1 = 'mysql' where keyc > 20000; 72update t1 set c2 = 'oracle' where keyc > 20000; 73set global debug = "+d,ib_undo_trunc_trunc_done"; 74commit; 75set global innodb_fast_shutdown=0; 76Pattern "ib_undo_trunc_trunc_done" found 77# restart 78drop table t1; 79drop PROCEDURE populate_t1; 80