Oracle Announces MySQL 5.5 Release Candidate
By Monica Kumar-Oracle on Sep 20, 2010
Yesterday, Sept. 19, 2010 at the inaugural MySQL Sunday event at Oracle OpenWorld, we announced the MySQL 5.5 Release Candidate. The MySQL 5.5 release candidate helps improve the performance and scalability of applications across multiple operating environments, including Windows, Linux, and Mac. Enhancements include:
MySQL Server and InnoDB have been enhanced to provide optimum performance and scalability when running on the latest multi-CPU and multi-core hardware and operating systems.
- InnoDB is now the default storage engine for MySQL Server, delivering ACID transactions, referential integrity, and crash recovery.
New semi-synchronous replication improves failover reliability by allowing the master to proceed without waiting for all the slaves to acknowledge. Once one slave acknowledges, the transaction can be committed. This also helps improve data integrity.
Replication Heart Beat enables faster detection, diagnosis and correction of master/slave synchronization issues, helping improve the reliability and availability of data by reducing the risk and impact of master/slave synchronization issues.
Improved index and table partitioning enables RANGE and LIST partitions to be defined on date, datetime, varchar, and char columns, simplifying and extending MySQL and adding flexibility to indexing and query tuning.
DBAs and developers can save time using the ANSI/ISO standard SIGNAL/RESIGNAL syntax inside stored routines, including triggers, to raise an error condition invoking specific error handling within their applications.
Enhanced diagnostics, including a new ERFORMANCE_SCHEMA, provide low-level diagnostics on MySQL server performance statistics, allowing DBAs to pinpoint resource-intensive processes and events, streamlining efforts and helping to enhance their productivity.
MySQL 5.5 Release Candidate Demonstrates Significant Performance Gains in Real-World Tests
In recent benchmarks using the release candidate for MySQL 5.5, compared to MySQL 5.1, results demonstrated marked performance improvements:
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.
Download the release candidate today.