Movatterモバイル変換

For anInnoDB table created in a file-per-table tablespace or general tablespace, table data and associated indexes are stored in a.ibd file in the database directory. When anInnoDB table is created in the system tablespace, table data and indexes are stored in theibdata* files that represent the system tablespace. Theinnodb_file_per_table option controls whether tables are created in file-per-table tablespaces or the system tablespace, by default. TheTABLESPACE option can be used to place a table in a file-per-table tablespace, general tablespace, or the system tablespace, regardless of theinnodb_file_per_table setting.

ForMyISAM tables, the storage engine creates data and index files. Thus, for eachMyISAM tabletbl_name, there are two disk files.

Chapter 18,Alternative Storage Engines, describes what files each storage engine creates to represent tables. If a table name contains special characters, the names for the table files contain encoded versions of those characters as described inSection 11.2.4, “Mapping of Identifiers to File Names”.