<<include slug="latest-53">>
[[http://downloads.askmonty.org/mariadb/5.3.3|Download]] |
**Release Notes** |
[[mariadb-533-changelog|Changelog]]
**Release date:** 21 Dec 2011
MariaDB 5.3.3 is a [[release-criteria|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.
<<style class="greenbox">>
**For a detailed description of MariaDB 5.3 see the [[what-is-mariadb-53|What is MariaDB 5.3]] page.**
<</style>>
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-features-in-533|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:
*** [[non-semi-join-subquery-optimizations#materialization-for-non-correlated-in-subqueries|Subquery materialization]] is now ON by default (materialization=on)
*** [[semi-join-subquery-optimizations|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) (Documentation is being worked on)
*** [[index-condition-pushdown|Index Condition Pushdown]] is now ON by default (index_condition_pushdown=on)
*** Nested loop join will use its [[block-based-join-algorithms|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|EXPLAIN]]## output has been improved to be easier to understand
*** <<code>>select_type<</code>> column now shows <<code>>MATERIALIZED<</code>> for subqueries that are executed with Materialization (it used to show <<code>>SUBQUERY<</code>> before which made it hard to distinguish materialized subqueries from other kinds subqueries.
*** For [[duplicateweedout-strategy|Duplicate Elimination]] strategy, <<code>>Start temporary<</code>> is now shown at the first table from the subquery.
* **Other:**
** Ubuntu 11.10 "Oneiric" [[http://downloads.askmonty.org/mariadb/repositories/|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 the
[[mariadb-533-changelog|MariaDB 5.3.3 Changelog]]. It is worth noting that
[[what-is-mariadb-53|MariaDB 5.3]] is built on [[what-is-mariadb-52|MariaDB 5.2]],
[[what-is-mariadb-51|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.
<<style class="bluebox" style="font-size:0.8em;font-family:'Droid Sans';">>
Be notified of new releases automatically by adding the
[[http://montyprogram.com/news/feed/mariadb_releases/|releases rss feed]] to
your favorite feed reader or by [[http://mariadb.org|subscribing]] to the
announce 'at' mariadb.org announcement list (this is a low traffic,
announce-only list).
<</style>>
<<style class="bluebox" style="font-size:0.8em;font-family:'Droid Sans';">>
MariaDB may already be included in your favorite OS distribution. More
information can be found on the
[[distributions-which-include-mariadb|Distributions which Include MariaDB]]
page.
<</style>>
