- 论坛徽章:
- 0
|
本帖最后由 归隐乡村 于 2016-07-18 10:07 编辑
5.6上是你说的这样子的。5.7上变了。是我没描述清楚问题。
5.6中
Pages, Extents, Segments, and Tablespaces
Each tablespace consists of database pages. Every tablespace in a MySQL instance has the same page size. By default, all tablespaces have a page size of 16KB; you can reduce the page size to 8KB or 4KB by specifying the innodb_page_size [1634] option when you create the MySQL instance.
The pages are grouped into extents of size 1MB (64 consecutive 16KB pages, or 128 8KB pages, or 256 4KB pages). The “files” inside a tablespace are called segments in InnoDB. (These segments are different from the rollback segment, which actually contains many tablespace segments.)
5.7中
14.9.2 File Space Management
Pages, Extents, Segments, and Tablespaces
Each tablespace consists of database pages. Every tablespace in a MySQL instance has the same page size. By default, all tablespaces have a page size of 16KB; you can reduce the page size to 8KB or 4KB by specifying the innodb_page_size option when you create the MySQL instance. As of MySQL 5.7.6, you can also increase the page size to 32KB or 64KB. For more information, refer to the innodb_page_size documentation.
The pages are grouped into extents of size 1MB for pages up to 16KB in size (64 consecutive 16KB pages, or 128 8KB pages, or 256 4KB pages). For a page size of 32KB, extent size is 2MB. For page size of 64KB, extent size is 4MB.
回复 2# lyhabc
|
|