InnoDB TablesInnoDB tables.
mysql database from MyISAM to InnoDB tables!
VARCHAR columns with a combined size larger than 65535.
InnoDB log files must be less than 4GB.
InnoDB tables do not support FULLTEXT indexes.
InnoDB supports spatial types, but not indexes on them.
SHOW TABLE STATUS does not give accurate statistics on InnoDB tables.
DELETE FROM tbl_name does not regenerate the table but instead deletes all rows, one by one.
InnoDB is 16KB.
InnoDB does not ignore trailing spaces when comparing BINARY or VARBINARY column values.
InnoDB does not allow column names that match the name of an internal InnoDB column.
DB_ROW_ID, DB_TRX_ID, DB_ROLL_PTR and DB_MIX_ID.
Are there guidelines to troubleshooting InnoDB problems?
© 2007 John Michael Pierobon