MariaDB 5.3.3 Release Notes

The most recent release in the MariaDB 5.3 series is:MariaDB 5.3.12

Download |Release Notes |Changelog |Overview of 5.3

Release date: 21 Dec 2011

MariaDB 5.3.3 is a Release Candidate release. In general this means that there are no known serious bugs, except for those marked as feature requests and no bugs were fixed since last the release which caused any notable code changes. We believe the code is ready for general usage (based on bug inflow), but we want more testing before calling it stable.

MariaDB 5.3 radically improves performance for subqueries as well as for joins and single-table queries over large data sets.

For a detailed description of MariaDB 5.3 see the What is MariaDB 5.3 page.

Compared to MariaDB 5.3.0, 5.3.1, and 5.3.2, MariaDB 5.3.3 is a bug-fix release with a focus on stability, performance, and usability. It is the third beta release of the 5.3 series and fixes bugs found in the initial 5.3.0 and 5.3.1 beta releases.

• New feature: GIS precise operations were added (Documentation is being worked on)

• Stability: All known critical bugs have been fixed.

• Performance:

  • More optimizer features have been thoroughly tested, and switched on by default:

    • Subquery materialization is now ON by default (materialization=on)

    • Semi-join optimizations is now ON by default (semijoin=on,firstmatch=on,loosescan=on)

    • Derived table optimization is now ON by default (derived_merge=on,derived_with_keys=on)

    • Index Condition Pushdown is now ON by default (index_condition_pushdown=on)

    • Nested loop join will use its Block-based variant more aggressively

      • Block-based join for OUTER JOINs is ON by default (outer_join_with_cache=on)

      • Block-based join for semi-joins is ON by default (semijoin_with_cache=on)

      • Linked join buffers (more aggressive buffering of multi-way joins) is ON by default (@@join_cache_level==2)

  • DISTINCT and GROUP BY clauses are removed from subqueries when possible. This allows for more efficient query plans (backported from MySQL 5.6)

• Usability:

  • EXPLAIN output has been improved to be easier to understand

    • select_type column now shows MATERIALIZED for subqueries that are executed with Materialization (it used to show SUBQUERY before which made it hard to distinguish materialized subqueries from other kinds subqueries.

    • For Duplicate Elimination strategy, Start temporary is now shown at the first table from the subquery.

• Other:

  • Ubuntu 11.10 "Oneiric" repositories are now available for MariaDB 5.3.3.

For a list of every change made in MariaDB 5.3.3, with links to detailed information on each push, see theMariaDB 5.3.3 Changelog. It is worth noting thatMariaDB 5.3 is built on MariaDB 5.2,MariaDB 5.1, and MySQL 5.1.

In most respects MariaDB will work exactly as MySQL: all commands, interfaces, libraries and APIs that exist in MySQL also exist in MariaDB.

Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the Distributions which Include MariaDB page.

_{This page is licensed: CC BY-SA / Gnu FDL}