--innodb-checksum-algorithm
This page is part of MariaDB's Documentation.
The parent of this page is: mariadbd & mysqld for MariaDB Enterprise Server
Topics on this page:
Overview
Default value: full_
crc32 (MariaDB 10.5 and later) Scope: Global
Dynamic: Yes
The algorithm InnoDB uses for page checksumming. Possible values are:
FULL_CRC32
: for new files, always use CRC-32C; for old, see crc32 belowSTRICT_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 readingSTRICT_CRC32
: write crc32, do not allow other algorithms to match when reading
Note
Files updated when this option is set to CRC32
or STRICT_CRC32
are not readable by MariaDB versions older than 10.0.4; new files created with FULL_CRC32
are readable by MariaDB 10.4.3 and later
Old values deprecated in MariaDB 10.3 and removed in MariaDB 10.6:
INNODB
: write a software calculated checksum, allow any other checksums to match when readingSTRICT_INNODB
: write a software calculated checksum, do not allow other algorithms to match when readingNONE
: write a constant magic number, do not do any checksum verification when readingSTRICT_NONE
: write a constant magic number, do not allow values other than that magic number when reading
For more details see: innodb_
See also: mariadbd & mysqld for MariaDB Enterprise Server 11.4, in 10.6 ES, in 10.5 ES, in 10.4 ES, in 10.3 ES, in 10.2 ES, in 10.6 CS, in 10.5 CS, in 10.4 CS, in 10.3 CS, and in 10.2 CS
CHANGE HISTORY
Release Series | History |
---|---|
11.4 Enterprise |
|
10.6 Enterprise |
|
10.6 Community |
|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|