MySQL 5.4 has been announced at the opening session of MySQL Conference 2009 and a preview is available for download. This release may look as a compromise between the current 5.1 and the major 6.0 branches, but it includes many (IMHO needed) improvements :
- Sub-query optimizations
- A new query algorythms
- Replication killer features : replication heartbeat and semi-synchronous replication!
- Google SMP patch (even for Solaris x86 and Sparc) and IO patches
- Update of many antiquated defaults in the MySQL Server (like replication-related –master-host and so on…)
- InnoDB improvements (such as scalability up to 16way x86 and up to 64way CMT servers)
- A couple of performance fixes backported from 6.0
- Dtrace integration on supported OSes
The results? 59% faster than 5.1, 40% improvement in read/write test, 71% throughput increase!
For more info, read “A Quick Look at MySQL 5.4”.