innodb的表最大限制

相信大多数人都不知道,innodb的表最大限制为64TB,但是why?

Each space is divided into pages, normally 16 kib each (this can differ for two reasons: if the compile-time define UNIV_PAGE_SIZE is changed, or if innodb compression is used). Each page within a space is assigned a 32-bit integer page number, often called “offset”, which is actually just the page’s offset from the beginning of the space (not necessarily the file, for multi-file spaces). So, page 0 is located at file offset 0, page 1 at file offset 16384, and so on. (The astute may remember that innodb has a limit of 64tib of data; this is actually a limit per space, and is due primarily to the page number being a 32-bit integer combined with the default page size: 232 x 16 kib = 64 tib.)

来源:

https://blog.jcole.us/2013/01/03/the-basics-of-innodb-space-file-layout/ 

原文地址:https://www.cnblogs.com/sunss/p/5737501.html