MySQL MySQL可以存储多少数据？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3417121/
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 much data can be stored in MySQL?
提问by Alex Mathew
I am just a beginner in MySQL, I need to know how much data can be stored in MySQL. I am developing a web crawler, can I store all the data in MySQL, or do I need to use another Database? Which is more faster? What I mean is, which has the highest Writing/Reading Rate? Do I need to reconfigure to add more data?
我只是一个 MySQL 的初学者，我需要知道 MySQL 中可以存储多少数据。我正在开发一个网络爬虫，我可以将所有数据存储在 MySQL 中，还是需要使用另一个数据库？哪个更快？我的意思是，哪个写入/读取率最高？我是否需要重新配置以添加更多数据？
回答by Tom Gullen
Depends on the operating system.
取决于操作系统。
**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
Solaris 9/10 16TB
MacOS X w/ HFS+ 2TB
NetWare w/NSS file system 8TB
http://dev.mysql.com/doc/refman/5.0/en/full-table.html
http://dev.mysql.com/doc/refman/5.0/en/full-table.html
Your write/read rate is of pretty much no concern to you, your bottleneck is going to be your internet connection.
您的写入/读取速度几乎与您无关，您的瓶颈将是您的互联网连接。
回答by Sher Singh
https://forums.mysql.com/read.php?22,379547,381106
https://forums.mysql.com/read.php?22,379547,381106
InnoDB Size Limits
InnoDB 大小限制
- Max # of tables: 4 G
- Max size of a table: 32TB
- Columns per table: 1000
- Max row size: n*4 GB
- 8 kB if stored on the same page
- n*4 GB with n BLOBs
- Max key length: 3500
- Maximum tablespace size: 64TB
- Max # of concurrent trxs: 1023
- 最大表数：4 G
- 表的最大大小：32TB
- 每个表的列数：1000
- 最大行大小：n*4 GB
- 如果存储在同一页面上，则为 8 kB
- n*4 GB，带有 n 个 BLOB
- 最大密钥长度：3500
- 最大表空间大小：64TB
- 最大并发 trx 数：1023
Nanda Kishore Toomula
南达·基肖尔·图穆拉
Sr DBA,Nokia India
高级 DBA，诺基亚印度
CMDBA 5.0
CMDBA 5.0
