MariaDB 5.5 is no longer maintained. Please use a more recent release.
The most recent release in the MariaDB 5.5 series is:MariaDB 5.5.68 Download Now
MariaDB 5.5 is MariaDB 5.3 + MySQL 5.5, with added features. The first stable release was in April 2012, and the final release in May 2020.
For upgrading to MariaDB 10.0, the more recent stable release, see .
We have created an Optimizer Feature Comparison Matrix showing the new optimizer features in and 5.3 compared to MySQL 5.5 and 5.6.
See also a detailed breakdown of .
Significantly more efficient , comparable in functionality to the closed source feature in MySQL Enterprise.
()
()
updated to version 2.0.4.
There are a number of new tables:
Updates to performance schema tables are not stored in the and thus not replicated to slaves. This is to ensure that monitoring of the master will not cause a slower performance on all slaves. This also fixes a crash on the slaves.
New features are added to .
is no longer in the binary builds/distributions. It's however still in the source distributions and in the source tree. The reason is that PBXT is no longer actively maintained, has a few bugs that are not fixed and is not in widespread use.
comes with both (compiled in) and InnoDB (as a plugin). By default uses XtraDB. If you want to switch to use InnoDB you can do:
( should point to where ha_innodb.so is installed)
The above options can of course also be added to your file:
If you want you can also compile MariaDB with .
For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.
: : : : : : : : : : : : : : : : : : : : : : : : : : : : :
The following CVEs are also fixed in but the fix is not tied to a specific version number:
Extended Keys support for XtraDB and InnoDB
New statement (MWL#77)
New optimization (MDEV-28)
mysql_real_connect() Changes
In MySQL, and in MariaDB versions before 5.5.21, mysql_real_connect()
removes from the MYSQL object any options set with mysql_option() when
it fails. Beginning with MariaDB 5.5.21, options are preserved by a
failing mysql_real_connect(); use mysql_close(), as normal, to clear
them.
This only has effect if the MYSQL object is reused after
a mysql_real_connect() failure (which is unusual). No real-life
incompatibilities are expected from this change (it is unlikely that an
application would rely on options being automatically removed between
connection attempts).
The variables replicate_do_*, replicate_ignore_*,
and replicate_wild_* have been made dynamic, so they can be changed
without requiring a server restart. See for more
information.
New for checking if features are used. These are very useful in to tell developers how much a feature is used:
New to see what's going on:
New plugin to log SQL level errors.
New variable to set compatibility behavior with older MySQL or MariaDB versions.
Stable (GA)
31 Jul 2019
Stable (GA)
29 Apr 2019
Stable (GA)
30 Jan 2019
Stable (GA)
26 Oct 2018
Stable (GA)
31 Jul 2018
Stable (GA)
23 Apr 2018
Stable (GA)
19 Jan 2018
Stable (GA)
18 Oct 2017
Stable (GA)
19 Jul 2017
Stable (GA)
3 May 2017
Stable (GA)
13 Apr 2017
Stable (GA)
24 Dec 2016
Stable (GA)
17 Oct 2016
Stable (GA)
13 Sep 2016
Stable (GA)
10 Aug 2016
Stable (GA)
17 Jun 2016
Stable (GA)
22 Apr 2016
Stable (GA)
11 Feb 2016
Stable (GA)
10 Dec 2015
Stable (GA)
12 Oct 2015
Stable (GA)
6 Aug 2015
Stable (GA)
11 Jun 2015
Stable (GA)
1 May 2015
Stable (GA)
19 Feb 2015
Stable (GA)
21 Dec 2014
Stable (GA)
9 Oct 2014
Stable (GA)
5 Aug 2014
Stable (GA)
9 Jun 2014
Stable (GA)
17 Apr 2014
Stable (GA)
25 Feb 2014
Stable (GA)
29 Jan 2014
Stable (GA)
21 Nov 2013
Stable (GA)
20 Sep 2013
Stable (GA)
17 Sep 2013
Stable (GA)
18 Jul 2013
Stable (GA)
23 May 2013
Stable (GA)
12 Mar 2013
Stable (GA)
30 Jan 2013
Stable (GA)
29 Nov 2012
Stable (GA)
22 Oct 2012
Stable (GA)
7 Sep 2012
Stable (GA)
22 Jun 2012
Stable (GA)
31 May 2012
Stable (GA)
11 Apr 2012
Stable (GA)
29 Mar 2012
Release Candidate
16 Mar 2012
Beta
25 Feb 2012
Alpha
12 May 2020
Stable (GA)
28 Jan 2020
Stable (GA)
5 Nov 2019
mysqld --ignore-builtin-innodb --plugin-load=innodb=ha_innodb.so \
--plugin_dir=/usr/local/mysql/lib/mysql/plugin[mysqld]
ignore-builtin-innodb
plugin-load=innodb=ha_innodb.so
plugin_dir=/usr/local/mysql/lib/mysql/pluginThis page is licensed: CC BY-SA / Gnu FDL