Debian Codegraph @

mysql-test/suite/innodb/r/undo_truncate.result

raw
1 SET GLOBAL innodb_fast_shutdown=0;
2 # restart: --innodb_undo_tablespaces=2
3 SET GLOBAL innodb_undo_log_truncate = 0;
4 === information_schema.innodb_sys_tablespaces and innodb_sys_datafiles ===
5 Space_Name Page_Size Zip_Size Path
6 innodb_undo001 DEFAULT DEFAULT MYSQLD_DATADIR//undo001
7 innodb_undo002 DEFAULT DEFAULT MYSQLD_DATADIR//undo002
8 innodb_temporary DEFAULT DEFAULT MYSQLD_DATADIR/ibtmp1
9 create table t1(keyc int primary key, c char(100)) engine = innodb;
10 create table t2(keyc int primary key, c char(100)) engine = innodb;
11 connect con1,localhost,root,,;
12 begin;
13 insert into t1 select seq,'a' from seq_1_to_20000;
14 connect con2,localhost,root,,;
15 begin;
16 insert into t2 select seq,'a' from seq_1_to_20000;
17 connection con1;
18 update t1 set c = 'mysql';
19 connection con2;
20 update t2 set c = 'mysql';
21 connection con1;
22 update t1 set c = 'oracle';
23 connection con2;
24 update t2 set c = 'oracle';
25 connection con1;
26 delete from t1;
27 connection con2;
28 delete from t2;
29 connection con1;
30 SET GLOBAL innodb_max_undo_log_size = @@GLOBAL.innodb_page_size * 4294967296;
31 SET GLOBAL innodb_undo_log_truncate = 1;
32 commit;
33 disconnect con1;
34 connection con2;
35 commit;
36 disconnect con2;
37 connection default;
38 SET GLOBAL innodb_max_purge_lag_wait=0;
39 SET GLOBAL innodb_max_undo_log_size=DEFAULT;
40 SET GLOBAL innodb_max_purge_lag_wait=0;
41 set global innodb_fast_shutdown=0;
42 # restart
43 drop table t1, t2;