What to expect from MySQL 5.4?

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”.


Built from the Valley, MySQL 5.1.34 is available

Blogging and building live from MySQL Conf 09… If you want more details about what happens here (technical sessions, MySQL 5.4, InnoDB improvements, MySQL Cluster, Sun/Oracle fusion…) or want to enjoy a drink in the Valley, please let me know…

MySQL Conf 09
credits : Duncan Davidson

Back to the Dotdeb business : MySQL 5.1.34 has been published with its lot of bugfixes. It is now built and available on Dotdeb for your Lenny/Etch amd64/i386 Debian servers. No change in the packaging, just apt-get upgrade


Minor update of the PHP 5.2.9 packages

The PHP 5.2.9 packages for Etch/Lenny amd64/i386 have been updated :

  • some obsolete ./configure options have been deleted
  • the sigchild support has been dropped
  • a memory leak has been fixed

PHP 5.3.0 RC1 packages for Lenny

A few days ago, the first release candidate of PHP 5.3.0 has been published by the PHP Group, providing many improvements :

I just built the packages for Debian GNU/Linux 5.0 “Lenny” on amd64 and i386 and I will maintain them during the whole release cycle (RC2 and so on…).

Please note that they should NOT be installed on production servers : Suhosin and some important patches are not applied, PECL extensions are not available (yet)… They’re here for testing purpose only.

To fetch them, just add these temporary entries in your /etc/apt/sources.list and upgrade your instances :

deb stable all
deb-src stable all

But please DO read the full announcement before any further move.


MySQL 5.1 updated

Quick post : MySQL AB has just released MySQL 5.1.33… This maintenance release fixes several bugs… The packages are now available for Lenny and Etch, amd64 and i386…They re-introduces the readline support in the MySQL client… Enjoy.