mysql> SET GLOBAL innodb_checksum_algorithm=1;
Query OK, 0 rows affected (0.00 sec)
mysql> show global variables like '%innodb_checksum_algorithm%';
+---------------------------+--------------+
| Variable_name | Value |
+---------------------------+--------------+
| innodb_checksum_algorithm | strict_crc32 |
+---------------------------+--------------+
1 row in set (0.00 sec)
mysql> SET GLOBAL innodb_ checksum_ algorithm= 1;
Query OK, 0 rows affected (0.00 sec)
mysql> show global variables like '%innodb_ checksum_ algorithm% '; ------- ------- ------- +------ ------- -+ ------- ------- ------- +------ ------- -+ checksum_ algorithm | strict_crc32 | ------- ------- ------- +------ ------- -+
+------
| Variable_name | Value |
+------
| innodb_
+------
1 row in set (0.00 sec)