The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-23. For the latest, interactive version please visit https://mariadb.com/kb/.

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:

For a list of every change made in MariaDB 5.3.3, with links to detailed information on each push, see the MariaDB 5.3.3 Changelog. It is worth noting that MariaDB 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 releases automatically by adding the releases rss feed to your favorite feed reader or by subscribing to the announce 'at' mariadb.org announcement list (this is a low traffic, announce-only list).

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

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.