Skip navigation links
C.1.4 Changes in MySQL 5.1.24-maria (Not yet released) »
Section Navigation      [Toggle]

C.1.3. Changes in MySQL 5.1.25-maria (Not yet released)

The following changes apply only to builds of MySQL 5.1.25 that include the MARIA storage engine.

Functionality added or changed:

  • Important Note: The behavior of CHECKSUM TABLE has been modified so that the checksum operates consistently within all engines by default, unless you use the --old option.

    If you run mysqld --old option, then:

    • If table is MyISAM with an old-style checksum (5.0), then CHECKSUM TABLE returns the 5.0 checksum.

    • If the QUICK option is specified to CHECKSUM TABLE, NULL is returned instead.

    • When the EXTENDED option is specified, the checksum is calculated by looping over all the rows and calculates the checksum using the 5.0 algorithm.

    If you run mysqld without the --old option, then:

    • If the table is MyISAM with the new-style live checksum (5.1), then the live checksum is returned.

    • If the QUICK option to OPTIMIZE TABLE, NULL is returned.

    • When the EXTENDED option is specified, the checksum is calculated by looping over all the rows and calculating the checksum using the 5.1 algorithm.

    In addition, if you run CHECKSUM TABLE on MyISAM tables with VARCHAR columns, using ROW_FORMAT=fixed and row-level checksums enabled, then a warning will be raised that the table must be repaired using REPAIR TABLE to build the new checksum.

    To ensure that tables moved from a MySQL 5.1 environment to MySQL 5.1-maria, or MySQL 6.0 environment, you should run mysqld with the --old and run CHECKSUM TABLE ... EXTENDED to compare using the 5.0 algorithm.