1SET @orig = @@global.innodb_checksum_algorithm; 2SELECT @orig; 3@orig 4crc32 5SET GLOBAL innodb_checksum_algorithm = 'crc32'; 6SELECT @@global.innodb_checksum_algorithm; 7@@global.innodb_checksum_algorithm 8crc32 9SET GLOBAL innodb_checksum_algorithm = 'strict_crc32'; 10SELECT @@global.innodb_checksum_algorithm; 11@@global.innodb_checksum_algorithm 12strict_crc32 13SET GLOBAL innodb_checksum_algorithm = 'innodb'; 14Warnings: 15Warning 138 Setting innodb_checksum_algorithm to values other than crc32, full_crc32, strict_crc32 or strict_full_crc32 is UNSAFE and DEPRECATED. These deprecated values will be disallowed in MariaDB 10.6. 16SELECT @@global.innodb_checksum_algorithm; 17@@global.innodb_checksum_algorithm 18innodb 19SET GLOBAL innodb_checksum_algorithm = 'strict_innodb'; 20Warnings: 21Warning 138 Setting innodb_checksum_algorithm to values other than crc32, full_crc32, strict_crc32 or strict_full_crc32 is UNSAFE and DEPRECATED. These deprecated values will be disallowed in MariaDB 10.6. 22SELECT @@global.innodb_checksum_algorithm; 23@@global.innodb_checksum_algorithm 24strict_innodb 25SET GLOBAL innodb_checksum_algorithm = 'none'; 26Warnings: 27Warning 138 Setting innodb_checksum_algorithm to values other than crc32, full_crc32, strict_crc32 or strict_full_crc32 is UNSAFE and DEPRECATED. These deprecated values will be disallowed in MariaDB 10.6. 28SELECT @@global.innodb_checksum_algorithm; 29@@global.innodb_checksum_algorithm 30none 31SET GLOBAL innodb_checksum_algorithm = 'strict_none'; 32Warnings: 33Warning 138 Setting innodb_checksum_algorithm to values other than crc32, full_crc32, strict_crc32 or strict_full_crc32 is UNSAFE and DEPRECATED. These deprecated values will be disallowed in MariaDB 10.6. 34SELECT @@global.innodb_checksum_algorithm; 35@@global.innodb_checksum_algorithm 36strict_none 37SET GLOBAL innodb_checksum_algorithm = 'full_crc32'; 38SELECT @@global.innodb_checksum_algorithm; 39@@global.innodb_checksum_algorithm 40full_crc32 41SET GLOBAL innodb_checksum_algorithm = 'strict_full_crc32'; 42SELECT @@global.innodb_checksum_algorithm; 43@@global.innodb_checksum_algorithm 44strict_full_crc32 45SET GLOBAL innodb_checksum_algorithm = ''; 46ERROR 42000: Variable 'innodb_checksum_algorithm' can't be set to the value of '' 47SELECT @@global.innodb_checksum_algorithm; 48@@global.innodb_checksum_algorithm 49strict_full_crc32 50SET GLOBAL innodb_checksum_algorithm = 'foobar'; 51ERROR 42000: Variable 'innodb_checksum_algorithm' can't be set to the value of 'foobar' 52SELECT @@global.innodb_checksum_algorithm; 53@@global.innodb_checksum_algorithm 54strict_full_crc32 55SET GLOBAL innodb_checksum_algorithm = 123; 56ERROR 42000: Variable 'innodb_checksum_algorithm' can't be set to the value of '123' 57SELECT @@global.innodb_checksum_algorithm; 58@@global.innodb_checksum_algorithm 59strict_full_crc32 60SET GLOBAL innodb_checksum_algorithm = @orig; 61SELECT @@global.innodb_checksum_algorithm; 62@@global.innodb_checksum_algorithm 63crc32 64