By default, all InnoDB tables and indexes are stored in the system tablespace on one file. This option causes the server to create one tablespace file per table. To enable it, set it on your configuration file,
or start the server with
See the the full documentation for more information.
[mysqld] innodb_data_home_dir = ./
Specifies the names, sizes and location of shared tablespace files:
Specifies the location of the InnoDB log files:
The size in bytes of the memory buffer to cache data and indexes of InnoDB‘s tables. This aims to reduce disk access to provide better performance. By default:
/etc/my.cnf, but the location and name depends on the particular installation. Note that this is not the only way of configuring the server, some systems does not have one even and rely on the command options to start the server and its defaults values.
ibdata1is a 10MB auto-extensible file that MySQL creates for the shared tablespace by default.
.frmextension containing the table definition (for all storage engines).
.MYD(MYData) file which contains the data on it.
.MYI(MYIndex) file which contains the table’s indexes.
.expextension are created by Percona XtraBackup per each InnoDB tablespace when the
xtrabackup --exportoption is used on prepare. These files can be used to import those tablespaces on Percona Server 5.5 or lower versions, see restoring individual tables”.
.ARMfile which contains the metadata of it.
.ARZfile which contains the data of it.
.CSMfile which contains the metadata of it.
.CSVfile which contains the data of it (which is a standard Comma Separated Value file).
.optextension in the database directory.
For general inquiries about our open source software and database management tools, please send us your question and someone will contact you.