I just enabled checksums on a few InnoDB tables using:
alter table table_name_here CHECKSUM = 1;
Query OK, 36078 rows affected (43.82 sec)
Records: 36078 Duplicates: 0 Warnings: 0
The command seemed to work, and "show table status;" returns a column with "create_options" showing "checksum=1"
However, the MySQL manual says this is for MyISAM tables only. What's the impact of setting checksum = 1 with InnoDB tables?
(from
http://dev.mysql.com/doc/refman/5.0/en/create-table.html)
Set this to 1 if you want MySQL to maintain a live checksum for all rows (that is, a checksum that MySQL updates automatically as the table changes). This makes the table a little slower to update, but also makes it easier to find corrupted tables. The CHECKSUM TABLE statement reports the checksum. (MyISAM only.)
(from
http://dev.mysql.com/doc/refman/5.0/en/checksum-table.html)
With QUICK, the live table checksum is reported if it is available, or NULL otherwise. This is very fast. A live checksum is enabled by specifying the CHECKSUM=1 table option when you create the table; currently, this is supported only for MyISAM tables. See Section 12.1.5, “CREATE TABLE Syntax”.