.frm files in database directories.
InnoDB table also has its own entry in the InnoDB internal data dictionary inside the tablespace.
.frm file or files, and the corresponding entries inside the InnoDB data dictionary.
InnoDB tables cannot be moved between databases simply by moving the .frm files.
InnoDB table has a special index called the clustered index where the data for the rows is stored.
PRIMARY KEY is defined on a table, the index of the primary key is the clustered index.
PRIMARY KEY is not defined on a table, MySQL picks the first UNIQUE index that has only NOT NULL columns as the primary key and InnoDB uses it as the clustered index.
InnoDB internally generates a clustered index where the rows are ordered by the row ID that InnoDB assigns to the rows in such a table.
What is InnoDB disk I/O?
© 2007 John Michael Pierobon