Dear MariaDB users,

MariaDB Seal
MariaDB 5.2, a branch of the MySQL database which includes all major open source storage engines, myriad bug fixes and many community patches, has been released. It has all changes up to MySQL 5.1.51.

For an overview of what’s new in MariaDB 5.2.3, please see the release notes (5.2.2, 5.2.1, and 5.2.0 also).

MariaDB 5.2 includes a number of user enhancements including:

For fine-grained details, please see the changelogs for 5.2.3, 5.2.25.2.1 and 5.2.0. For information about any of the features, and highlighted user enhancements above, please check the AskMonty Knowledgebase for articles and other resources.

MariaDB is available in source and binary form for a variety of platforms, including Microsoft Windows, Debian, Ubuntu, Red Hat Enterprise Linux 5, CentOS 5, and Solaris x86. These are available from the download page.

Enjoy!

If you’re trying to email anyone at @askmonty.org or @montyprogram.com, you’ll notice that you’re getting a bounce. No, we’ve not disappeared from the face of the earth – we’re just having issues with our ISP. We’re still writing code to make MariaDB better, we even managed to sneak in a release of MariaDB (yes, 5.2 is now released – download 5.2.3 now!)

We’ll keep you updated on the situation as our ISP fixes the problem.

Update: 12/11/2010, 8.15am UTC – email services are back up. If you tried sending us stuff in the last few days, don’t hesitate to resend it.

Recently I tested our new segmented key cache feature for MyISAM in MariaDB 5.2.2-gamma for performance gains. You can check our new features in MariaDB 5.2 in our Ask Monty Knowledge Base

You will also find the details about the segmented key cache feature in our Knowledge Base at:

We wrote a test in LUA for SysBench v0.5 called select_random_points.lua, to figure out the performance gain of splitting the key cache’s global mutex into several mutex under multi user load.

You can find all the details about the benchmark in our Knowledge Base article here:

The results were quite surprising, because we found up to 250% performance gain depending on the amount of concurrent users. On a side note we also found out that our new Intel system with 24 virtual cores has more than a 10 times performance advantage compared to our older 4 core system.