Debian Codegraph @

mysql-test/suite/ndb/t/ndb_dd_initial_lg.test

raw
1 --source include/have_ndb.inc
2
3
4 #
5 # BUG#11762867
6 # - show that system started with InitialLogFileGroup automatically allocated
7 # extra reserved memory for use by the undo buffer
8 set @undo_buffer_pages = 20 * 32; # 20M / 32k pages
9 select (reserved > @undo_buffer_pages), (used>reserved) from ndbinfo.resources
10 where resource_name = 'TRANSACTION_MEMORY'
11 order by node_id;
12
13 # - show basic usability of the auto created log file group
14 create tablespace ts1
15 add datafile 'data1.dat'
16 use logfile group initial_lg1
17 initial_size 20M
18 engine = ndb;
19
20 create table t1 (
21 a int primary key,
22 b varchar(256)
23 ) tablespace ts1 storage disk, engine = ndb;
24
25 insert into t1 values
26 (1, "initial log file test");
27
28 drop table t1;
29 alter tablespace ts1 drop datafile 'data1.dat';
30 drop tablespace ts1;
31
32 # NOTE: Logfile group initial_lg1 is not dropped here since doing so leads
33 # to check-testcase complaining about the removal of undofile1.log
34 # and undofile2.log. These files are detected at the start due to
35 # the creation of the initial logfile group