file-per-table
A general name for the setting controlled by the innodb-file-per-table option. For each table created while this setting is in effect, the data is stored in a separate .ibd file rather than in the system tablespace. When table data is stored in a separate file, you have more flexibility to choose nondefault file formats and row formats, which are required for features such as data compression. The TRUNCATE TABLE operation is also much faster, and the reclaimed space can be used by the operating system rather than remaining reserved for InnoDB.
The MySQL Enterprise Backup product is more flexible for tables that are in their own files. For example, tables can be excluded from a backup, but only if they are in separate files. Thus, this setting is suitable for tables that are backed up less frequently or on a different schedule.
See also compressed row format.
See also compression.
See also file format.
See also ibdata file.
See also innodb-file-per-table.
See also row format.
See also system tablespace.