Debian Codegraph @

mysql-test/suite/innodb_undo/t/i_s_files_16k.test

raw
1 --source include/not_valgrind.inc
2 --source include/have_innodb_default_undo_tablespaces.inc
3
4 --echo #
5 --echo # WL7943 Implement INFORMATION_SCHEMA.FILES
6 --echo #
7
8 --echo # Mysqld is initialized in this test with with:
9 --echo # --innodb_rollback_segments=1
10 --echo # --bootstrap --innodb_page_size=16k
11 --echo # 2 implicit and 30 explicit undo tablespaces
12
13 let $cnt = 3;
14 while ($cnt <= 32)
15 {
16 let $undo_space_name = undo_$cnt;
17 let $datafile = undo_$cnt.ibu;
18 eval CREATE UNDO TABLESPACE $undo_space_name ADD DATAFILE '$datafile';
19 inc $cnt;
20 }
21
22 --source suite/innodb_undo/include/i_s_files.inc
23
24 --echo # Set all explicit undo tablespaces to inacitve.
25 let $cnt = 3;
26 while ($cnt <= 32)
27 {
28 let $undo_space_name = undo_$cnt;
29 eval ALTER UNDO TABLESPACE $undo_space_name SET INACTIVE;
30 inc $cnt;
31 }
32
33 --echo # Wait for all explicit undo tablespaces to become empty.
34 let $cnt = 3;
35 while ($cnt <= 32)
36 {
37 let $inactive_undo_space = undo_$cnt;
38 source include/wait_until_undo_space_is_empty.inc;
39 inc $cnt;
40 }
41
42 --echo # Drop all explicit undo tablespaces.
43 let $cnt = 3;
44 while ($cnt <= 32)
45 {
46 let $undo_space_name = undo_$cnt;
47 eval DROP UNDO TABLESPACE $undo_space_name;
48 inc $cnt;
49 }