CHECK TABLE table_name; when using InnoDB

Question

Assuming an InnoDB table, will the following command ...

CHECK TABLE table_name;

... cause MySQL to ...

• a.) Check only the data content of the table
• b.) Check only the index content of the table
• c.) Check both the data content and the index content of the table

Answer 1

Those options are ignored on innoDb tables. MySQL CHECK TABLE.

The different check options that can be given are shown in the following table. These options are passed to the storage engine, which may use them or not. MyISAM uses them; they are ignored for InnoDB tables.

This guy took at look at the CHECK TABLE code for innoDb and explains it pretty well.