【MySQL 5.7 Reference Manual】15.4.9 File-Per-Table Tablespaces（独立表空间）

来源：互联网发布：百胜厨知乎编辑：程序博客网时间：2024/06/05 21:01

15.4.9 File-Per-Table Tablespaces（独立表空间）

A file-per-table tablespace is a single-table tablespace that is created in its own data file rather than in the system tablespace. Tables are created in file-per-table tablespaces when the innodb_file_per_table option is enabled. Otherwise, InnoDB tables are created in the system tablespace. Each file-per-table tablespace is represented by a single .ibd data file, which is created in the database directory by default.

独立表空间是一种单表表空间，它创建在自有的数据文件中而不是在系统表空间中。当innodb_file_per_table选项启用时，表会创建在独立表空间中。否则，InnoDB表会创建在系统表空间中。每一个独立表空间都由一个.ibd数据文件表示，它在默认情况下会创建在数据库目录中。

File-per-table tablespaces support DYNAMIC and COMPRESSED row formats which support features such as off-page storage for variable length data and table compression. For information about these features, and about other advantages of file-per-table tablespaces, see Section 15.7.4, “InnoDB File-Per-Table Tablespaces”.

独立表空间支持DYNAMIC和COMPRESSED的行格式，这类格式支持一些特性，比如可变长度数据离页存储和表压缩。更多信息关于这些特性，请参考15.7.4，“InnoDB独立表空间”。

0 0