Fast InnoDB Checksum

Warning

This feature has been deprecated after Percona Server 5.1.66-14.2.

InnoDB writes a checksum at the end of each data page in order to detect data files corruption. However computing this checksum requires CPU cycles and in some circumstances this extra overhead can become significant.

XtraDB can use a more CPU-efficient algorithm, based on 4-byte words, which can be beneficial for some workloads (for instance write-heavy workloads on servers that can perform lots of IO).

The original algorithm is checked after the new one, so you can have data pages with old checksums and data pages with new checksums. However in this case, you may experience slow reads from pages having old checksums. If you want to have the entire benefit of this change, you will need to recreate all your InnoDB tables, for instance by dumping and reloading all InnoDB tables.

Once enabled, turning it off will require table(s) to be dump/imported, since it will fail to start on data files created when innodb_fast_checksums was enabled. In this case ALTER TABLE won’t work due to its implementation.

System Variables

variable innodb_fast_checksum
Command Line:Yes
Config File:Yes
Scope:Global
Dynamic:No
Variable Type:BOOL
Default Value:0
Percona Server
Call Us
+1-888-316-9775 (USA - Sales)
+1-208-473-2904 (USA - Sales)
+44-208-133-0309 (UK - Sales)
0-800-051-8984 (UK - Sales)
0-800-181-0665 (GER - Sales)
+1-877-862-4316 (Emergency)
+1-855-55TRAIN (Training)
+1-925-271-5054 (Training)

Table Of Contents

Previous topic

Query Cache Enhancements

Next topic

Reduced Buffer Pool Mutex Contention

This Page



© Copyright Percona LLC and/or its affiliates 2009-2013.
Except where otherwise noted, this documentation is licensed under the following license:
CC Attribution-ShareAlike 2.0 Generic
Created using Sphinx 1.2.2.
This documentation is developed in Launchpad as part of the Percona Server source code.
If you spotted innacuracies, errors, don't understood it or you think something is missing or should be improved, please file a bug.
]]>