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: 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:
For a list of every change made in , with links to detailed information on each push, see the . It is worth noting that is built on ,, and MySQL 5.1.
In most respects will work exactly as MySQL: all commands, interfaces, libraries and APIs that exist in MySQL also exist in MariaDB.
is now ON by default (materialization=on)
is now ON by default (semijoin=on,firstmatch=on,loosescan=on)
is now ON by default (derived_merge=on,derived_with_keys=on)
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 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.
This page is licensed: CC BY-SA / Gnu FDL