Yuliyas-Air:maria10.6 Valerii$ bin/mysql test

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 4

Server version: 10.6.15-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [test]> SELECT VARIABLE_COMMENT FROM information_schema.SYSTEM_VARIABLES WHERE VARIABLE_NAME='innodb_checksum_algorithm'\G

*************************** 1. row ***************************

VARIABLE_COMMENT: The algorithm InnoDB uses for page checksumming. Possible values are FULL_CRC32 for new files, always use CRC-32C; for old, see CRC32 below; STRICT_FULL_CRC32 for new files, always use CRC-32C; for old, see STRICT_CRC32 below; CRC32 write crc32, allow any of the other checksums to match when reading; STRICT_CRC32 write crc32, do not allow other algorithms to match when reading; INNODB write a software calculated checksum, allow any other checksums to match when reading; STRICT_INNODB write a software calculated checksum, do not allow other algorithms to match when reading; NONE write a constant magic number, do not do any checksum verification when reading; STRICT_NONE write a constant magic number, do not allow values other than that magic number when reading; Files updated when this option is set to crc32 or strict_crc32 will not be readable by MariaDB versions older than 10.0.4; new files created with full_crc32 are readable by MariaDB 10.4.3+

1 row in set (0.026 sec)

MariaDB [test]> set global innodb_checksum_algorithm = none;

ERROR 1231 (42000): Variable 'innodb_checksum_algorithm' can't be set to the value of 'none'

MariaDB [test]> set global innodb_checksum_algorithm = strict_none;

ERROR 1231 (42000): Variable 'innodb_checksum_algorithm' can't be set to the value of 'strict_none'

MariaDB [test]> set global innodb_checksum_algorithm = strict_innodb;

ERROR 1231 (42000): Variable 'innodb_checksum_algorithm' can't be set to the value of 'strict_innodb'

MariaDB [test]> set global innodb_checksum_algorithm = strict_full_crc32;

Query OK, 0 rows affected (0.000 sec)