MySQL Community Server的局限性 [英] MySQL Community Server Limitations

问题描述

谁能告诉我MySQL Community Server&的局限性是什么? MySQL Enterprise Server的优点?

Could anyone please tell what are the limitations to MySQL Community Server & the pros of a MySQL Enterprise Server?

以下是我们与数据库的日常交易活动

The following would be our daily transactional activity with the DB

每天将创建和更新至少1000万条记录.

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.

我担心数据库容量(数据库大小阈值等)以及在选择MySQL Community Server时它是否能够承受大量数据.

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 CE和MySQL Enterprise Edition之间有区别吗?

社区版和企业版之间的差异添加了支持和工具.服务器本身是相同的，但是企业版的更新频率更高，并且通过快速的错误修复支持是稳定的. 如果将来决定继续使用ORACLE，那将是安全的，不会有任何问题.

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.

MySQL Enterprise订阅包括:

1. MySQL Enterprise Server，它是最可靠，安全和可靠的 世界上最受欢迎的开源数据库的最新版本
2. MySQL Enterprise Monitor提供监视和自动广告访问者，以帮助您消除安全漏洞，改善复制，优化性能等
3. MySQL技术支持使您能够快速回答最棘手的技术问题.
4. MySQL Enterprise Platinum随附的MySQL咨询支持为您提供了来自MySQL支持团队的量身定制的建议，以指导他们如何正确设计和调整MySQL服务器，架构，查询和复制设置，以提高性能.

1. MySQL Enterprise Server which is the most reliable, secure and up-to-date version of the world’s most popular open source database
2. The MySQL Enterprise Monitor provides monitoring and automated Ad visors to help you eliminate security vulnerabilities, improve replication, optimize performance, and more
3. MySQL Technical Support enables you to get your toughest technical questions answered quickly.
4. 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 Community Server:

1. 根据开源GPL许可免费提供

1. Freely available under the open source GPL license

在具有动态(可变长度)行的MyISAM表中，索引 表的文件(tablename.MYI)使用32位存储行位置 指向数据文件(tablename.MYD)的指针.这意味着它可以 只能处理4GB的空间.

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.

这篇关于MySQL Community Server的局限性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！