diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2016-12-30 12:26:05 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2016-12-30 12:26:05 +0200 |
| commit | 1ab3866de237fad4cb2cc6f532aa7750e15dd723 (patch) | |
| tree | 2e8063df3d6094f82eb8ca1105866b821ff30b96 /mysql-test/suite | |
| parent | d4342702bf6ddc4dd63b620fecd4e40881039ef9 (diff) | |
| download | mariadb-git-1ab3866de237fad4cb2cc6f532aa7750e15dd723.tar.gz | |
MDEV-11687 innodb_use_fallocate has no effect
The configuration parameter innodb_use_fallocate, which is mapped to
the variable srv_use_posix_fallocate, has no effect in MariaDB 10.2.2
or MariaDB 10.2.3.
Thus the configuration parameter and the variable should be removed.
Diffstat (limited to 'mysql-test/suite')
3 files changed, 0 insertions, 57 deletions
diff --git a/mysql-test/suite/sys_vars/r/innodb_use_fallocate_basic.result b/mysql-test/suite/sys_vars/r/innodb_use_fallocate_basic.result deleted file mode 100644 index 57b4b9eb94c..00000000000 --- a/mysql-test/suite/sys_vars/r/innodb_use_fallocate_basic.result +++ /dev/null @@ -1,21 +0,0 @@ -select @@global.innodb_use_fallocate; -@@global.innodb_use_fallocate -0 -select @@session.innodb_use_fallocate; -ERROR HY000: Variable 'innodb_use_fallocate' is a GLOBAL variable -show global variables like 'innodb_use_fallocate'; -Variable_name Value -innodb_use_fallocate OFF -show session variables like 'innodb_use_fallocate'; -Variable_name Value -innodb_use_fallocate OFF -select * from information_schema.global_variables where variable_name='innodb_use_fallocate'; -VARIABLE_NAME VARIABLE_VALUE -INNODB_USE_FALLOCATE OFF -select * from information_schema.session_variables where variable_name='innodb_use_fallocate'; -VARIABLE_NAME VARIABLE_VALUE -INNODB_USE_FALLOCATE OFF -set global innodb_use_fallocate=1; -ERROR HY000: Variable 'innodb_use_fallocate' is a read only variable -set session innodb_use_fallocate=1; -ERROR HY000: Variable 'innodb_use_fallocate' is a read only variable diff --git a/mysql-test/suite/sys_vars/r/sysvars_innodb.result b/mysql-test/suite/sys_vars/r/sysvars_innodb.result index 51878fb1748..602bbc50f77 100644 --- a/mysql-test/suite/sys_vars/r/sysvars_innodb.result +++ b/mysql-test/suite/sys_vars/r/sysvars_innodb.result @@ -2581,20 +2581,6 @@ NUMERIC_BLOCK_SIZE NULL ENUM_VALUE_LIST OFF,ON READ_ONLY YES COMMAND_LINE_ARGUMENT NONE -VARIABLE_NAME INNODB_USE_FALLOCATE -SESSION_VALUE NULL -GLOBAL_VALUE OFF -GLOBAL_VALUE_ORIGIN COMPILE-TIME -DEFAULT_VALUE OFF -VARIABLE_SCOPE GLOBAL -VARIABLE_TYPE BOOLEAN -VARIABLE_COMMENT Preallocate files fast, using operating system functionality. On POSIX systems, posix_fallocate system call is used. -NUMERIC_MIN_VALUE NULL -NUMERIC_MAX_VALUE NULL -NUMERIC_BLOCK_SIZE NULL -ENUM_VALUE_LIST OFF,ON -READ_ONLY YES -COMMAND_LINE_ARGUMENT NONE VARIABLE_NAME INNODB_USE_MTFLUSH SESSION_VALUE NULL GLOBAL_VALUE OFF diff --git a/mysql-test/suite/sys_vars/t/innodb_use_fallocate_basic.test b/mysql-test/suite/sys_vars/t/innodb_use_fallocate_basic.test deleted file mode 100644 index 655893be98e..00000000000 --- a/mysql-test/suite/sys_vars/t/innodb_use_fallocate_basic.test +++ /dev/null @@ -1,22 +0,0 @@ ---source include/have_innodb.inc -# bool readonly - -# -# show values; -# -select @@global.innodb_use_fallocate; ---error ER_INCORRECT_GLOBAL_LOCAL_VAR -select @@session.innodb_use_fallocate; -show global variables like 'innodb_use_fallocate'; -show session variables like 'innodb_use_fallocate'; -select * from information_schema.global_variables where variable_name='innodb_use_fallocate'; -select * from information_schema.session_variables where variable_name='innodb_use_fallocate'; - -# -# show that it's read-only -# ---error ER_INCORRECT_GLOBAL_LOCAL_VAR -set global innodb_use_fallocate=1; ---error ER_INCORRECT_GLOBAL_LOCAL_VAR -set session innodb_use_fallocate=1; - |