Oracle has announced a new release of MySQL. Version 5.5 has debuted and with it come some decent enhancements.
Some of the enhanced capabilities of this new release include:
- 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.
Oracle also claims that this release has some significant performance improvements such as:
- On Windows: Up to 1,500 percent performance gains for Read/Write operations and up to 500 percent gain for Read Only.(1)
- On Linux: Up to 360 percent performance gain in Read/Write operations and up to 200 percent improvement in Read Only.(2)
The full press release is available here: http://www.oracle.com/us/corporate/press/195726