MariaDB 10.0 is no longer maintained. Please use a more recent release.
The most recent release in the MariaDB 10.0 series is:MariaDB 10.0.38 Download Now
MariaDB 10.0 is a previous stable series of MariaDB. It is built on the MariaDB 5.5 series with backported features from MySQL 5.6 and entirely new features not found anywhere else. The first stable release was in March 2014, and the final release was in January 2019.
For details on upgrading from MariaDB 5.5, see .
Blog posts with details of the reasoning behind calling this version MariaDB 10:
Features that are in a release.
For a list of all new variables, see
()
() — Original code from .
as DEFAULT for columns ()
(, )
New InnoDB — from MySQL 5.6.14 in onwards
New — from MySQL 5.6.10 in onwards
New tables, updates and defaults.
Optimized read only transaction (for InnoDB). This includes support for .
New : RETURNING. This can no longer be used as an without being quoted.
For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.
: : : : : : : : : : : : : : : : : : : : : : : : : : : : :
See
Plans for 10.x
Slave started with can replicate from master with any type of Starting from MariaDB 10.0.22.
storage engine (MDEV-4146)
Better . storage engine. Assisted discovery in (MDEV-3808)
storage engine (MDEV-4438)
storage engine (MDEV-4507)
full-text search storage engine
for non-indexed columns (MDEV-4145)
command (MDEV-165)
(MDEV-407)
Per thread memory usage (MDEV-4011). — Original code from Taobao, developed by Peng Lixun.
has two new columns: MEMORY_USAGE and EXAMINED_ROWS.
has a new variable: .
statement (MDEV-4660)
, not thread id (MDEV-4911)
Faster UNIQUE key generation with (MDEV-539)
Implement async commit checkpoint in InnoDB and XtraDB (MDEV-532)
Support for (MDEV-4338)
IF (NOT) EXISTS clauses for (MDEV-318)
variable to specify how CREATE TABLE and DROP TABLE is replicated.
now support names (MDEV-377)
multiple use locks () in one connection (MDEV-3917)
Better error messages (all error numbers now include descriptive text explaining what the number means)
with sysvar as a default value (MDEV-4022)
regular expression enhancements
new regular expression library with modern features ()
new functions , , .
. Shows you which meta data locks are active.
for MyISAM and Aria. This can greatly improve shutdown time (from hours to minutes) if you are using a lot of MyISAM/Aria tables with delayed keys.
The optimization is enabled by default
is now visible through the and a new status variable,
flood protection
Filesort optimization for queries using the ORDER BY ... LIMIT optimization - A useful optimization for showing only a few rows of a bigger result set. (MDEV-4026)
backport (MDEV-3860)
Online (MDEV-3933) (ALGORITHM=INPLACE, etc)
.
privileges on temporary tables
character set related extenstions
Partition selection
Temporal literals (such as TIME'12:34:56')
function
Collation customization improvements (see )
and functions
Stable (GA)
3 May 2018
Stable (GA)
30 Jan 2018
Stable (GA)
30 Oct 2017
Stable (GA)
7 Aug 2017
Stable (GA)
23 May 2017
Stable (GA)
8 Mar 2017
Stable (GA)
13 Jan 2017
Stable (GA)
28 Oct 2016
Stable (GA)
25 Aug 2016
Stable (GA)
24 Jun 2016
Stable (GA)
30 Apr 2016
Stable (GA)
19 Feb 2016
Stable (GA)
18 Dec 2015
Stable (GA)
29 Oct 2015
Stable (GA)
6 Aug 2015
Stable (GA)
18 Jun 2015
Stable (GA)
9 May 2015
Stable (GA)
7 May 2015
Stable (GA)
27 Feb 2015
Stable (GA)
27 Jan 2015
Stable (GA)
25 Nov 2014
Stable (GA)
26 Sep 2014
Stable (GA)
11 Aug 2014
Stable (GA)
16 Jun 2014
Stable (GA)
12 May 2014
Stable (GA)
31 Mar 2014
Stable (GA)
10 Mar 2014
Release Candidate
10 Feb 2014
Release Candidate
27 Dec 2013
Beta
18 Nov 2013
Beta
7 Nov 2013
Beta
16 Aug 2013
Alpha
11 Jun 2013
Alpha
24 Apr 2013
Alpha
6 Feb 2013
Alpha
12 Nov 2012
Alpha
31 Jan 2019
Stable (GA)
1 Nov 2018
Stable (GA)
1 Aug 2018
This page is licensed: CC BY-SA / Gnu FDL