diff options
-rw-r--r-- | mysql-test/include/default_mysqld.cnf | 1 | ||||
-rw-r--r-- | mysql-test/suite/sys_vars/r/innodb_log_page_checksum_basic.result | 10 |
2 files changed, 6 insertions, 5 deletions
diff --git a/mysql-test/include/default_mysqld.cnf b/mysql-test/include/default_mysqld.cnf index cccf72591cc..49bf13764dc 100644 --- a/mysql-test/include/default_mysqld.cnf +++ b/mysql-test/include/default_mysqld.cnf @@ -55,6 +55,7 @@ loose-innodb_read_io_threads= 2 loose-innodb_log_buffer_size= 1M loose-innodb_log_file_size= 10M loose-innodb-stats-persistent= OFF +loose-innodb-log-page-checksum= ON slave-net-timeout=120 diff --git a/mysql-test/suite/sys_vars/r/innodb_log_page_checksum_basic.result b/mysql-test/suite/sys_vars/r/innodb_log_page_checksum_basic.result index 4852ecb590c..6b28ad51cc4 100644 --- a/mysql-test/suite/sys_vars/r/innodb_log_page_checksum_basic.result +++ b/mysql-test/suite/sys_vars/r/innodb_log_page_checksum_basic.result @@ -4,23 +4,23 @@ SET @start_global_value = @@global.innodb_log_page_checksum; # select @@global.innodb_log_page_checksum; @@global.innodb_log_page_checksum -0 +1 select @@session.innodb_log_page_checksum; ERROR HY000: Variable 'innodb_log_page_checksum' is a GLOBAL variable show global variables like 'innodb_log_page_checksum'; Variable_name Value -innodb_log_page_checksum OFF +innodb_log_page_checksum ON show session variables like 'innodb_log_page_checksum'; Variable_name Value -innodb_log_page_checksum OFF +innodb_log_page_checksum ON select * from information_schema.global_variables where variable_name='innodb_log_page_checksum'; VARIABLE_NAME VARIABLE_VALUE -INNODB_LOG_PAGE_CHECKSUM OFF +INNODB_LOG_PAGE_CHECKSUM ON select * from information_schema.session_variables where variable_name='innodb_log_page_checksum'; VARIABLE_NAME VARIABLE_VALUE -INNODB_LOG_PAGE_CHECKSUM OFF +INNODB_LOG_PAGE_CHECKSUM ON # # show that it's writable # |