Starting at version MySQL5.6+ by default innodb_file_per_table is enabled and all data is stored in separate tablespaces.
It provides some advantages. I will highlight some of them:
- You can reclaim disk space when truncating or dropping a table stored in a file-per-table tablespace. Truncating or dropping tables stored in the shared system tablespace creates free space internally in the system tablespace data files (ibdata files) which can only be used for new InnoDB data.
- You can store specific tables on separate storage devices, for I/O optimization, space management, or backup purposes. …