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)
|