What is MariaDB 5.2 - Source

<<style class="greenbox" style="text-align:center;font-family:Droid Sans;font-weight:bold;font-size:1.2em;">> [[http://downloads.askmonty.org/mariadb/5.2|Download MariaDB 5.2]] <</style>> <<style class="bluebox" style="text-align:center;font-size:0.8em;font-family:Droid Sans;">> MariaDB 5.2.11 [[mariadb-5211-release-notes|Release Notes]] | [[mariadb-5211-changelog|Changelog]]\\ <</style>> MariaDB 5.2 contains features that didn't have time to go into MariaDB 5.1. For all practical purposes it's a drop in replacement for MariaDB 5.1 (and thus MySQL 5.1). MariaDB 5.2 is based on [[what-is-mariadb-51|MariaDB 5.1]] and thus MySQL 5.1. The new features in 5.2 are quite isolated and as most have been in use by members in the MySQL community for a long time. Current versions of MariaDB 5.2 are [[release-criteria|stable]] and can be downloaded from [[http://downloads.askmonty.org]]. === New storage engines * [[oqgraph|OQGRAPH]] ** Allows you to handle hierarchies (tree structures) and complex graphs (nodes having many connections in several directions) * [[sphinxse|SphinxSE]]: Text search withing MariaDB. ** A built-in Sphinx client which allows MariaDB to talk to searchd, run search queries, and obtain search results. === New features * [[virtual-columns|Virtual columns]] ** Columns that are an expression and are calculated on retrieval. * [[user-statistics|Extended User Statistics]] ** Client, User, Index and Table statistics. * [[segmented-key-cache|Segmented MyISAM key cache]] ** The key cache's global mutex is split into several mutex which gives a notable speed improvement under multi user load. We have registered up to [[segmented-key-cache-performance | 250% more performance]] thanks to this. * [[pluggable-authentication|Pluggable Authentication]] ** Authentication is done via an extensible plugin, which makes it easy to add any kind of authentication to MariaDB. * [[extending-create-table|Storage-engine-specific CREATE TABLE]] ** Allows one to specify additional attributes per field, index or table to the storage engine. * [[information_schemaplugins-table|Enhancements to INFORMATION SCHEMA.PLUGINS table]] ** We expose more information about the plugins, like maturity levels. * [[aria-group-commit|Group commit]] for the [[aria|Aria]] engine. ** Speeds up multi user inserts. === Other things We have also done several smaller speed improvements, bug fixes and code cleanups.