1SET @orig = @@global.innodb_log_checksums; 2SELECT @orig; 3@orig 41 5SET GLOBAL innodb_log_checksums = 'crc32'; 6ERROR 42000: Variable 'innodb_log_checksums' can't be set to the value of 'crc32' 7SELECT @@global.innodb_log_checksums; 8@@global.innodb_log_checksums 91 10SET GLOBAL innodb_log_checksums = 2; 11ERROR 42000: Variable 'innodb_log_checksums' can't be set to the value of '2' 12SELECT @@global.innodb_log_checksums; 13@@global.innodb_log_checksums 141 15SET GLOBAL innodb_log_checksums = 1e2; 16ERROR 42000: Incorrect argument type to variable 'innodb_log_checksums' 17SELECT @@global.innodb_log_checksums; 18@@global.innodb_log_checksums 191 20SET GLOBAL innodb_log_checksums = 1.0; 21ERROR 42000: Incorrect argument type to variable 'innodb_log_checksums' 22SELECT @@global.innodb_log_checksums; 23@@global.innodb_log_checksums 241 25SET innodb_log_checksums = OFF; 26ERROR HY000: Variable 'innodb_log_checksums' is a GLOBAL variable and should be set with SET GLOBAL 27SELECT @@global.innodb_log_checksums; 28@@global.innodb_log_checksums 291 30SET GLOBAL innodb_log_checksums = OFF; 31Warnings: 32Warning 138 innodb_log_checksums is deprecated and has no effect outside recovery 33SELECT @@global.innodb_log_checksums; 34@@global.innodb_log_checksums 351 36SET GLOBAL innodb_log_checksums = default; 37SET GLOBAL innodb_log_checksums = ON; 38SELECT @@global.innodb_log_checksums; 39@@global.innodb_log_checksums 401 41SET GLOBAL innodb_log_checksums = @orig; 42SELECT @@global.innodb_log_checksums; 43@@global.innodb_log_checksums 441 45