MySQL 社区服务器限制
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/23195959/
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
MySQL Community Server Limitations
提问by Code Falcon
Could anyone please tell what are the limitations to MySQL Community Server & the pros of a MySQL Enterprise Server?
谁能告诉 MySQL 社区服务器的限制和 MySQL 企业服务器的优点是什么？
The following would be our daily transactional activity with the DB
以下是我们与数据库的日常事务活动
Atleast 10 million records would be created and updated on a person day basis.
Scheduled Procedures would be acting on the records in addition to the application accessing them.
每天至少会创建和更新 1000 万条记录。
除了访问它们的应用程序之外，预定程序还将作用于这些记录。
I am concerned about the DB capacity (DB size threshold,etc) and if it would withstand huge volume of data when i opt for MySQL Community Server.
我担心数据库容量（数据库大小阈值等），以及当我选择 MySQL 社区服务器时它是否能够承受大量数据。
Thanks in Advance.
提前致谢。
回答by Sathish D
Difference between MySQL CE and MySQL Enterprise edition?
MySQL CE 和 MySQL 企业版的区别？
Difference between the community edition and the enterprise edition is added support and tools. The server itself is the same, but the enterprise edition gets updated more frequently and it is stable with quick bug fix support. It would be safe and will not make any problem if the decide to move on to ORACLE in future.
社区版和企业版的区别在于增加了支持和工具。服务器本身是相同的，但企业版更新更频繁，并且稳定并支持快速错误修复。如果将来决定转向 ORACLE，这将是安全的，不会有任何问题。
MySQL Enterprise subscriptions include:
MySQL Enterprise 订阅包括：
- MySQL Enterprise Server which is the most reliable, secure and up-to-date version of the world's most popular open source database
- The MySQL Enterprise Monitor provides monitoring and automated Ad visors to help you eliminate security vulnerabilities, improve replication, optimize performance, and more
- MySQL Technical Support enables you to get your toughest technical questions answered quickly.
- MySQL Consultative Support, available with MySQL Enterprise Platinum gives you tailored advise from the MySQL Support team on how to properly design and tune your MySQL servers, schema, queries, and replication set-up for better performance.
- MySQL Enterprise Server 是世界上最流行的开源数据库的最可靠、最安全和最新版本
- MySQL Enterprise Monitor 提供监控和自动化顾问，帮助您消除安全漏洞、改进复制、优化性能等
- MySQL 技术支持使您能够快速回答最棘手的技术问题。
- MySQL 咨询支持（随 MySQL Enterprise Platinum 提供）为您提供来自 MySQL 支持团队的量身定制的建议，内容涉及如何正确设计和调整 MySQL 服务器、架构、查询和复制设置以获得更好的性能。
MySQL Community Server:
MySQL 社区服务器：
Freely available under the open source GPL license
In a MyISAM table with dynamic (variable length) rows, the index file for the table (tablename.MYI) stores row locations using 32-bit pointers into the data file (tablename.MYD). That means it can address only 4GB of space.
在开源 GPL 许可下免费提供
在具有动态（可变长度）行的 MyISAM 表中，表 (tablename.MYI) 的索引文件使用 32 位指针将行位置存储到数据文件 (tablename.MYD) 中。这意味着它只能寻址 4GB 的空间。
