| 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; |