Manual:CHECKSUM TABLE

From Askmonty.org

TOC MariaDB 5.1 Reference Manual: CHECKSUM TABLE Index

See Also:MariaDB 5.2 Reference Manual, MariaDB 5.3 Reference Manual

CHECKSUM TABLE now ignores values in NULL fields. This makes CHECKSUM TABLE faster and fixes some cases where the same table definition could give different checksum values depending on row format. The disadvantage is the value is now different compared to other MySQL installations. The new checksum calculation is fixed for all table engines which use the default way to calculate and for MyISAM which does the calculation internally.

Notes:

  1. Old MyISAM tables with internal checksums will return the same checksum as before. To fix them to calculate according to the new rules you have to do an ALTER TABLE.
  2. You can use the old way to calculate checksums by using the option --old to mysqld or set the system variable '@@old' to 1 when you do CHECKSUM TABLE ... EXTENDED;.
Retrieved from "http://askmonty.org/wiki/Manual:CHECKSUM_TABLE"