mysql-test/suite/sys_vars/t/innodb_page_size_basic.test
raw| 1 | # |
| 2 | # Basic test for innodb_page_size |
| 3 | # |
| 4 | |
| 5 | |
| 6 | # Check the default value |
| 7 | SET @orig = @@global.innodb_page_size; |
| 8 | --replace_result 65536 {valid_page_size} 32768 {valid_page_size} 16384 {valid_page_size} 8192 {valid_page_size} 4096 {valid_page_size} |
| 9 | SELECT @orig; |
| 10 | |
| 11 | # Confirm that we can not change the value |
| 12 | -- error ER_INCORRECT_GLOBAL_LOCAL_VAR |
| 13 | SET GLOBAL innodb_page_size = 4k; |
| 14 | -- error ER_INCORRECT_GLOBAL_LOCAL_VAR |
| 15 | SET GLOBAL innodb_page_size = 8k; |