Question
File-per-table versus system tablespace: how do they affect table space reclamation?
Answer
File-per-table stores a table in its own tablespace, so a rebuild can return its free space to the filesystem. The system tablespace is shared and does not shrink from ordinary table deletes. Use file-per-table for independently managed tables. Applies to MySQL and MariaDB.