The Ultimate Guide to High Availability with MariaDB

What is MariaDB 5.3

You are viewing an old version of this article. View the current version here.

The focus for MariaDB 5.3 is to improving the optimizer, especially for sub queries and complex/big joins.

MariaDB 5.3 is based on MariaDB 5.2 and thus on MariaDB 5.1 and MySQL 5.1.

Some of the code is backported from MySQL 6.0 and improved. Other code is written from scratch.

This is the biggest redesign of the MariaDB optimizer in 10 years and it will finally make all sub queries usable in MariaDB.

The plan is to have a gamma version of MariaDB 5.3 in December.

New already implemented features

  • Faster joins thanks to MRR (Multi-Read-Range access).
  • Faster joins thanks to BKA (Batch key access).
  • Better optimizations for derived tables and views.
  • Faster sub queries.
    • Avoid recalculating subquery if external fields values found in subquery cache
    • Backporting subquery optimization from 6.0
  • No materialization for many kinds of sub queries in the FROM clause.
  • Hash joins

For a more specfifc list and for things that are still planned, see the MariaDB 5.3 TODO page.

You can access the MariaDB 5.3 tree from launchpad.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.