The Open Source MySQL database, which is now maintained by Sun Microsystems after Sun's acquisition, benefits from a performance boost and easier management following the update to version 5.1.

Mårten Mickos, who is responsible for Sun's database division, recently announced the imminent release at the MySQL conference in Santa Clara. Thus far, only a release candidate has been available for downloading although the release is scheduled for Q2.

The new functions announced by Sun include table and index partitioning. Partitioning will reduce database response times by splitting up the index and focusing searches on relevant areas.

A new event scheduler is available for frequently re-occurring tasks. Commercial customers who opt for the MySQL Enterprise edition can look forward to a policy-based wizard in the MySQL Enterprise Monitor to point out possible issues with existing implementations.

When released, version 5.1 will support the Solaris 10, Red Hat Enterprise Linux, Suse Enterprise Linux, Windows, Mac OS X, FreeBSD, HP-UX, IBM AIX, and IBM i5/OS operating systems and other popular Linux distributions, says Sun.

Three editions are available: the free MySQL Community Server, the MySQL Enterprise Server with commercial subscription and support, and the MySQL Embedded Server which is available as a commercially licensed version for integration with third-party products.

The Open Source MySQL database, which is now maintained by Sun Microsystems after Sun's acquisition, benefits from a performance boost and easier management following the update to version 5.1.