Gecko [ www.jdcpatala.org ]

Name	Size	Permission
i_s_files_16k.result	2.51 KB	-rw-r--r--
i_s_files_32k.result	2.51 KB	-rw-r--r--
i_s_files_4k.result	2.51 KB	-rw-r--r--
i_s_files_64k.result	2.51 KB	-rw-r--r--
i_s_files_8k.result	2.51 KB	-rw-r--r--
trunc_multi_client_01.result	995 B	-rw-r--r--
trunc_multi_client_02.result	995 B	-rw-r--r--
truncate.result	568 B	-rw-r--r--
truncate_recover.result	2.23 KB	-rw-r--r--
undo_space_id.result	876 B	-rw-r--r--

Code Editor : truncate_recover.result

CREATE PROCEDURE populate_t1()
BEGIN
DECLARE i INT DEFAULT 1;
while (i <= 40000) DO
insert into t1 values (i, 'a', 'b');
SET i = i + 1;
END WHILE;
END |
create table t1
(keyc int, c1 char(100), c2 char(100),
primary key(keyc)) engine = innodb;
begin;
call populate_t1();
delete from t1 where keyc < 20000;
update t1 set c1 = 'mysql' where  keyc > 20000;
update t1 set c2 = 'oracle' where  keyc > 20000;
set global debug = "+d,ib_undo_trunc_before_checkpoint";
commit;
set global innodb_fast_shutdown=0;
Pattern "ib_undo_trunc_before_checkpoint" found
# restart
drop table t1;
create table t1
(keyc int, c1 char(100), c2 char(100),
primary key(keyc)) engine = innodb;
begin;
call populate_t1();
delete from t1 where keyc < 20000;
update t1 set c1 = 'mysql' where  keyc > 20000;
update t1 set c2 = 'oracle' where  keyc > 20000;
set global debug = "+d,ib_undo_trunc_before_ddl_log_start";
commit;
set global innodb_fast_shutdown=0;
Pattern "ib_undo_trunc_before_ddl_log_start" found
# restart
drop table t1;
create table t1
(keyc int, c1 char(100), c2 char(100),
primary key(keyc)) engine = innodb;
begin;
call populate_t1();
delete from t1 where keyc < 20000;
update t1 set c1 = 'mysql' where  keyc > 20000;
update t1 set c2 = 'oracle' where  keyc > 20000;
set global debug = "+d,ib_undo_trunc_before_truncate";
commit;
set global innodb_fast_shutdown=0;
Pattern "ib_undo_trunc_before_truncate" found
# restart
drop table t1;
create table t1
(keyc int, c1 char(100), c2 char(100),
primary key(keyc)) engine = innodb;
begin;
call populate_t1();
delete from t1 where keyc < 20000;
update t1 set c1 = 'mysql' where  keyc > 20000;
update t1 set c2 = 'oracle' where  keyc > 20000;
set global debug = "+d,ib_undo_trunc_before_ddl_log_end";
commit;
set global innodb_fast_shutdown=0;
Pattern "ib_undo_trunc_before_ddl_log_end" found
# restart
drop table t1;
create table t1
(keyc int, c1 char(100), c2 char(100),
primary key(keyc)) engine = innodb;
begin;
call populate_t1();
delete from t1 where keyc < 20000;
update t1 set c1 = 'mysql' where  keyc > 20000;
update t1 set c2 = 'oracle' where  keyc > 20000;
set global debug = "+d,ib_undo_trunc_trunc_done";
commit;
set global innodb_fast_shutdown=0;
Pattern "ib_undo_trunc_trunc_done" found
# restart
drop table t1;
drop PROCEDURE populate_t1;

${this.title}

Code Editor : truncate_recover.result