Debian Codegraph @

mysql-test/suite/innodb/t/innodb_doublewrite_dir_01.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 outside of --datadir
8 # **********************************************************
9 --source include/have_innodb_16k.inc
10 --source include/not_valgrind.inc
11
12 --let $MYSQLD_DATADIR =`SELECT @@datadir`
13
14 # Check datadir path
15 --replace_result $MYSQLD_DATADIR DATADIR
16 SELECT @@datadir;
17
18 # Check the following variables as set
19 --replace_result $MYSQL_TMP_DIR TMP_DIR
20 SELECT @@innodb_doublewrite_dir;
21
22 SELECT @@innodb_doublewrite_files;
23
24 SELECT @@innodb_doublewrite_pages;
25
26 SELECT @@innodb_doublewrite_batch_size;
27
28 # Check double write file exist
29 --file_exists $MYSQL_TMP_DIR/#DBWL-DIR/#ib_16384_0.dblwr
30
31 CREATE TABLE tab(c1 int, c2 TEXT);
32
33 INSERT INTO tab VALUES(1,'Test wl#5655');
34
35 SELECT * FROM tab;
36
37 #cleanup
38 DROP TABLE tab;