Shulou(Shulou.com)06/01 Report--

MyISAM Engine:

By default, MySQL creates MyISAM tables with a maximum allowable size of 4GB. You can check the maximum size of the table using the SHOW TABLE STATUS statement or myisamchk -dv tbl_name.

If you need MyISAM tables larger than 4 GB (and your operating system supports large files), use CREATE TABLE with AVG_ROW_LENGTH and MAX_ROWS options. Once the table is created, you can also change these options using ALTER TABLE to increase the maximum allowable size of the table.

InnoDB Engine:

When shared tablespaces are used, all Innodb data is stored in a single tablespace, which can be composed of many files, and a table can exist across multiple files, so its size limit is no longer a file size limit, but its own limit. As you can see from the official documentation of Innodb, the maximum limit of its table space is 64TB, which means that Innodb's single table limit is basically around 64TB. Of course, this size includes all indexes and other related data of this table.

When using a dedicated table space to store Innodb tables, each table's data is stored in a separate file, and the single-table limit becomes the size limit of the file system.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.