innodb_checksum_algorithm

In 10.6 ES:

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.4 ES:

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+

See also: System Variables for MariaDB Enterprise Server 10.6, in 10.5 ES, and in 10.4 ES

DETAILS

PARAMETERS

Dynamic

Yes

Scope

Global

Data Type

ENUM (crc32, strict_crc32, full_crc32, strict_full_crc32)

Default Value

full_crc32

SKYSQL

Cloud

SkySQL Topology

ES Ver

Default

AWS

HA (Primary/Replica)

10.4

full_crc32

AWS

HA (Primary/Replica)

10.5

full_crc32

AWS

Transactional Standalone

10.4

full_crc32

AWS

Transactional Standalone

10.5

full_crc32

AWS

Distributed Transactions

10.5

Not present

GCP

ColumnStore

10.5

full_crc32

GCP

ColumnStore Multi

10.5

full_crc32

GCP

Galera

10.4

full_crc32

GCP

Galera

10.5

full_crc32

GCP

HA (Primary/Replica)

10.4

full_crc32

GCP

HA (Primary/Replica)

10.5

full_crc32

GCP

HTAP

10.5

full_crc32

GCP

Transactional Standalone

10.4

full_crc32

GCP

Transactional Standalone

10.5

full_crc32

GCP

Distributed Transactions

10.5

Not present

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Default value changed in MariaDB Enterprise Server 10.4.6-1 from crc32 to full_crc32

EXTERNAL REFERENCES