MySQL / MariaDB DBA

InnoDB, Storage & Maintenance Operations

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.

This is 8 of 23 free samples for MySQL / MariaDB DBA.

More MySQL / MariaDB DBA topic samples