With the MySQL 5.5 release that finally arrived, we get:
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.
MySQL 5.5 Delivers Major Performance Gains:
-------------------------------------------
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.(1)
On Linux: Up to 360 percent performance gain in Read/Write operations and up to 200 percent improvement in Read Only.(2)
Try it and you will get better mysql.
