From 914244d08cf91e06d2b5ebc591425fd6e5587db5 Mon Sep 17 00:00:00 2001 From: Vlad Lesin Date: Thu, 21 Jan 2021 14:00:20 +0300 Subject: MDEV-18976 Implement a CHECKSUM redo log record for improved validation Set innodb_log_page_checksum= ON for testing. --- mysql-test/include/default_mysqld.cnf | 1 + .../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 # -- cgit v1.2.1