MySQL表可以存储的最大记录数量是多少? [英] What is maximum records quantity a MySQL table can store?

问题描述

一个MySQL MyISAM表可以存储多少条记录?多少个InnoDB可以?

How many records can a MySQL MyISAM table store? How many InnoDB can?

推荐答案

您不能按记录数进行计数，因为您的表可能只有很短的int字段才有很短的记录，或者您的记录可能真的很长却只有数百个int字段.字段.

You can't count by number of records because your table can have really short records with only a few int fields or your records might be really long with hundreds of fields.

因此必须用表的文件大小来衡量.

So it has to be measured in the file size of the tables.

对于MYSQL:表的大小限制基于安装MySQL的操作系统驱动器文件系统，范围从2GB到2TB.

For MYSQL: The table size limit is based on the operating system drive file system that MySQL is installed on, ranging from 2GB to 2TB.

有关详细说明，请参见MySQL参考手册每个操作系统的限制.

See the MySQL reference manual for full explanations of limits for each operating system.

关于InnoDb和MyIsam，我不知道.

Concerning InnoDb and MyIsam i do not know.

这篇关于MySQL表可以存储的最大记录数量是多少?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！