Debian Codegraph @

mysql-test/suite/innodb/t/innodb_doublewrite_dir_02.test

raw
1 # **********************************************************
2 # wl#5655: Test the functionality of the double write system
3 # variables with Non-Default values
4 # Test innodb_doublewrite_dir,innodb_doublewrite_files
5 # innodb_doublewrite_pages
6 # innodb_doublewrite_batch_size
7 # Test innodb_doublewrite_dir inside --datadir with
8 # "#DBWL-DIR", Check master.opt files
9 # **********************************************************
10 --source include/have_innodb_16k.inc
11 --source include/not_valgrind.inc
12
13 --let $MYSQLD_DATADIR =`SELECT @@datadir`
14
15 # Check datadir path
16 --replace_result $MYSQLD_DATADIR DATADIR
17 SELECT @@datadir;
18
19 # Check the following variables as set
20 --replace_result $MYSQLTEST_VARDIR DBWL-DIR
21 SELECT @@innodb_doublewrite_dir;
22
23 SELECT @@innodb_doublewrite_files;
24
25 SELECT @@innodb_doublewrite_pages;
26
27 SELECT @@innodb_doublewrite_batch_size;
28
29 # Check double write file exist
30 --file_exists $MYSQLTEST_VARDIR/mysqld.1/data/#DBWL-DIR/#ib_16384_0.dblwr
31
32 CREATE TABLE tab(c1 int, c2 TEXT);
33
34 INSERT INTO tab VALUES(1,'Test wl#5655');
35
36 SELECT * FROM tab;
37
38 #cleanup
39 DROP TABLE tab;