MySQL 5.5 Released

Performance, scalability enhancements highlight new release.

Note: ESJ’s editors carefully choose vendor-issued press releases about new or upgraded products and services. We have edited and/or condensed this release to highlight key features but make no claims as to the accuracy of the vendor's statements.

Oracle has released MySQL 5.5. The update delivers enhancements that enable users to improve the performance and scalability of Web applications across multiple operating environments, including Windows, Linux, Oracle Solaris, and Mac OS X.

The MySQL 5.5 Community Edition, licensed under the GNU General Public License (GPL), is available for free download, includes InnoDB as the default storage engine. This release benefitted from substantial user community participation and feedback on the MySQL 5.5 Release Candidate, helping to provide a more broadly tested product.

The 5.5 release of MySQL provides the customization capabilities and scalability that MySQL DBAs and developers need to more efficiently build, maintain, and scale Web applications. With the MySQL 5.5 release users benefit from:

  • Improved performance and scalability: MySQL Database and InnoDB storage engine have been enhanced to provide optimum performance and scalability when running on the latest multi-CPU and multi-core hardware and operating systems. In addition, with release 5.5, InnoDB is now the default storage engine for the MySQL Database, delivering ACID transactions, referential integrity and crash recovery.

  • Higher availability: New semi-synchronous replication and Replication Heart Beat improve failover speed and reliability.

  • Improved usability: Improved index and table partitioning, SIGNAL/RESIGNAL support and enhanced diagnostics, including a new PERFORMANCE_SCHEMA, improve the manageability of MySQL 5.5.

In recent benchmarks, the MySQL 5.5 release candidate delivered significant performance improvements compared to MySQL 5.1. Results included:

  • On Windows: Up to 1,500 percent performance gains for Read/Write operations and up to 500 percent gain for Read Only.

  • On Linux: Up to 360 percent performance gain in Read/Write operations and up to 200 percent improvement in Read Only.2

More information is available at www.oracle.com.