innodb_file_per_table
The option that turns on the file-per-table setting, which stores each newly created InnoDB table and its associated index in its own .ibd file, outside the system tablespace.
This option affects the performance and storage considerations for a number of SQL statements, such as DROP TABLE and TRUNCATE TABLE.
This option is needed to take full advantage of many other InnoDB features, such as such as table compression, or backups of named tables in MySQL Enterprise Backup.
This option was once static, but can now be set using the SET GLOBAL command.
For reference information, see innodb-file-per-table. For usage information, see , "Using File-Per-Table Mode".
See also compression.
See also file-per-table.
See also ibd file.
See also MySQL Enterprise Backup.
See also system tablespace.