--innodb-checksum-algorithm
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: mariadbd & mysqld for MariaDB Enterprise Server
Topics on this page:
Overview
This is a command-line option for the mariadbd
& mysqld
commands (arg: Required).
In 10.6 ES, 10.6 CS:
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+ In 10.5 ES, 10.5 CS, 10.4 ES, 10.4 CS:
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 (same as innodb_ checksums=OFF); 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+ In 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:
The algorithm InnoDB uses for page checksumming. Possible values are CRC32 (hardware accelerated if the CPU supports it) 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 (same as innodb_ checksums=OFF); 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
See also: mariadbd & mysqld for MariaDB Enterprise Server 10.6, 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 |
---|---|
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 |
|