SELECT @@innodb_file_per_table; @@innodb_file_per_table 1 CREATE TABLE t (id INT PRIMARY KEY); ALTER TABLE t ADD COLUMN (val varchar(2) NOT NULL DEFAULT ''), ALGORITHM = INSTANT; FLUSH TABLES test.t FOR EXPORT; UNLOCK TABLES; ALTER TABLE test.t DISCARD TABLESPACE; ALTER TABLE test.t IMPORT TABLESPACE; DROP TABLE t;