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.
It is not often that a robot, especially a small cheap robot you can actually buy, does something fundamental so differently that you just have to keep watching the video. In this case Marty the robot [ ... ]