MySQL 5 is out. This stable release is now recommended for production use, so if your installation of MySQL 4.1 is getting dusty (or worse yet, if you’re still on 4.0), now might be the time to look at updating your installation.
MySQL 5已经发布 。 现在建议将此稳定版本用于生产,因此,如果您安装MySQL 4.1尘土飞扬(或者更糟糕的是,如果您仍使用4.0),现在可能是时候考虑更新安装了。
This release of MySQL effectively brings it to feature parity with enterprise databases like MS SQL Server and Oracle, with many new, long-awaited features:
MySQL的此版本有效地使其与MS SQL Server和Oracle等企业数据库具有同等的功能,并具有许多期待已久的新功能:
Stored Procedures and SQL Functions 存储过程和SQL函数 Embed a portion of your application’s business logic directly into your database to improve performance of frequently-needed data manipulaton operations. 将应用程序业务逻辑的一部分直接嵌入到数据库中,以提高经常需要的数据操纵操作的性能。 Triggers 扳机 Further offload business logic from your application. Respond to changes in your database by executing custom operations in response to events like row insertions, deletions, updates. 进一步从应用程序中卸载业务逻辑。 通过执行自定义操作来响应数据库中的更改,以响应行插入,删除,更新等事件。 Views 观看次数 Define particular table columns or joins that are accessible to certain users without granting them full access to sensitive data in the relevant tables. 定义特定用户可以访问的特定表列或联接,而无需授予他们对相关表中敏感数据的完全访问权限。 Cursors 游标 The database can keep track of your application’s current position in a large result set, so that you don’t need to cache such large result sets in your application. 数据库可以跟踪大型结果集中应用程序的当前位置,因此您无需在应用程序中缓存如此大的结果集。 Information Schema 信息架构 Access information about your database tables through the virtual information_schema database. 通过虚拟 information_schema数据库访问有关数据库表的 information_schema 。 XA Distributed Transactions XA分布式事务 Perform transactions (multi-step operations that must succeed completely or not happen at all) across multiple database servers, or even non-database systems. 跨多个数据库服务器甚至非数据库系统执行事务(必须完全成功或根本不成功的多步操作)。 SQL Mode SQL模式 Switch modes on-the-fly to request stricter or more standards-compliant database behaviour (e.g. raise errors insteads of warnings for tables involved in transactions). 快速切换模式以请求更严格或更符合标准的数据库行为(例如,引发错误而不是事务中涉及的表的警告)。 New Federated and Archive Storage Engines 新的联合存储和存档存储引擎 The new Federated storage engine lets you access tables actually stored in other database servers as if they were stored locally. The Archive storage engine is good for storing large quantities of infrequently-accessed data without indexes with greatly reduced overhead. 新的联合存储引擎使您可以访问实际存储在其他数据库服务器中的表,就像它们存储在本地一样。 存档存储引擎非常适合用于存储大量不经常访问的数据而无需索引,从而大大降低了开销。Additionally, a number of new tools are available for managing MySQL servers and importing data and related structures from competing database servers.
此外,还有许多新工具可用于管理MySQL服务器以及从竞争数据库服务器导入数据和相关结构。
Grab MySQL 5.0 now, or head over to the MySQL AB Articles index to read up on some of the new features.
立即获取MySQL 5.0 ,或转到MySQL AB Articles索引以阅读一些新功能。
翻译自: https://www.sitepoint.com/mysql-50-stable-release/
相关资源:mysql稳定版本