The MariaDB team has announced the release of version 5.3.5, the first stable general availability release of the MariaDB 5.3 series relational database.

Work on the new series has concentrated on improving the performance of the database, in particular query speeds.

MariaDB is the community-developed spin-off of MySQL that was started when Oracle took over the original MySQL. MariaDB is developed by Monty Program, which was started by Monty Widenius, the main developer of the original version of MySQL.

The areas where the query optimizer has been improved start with subqueries, which now work well enough to avoid having to rewrite subqueries manually into joins or into separate queries. The Maria Knowledgebase says that all problems with EXPLAIN taking a long time have also been resolved.

The optimizer changes include support for block hash joins for any equi-joins. There’s a new implementation of Multi-Range-Read optimization to improve performance for IO-bound queries that need to scan lots of rows, and all block-based algorithms for joins can make use of index condition pushdown.

More Information

MariaDB

Download MariaDB 5.3.5

Release Notes

Related Articles

MariaDB Crash Course  (Book Review)

Comments

Make a Comment or View Existing Comments Using Disqus

or email your comment to: comments@i-programmer.info

To be informed about new articles on I Programmer, subscribe to the RSS feed, follow us on Google+, Twitter, Linkedin or Facebook or sign up for our weekly newsletter.