非常感谢。 作者: psufnxk2000 时间: 2015-2-10 16:57
innodb_file_per_table is dynamic and can be set ON or OFF using SET GLOBAL
Be aware that enabling innodb_file_per_table also means that an ALTER TABLE operation will
move InnoDB table from the system tablespace to an individual .ibd file in cases where ALTER TABLE
recreates the table (ALGORITHM=COPY).