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.
The I-Programmer team covers a lot each week, but there's far more out there than we can possibly cover. So we are really pleased to welcome a weekly round up of items from other blogs. This week they [ ... ]
A new free open online course to teach the basics of the C programming language has been made available by Aalto University and the University of Helsinki, using the same material as the C programming [ ... ]