MySQL 一个mysql数据库可以创建多少个表？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/7656943/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How many tables can be created in a mysql database?
提问by shibly
How many tables can be created in a mysql database ?
一个mysql数据库可以创建多少个表？
And how many columns can be created in a mysql table ?
一个 mysql 表中可以创建多少列？
How many rows can be inserted into a mysql table ?
一个mysql表可以插入多少行？
回答by NullUserException
How many tables can be created in a mysql database ?
一个mysql数据库可以创建多少个表？
MySQL has no limit on the number of databases.The underlying file system may have a limit on the number of tables. Individual storage engines may impose engine-specific constraints. InnoDB permits up to 4 billion tables.
MySQL对数据库的数量没有限制。底层文件系统可能对表的数量有限制。单个存储引擎可能会施加特定于引擎的约束。InnoDB 允许多达 40 亿个表。
And how many columns can be created in a mysql table ?
一个 mysql 表中可以创建多少列？
There is a hard limit of 4096 columns per table, but the effective maximum may be less for a given table. The exact limit depends on several interacting factors.
每个表有 4096 列的硬限制，但给定表的有效最大值可能更少。确切的限制取决于几个相互作用的因素。
How many rows can be inserted into a mysql table ?
一个mysql表可以插入多少行？
The number of rows is limited by the maximum size allowed for a table. This is OS-dependent. You can impose a limit on the number of rows by setting MAX_ROWSat table creation time.
行数受表允许的最大大小限制。这取决于操作系统。您可以通过MAX_ROWS在表创建时设置来限制行数。
Reference: Limits in MySQL
参考：MySQL 中的限制
回答by James Williams
It really depends on the operating system and version of MySQL. Generally the MySQL file size for tables can be: (5.0 Version)
这实际上取决于操作系统和 MySQL 的版本。通常表的 MySQL 文件大小可以是：（5.0 版本）
Operating System File-size Limit
Win32 w/ FAT/FAT32 2GB/4GB
Win32 w/ NTFS 2TB (possibly larger)
Linux 2.2-Intel 32-bit 2GB (LFS: 4GB)
Linux 2.4+ 4TB(using ext3 file system)
Solaris 9/10 16TB
MacOS X w/ HFS+ 2TB
NetWare w/NSS file system 8TB
For more information check http://dev.mysql.com/doc/refman/5.0/en/table-size-limit.html
有关更多信息，请查看http://dev.mysql.com/doc/refman/5.0/en/table-size-limit.html
回答by TheBlastOne
Unlimited. 4096 columns. Number of row limit is unknown to me.
无限。4096 列。我不知道行数限制。
See for example http://dev.mysql.com/doc/refman/5.0/en/column-count-limit.html.
参见例如http://dev.mysql.com/doc/refman/5.0/en/column-count-limit.html。
回答by Dylan B
Hard cap 4096 columns, but my experience: try not to use VARCHAR, use TINYTEXT. Otherwise, you will easily reach limit "65,535-byte row size limit" even though you have less than 50 columns in the table.
硬顶 4096 列，但我的经验是：尽量不要使用 VARCHAR，使用 TINYTEXT。否则，即使表中的列少于 50 列，您也很容易达到限制“65,535 字节行大小限制”。
回答by jamie laws
Maximum row size allowed is 65535 bytes
允许的最大行大小为 65535 字节
