What is MariaDB 5.5
MariaDB 5.5.25-stable (GA) Release Notes | Changelog
MariaDB 5.5.24-stable (GA) Release Notes | Changelog
MariaDB 5.5.23-stable (GA) Release Notes | Changelog
MariaDB 5.5.22-rc Release Notes | Changelog
MariaDB 5.5.21-beta Release Notes | Changelog
MariaDB 5.5.20-alpha Release Notes | Changelog
Contents
MariaDB 5.5 is mostly MariaDB 5.3 + MySQL 5.5, with a few added features.
Feature Comparison Matrix
We have created an Optimizer Feature Comparison Matrix showing the new optimizer features in MariaDB 5.5 and 5.3 compared to MySQL 5.5 and 5.6.
New features
- Significantly more efficient thread pool, comparable in functionality to the closed source feature in MySQL Enterprise.
- Non-blocking client API Library (MWL#192)
- @@skip_replication option (MWL#234)
- SphinxSE updated to version 2.0.4.
- Extended Keys support for XtraDB and InnoDB
- New
INSTALL SONAME
statement - New
LIMIT ROWS EXAMINED
optimization. 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 withmysql_option()
when it fails. Beginning with MariaDB 5.5.21, options are preserved by a failingmysql_real_connect();
usemysql_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).
- In MySQL, and in MariaDB versions before 5.5.21,
- The variables
replicate_do_*
,replicate_ignore_*
, andreplicate_wild_*
have been made dynamic, so they can be changed without requiring a server restart. See Dynamic Replication Variables for more information.
- The new plugin to log SQL level errors. SQL_ERROR_LOG
Minor extensions
- Updates to performance schema tables are not stored in binary log 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 MariaDB 5.6.
Deprecated / disabled features
- PBXT is not anymore in the binary builds/distributions. It's however still in the source distributions and in the source tree. The reason is that PBXT is not actively maintained anymore, it has a few bugs that are not fixed and it's not that much in use.
You can easily switch between InnoDB and XtraDB
MariaDB 5.5 comes with both XtraDB (compiled in) and InnoDB (as a plugin). By default MariaDB 5.5 uses XtraDB. If you want to switch to use InnoDB you can do:
mysqld --ignore-builtin-innodb --plugin-load=innodb=ha_innodb.so \ --plugin_dir=/usr/local/mysql/lib/mysql/plugin
(plugin_dir should point to where ha_innodb.so is installed)
The above options can of course also be added to your my.cnf
file:
[mysqld] ignore-builtin-innodb plugin-load=innodb=ha_innodb.so plugin_dir=/usr/local/mysql/lib/mysql/plugin
If you want you can also compile MariaDB with InnoDB as default.