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