MariaDB 10.1 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
: InnoDB fails to start when FTS table has FK relation
See also the release notes for for additional items of note
Fixes for the following :
Changelog
For a complete list of changes made in , with links to detailed
information on each push, see the .
Contributors
For a full list of contributors to , see the .
A file format compatibility bug that was introduced in was fixed in .
Using or non-default created files that were incompatible with or MySQL 5.6. and higher will convert affected files from earlier releases to a compatible format.This prevents a downgrade to earlierversions.
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 10.1.38 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 6 Feb 2019
is a previous stable series of MariaDB. It is an evolution
of with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview ofsee the
MariaDB 10.1.25 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 4 Jul 2017
is the previous stable series of MariaDB. It is an evolution
of with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview ofsee the
MariaDB 10.1.27 Release Notes
The most recent release of is: Stable (GA)
A regression was discovered after the release of . It has been pulled from the downloads system, but some mirrors may still have it. Do not download or install this version. Stay with until 10.1.28 is released.
| | |
Release date: 25 Sep 2017
is the previous stable series of MariaDB. It is an evolution
of with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
MDEV-13671: InnoDB should use case-insensitive column name comparisons like the rest of the server
ALTER TABLE fixes: , , , ,, ,
Improvements to InnoDB page checksum, recovery, and mariadb-backup: ,, , ,
Galera
: Galera durability fix
New configuration variable wsrep_certification_rules, used for
controlling whether to use new/optimized
(--wsrep_certification_rules=optimized) certification rules or the
old/classic ones (--wsrep_certification_rules=strict
Debian has stopped supporting the ppc64el architecture for Debian 8
Jessie and so this is the last release of on Jessie for that
architecture
Fixes for the following :
Changelog
For a complete list of changes made in MariaDB 10.1.38, with links to detailed
information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB can no longer be compiled with OpenSSL version 0.9.8 and below. The last 0.9.8 release was in December 2015, it is out of support and is no longer getting security fixes.
For a complete list of changes made in MariaDB 10.1.25, with links to detailed
information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
For a complete list of changes made in MariaDB 10.1.27, with links to detailed
information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
For a complete list of changes made in , with links to detailed
information on each push, see the .
Contributors
For a full list of contributors to , see the .
Thanks, and enjoy MariaDB!
A file format compatibility bug that was introduced in was fixed in .
Using or non-default created files that were incompatible with or MySQL 5.6. and higher will convert affected files from earlier releases to a compatible format.This prevents a downgrade to earlierversions.
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the current stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
was not released.
For an overview ofsee thepage.
Thanks, and enjoy MariaDB!
Notable Changes
updated to 5.6.30-76.3
updated to 5.6.31
updated to 5.6.31
Changelog
For a complete list of changes made in , with links to detailed
information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
ALTER TABLE...DISCARD TABLESPACE still takes long on a large buffer pool
innodb_defragment=ON trumps innodb_optimize_fulltext_only=ON in OPTIMIZE TABLE
Security Fixes
Fixes for the following :
CVE-`-```
Changelog
For a complete list of changes made in , with links to detailed
information on each push, see the .
Contributors
For a full list of contributors to , see the .
A file format compatibility bug that was introduced in was fixed in .
Using or non-default created files that were incompatible with or MySQL 5.6. and higher will convert affected files from earlier releases to a compatible format.This prevents a downgrade to earlierversions.
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
For a complete list of changes made in with links to detailed
information on each push, see the .
Contributors
For a full list of contributors to , see the .
A file format compatibility bug that was introduced in was fixed in .
Using or non-default created files that were incompatible with or MySQL 5.6. and higher will convert affected files from earlier releases to a compatible format.This prevents a downgrade to earlierversions.
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
For a complete list of changes made in , with links to detailed
information on each push, see the .
Contributors
For a full list of contributors to , see the .
A file format compatibility bug that was introduced in was fixed in .
Using or non-default created files that were incompatible with or MySQL 5.6. and higher will convert affected files from earlier releases to a compatible format.This prevents a downgrade to earlierversions.
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the current stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
For a complete list of changes made in , with links to detailed
information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the current stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
For a complete list of changes made in , with links to detailed
information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 10.1.33 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 9 May 2018
is the previous stable series of MariaDB. It is an evolution
of with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview ofsee the
MariaDB 10.1.35 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 7 Aug 2018
is a previous stable series of MariaDB. It is an evolution
of with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview ofsee the
MariaDB 10.1.41 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 31 Jul 2019
is a previous stable series of MariaDB. It is an evolution
of with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview ofsee the
MariaDB 10.1.37 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 2 Nov 2018
is a previous stable series of MariaDB. It is an evolution
of with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview ofsee the
MariaDB 10.1.31 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 6 Feb 2018
is the previous stable series of MariaDB. It is an evolution
of with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview ofsee the
MariaDB 10.1.42 Release Notes
The most recent release of is: Stable (GA)
After an upgrade MariaDB Server can crash if InnoDB tables exist with a FULLTEXT INDEX and a FOREIGN KEY constraint attached to them. We got reports that the crash already will be encountered on startup, but a crash is also possible at a later stage. See for more details.Do not download or use this release.
| | |
Release date:
MariaDB 10.1.19 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 7 Nov 2016
is the current stable series of MariaDB. It is an evolution
of with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
As per the , this will be
the last release of for Debian 7 Wheezy
In this release experimental Ubuntu 18.04 "bionic" packages are present in the repository. However, because Ubuntu includes in its main repositories we recommend using the Ubuntu provided packages for general use.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
Packages for Ubuntu 16.10 Yakkety added. Use the Repository Configuration Tool to add the MariaDB Ubuntu repository to your system.
Fixes for the following :
(re-issued later as )
Changelog
For a complete list of changes made in MariaDB 10.1.19, with links to detailed
information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the current stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Our repositories for Debian "Sid" and the newly-released Ubuntu 16.04 "Xenial"
use a new GPG signing key. As detailed in , APT 1.2.7 (and later)
prefers SHA2 GPG keys and now prints warnings when a repository is signed using
a SHA1 key like our existing GPG key. We have created a new SHA2 key for use
with these affected repositories.
Information about this key:
The Key ID is: C74CD1D8
The full fingerprint of the new key is: 177F 4010 FE56 CA33 3630 0305 F165 6F24 C74C D1D8
The key can be added using the following command:
The instructions in the
for Ubuntu 16.04 "Xenial" and Debian "Sid" have been updated to reference this
new key. Repositories for previous versions of Debian and Ubuntu still use the
old key, so no changes are needed there.
Windows
The Windows compiler used by MariaDB from this release drops Windows XP and Windows Server 2003 support.
Changelog
For a complete list of changes made in , with links to detailed
information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
For a complete list of changes made in , with links to detailed
information on each push, see the .
Contributors
For a full list of contributors to , see the .
A file format compatibility bug that was introduced in was fixed in .
Using or non-default created files that were incompatible with or MySQL 5.6. and higher will convert affected files from earlier releases to a compatible format.This prevents a downgrade to earlierversions.
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the previous stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
- Rollback progress log messages during crash recovery are intermixed with unrelated log messages
- install_db shows corruption
- innodb.drop_table_background failed
Security Fixes
Fixes for the following :
Notes
For a complete list of changes made in , with links to detailed
information on each push, see the .
A file format compatibility bug that was introduced in was fixed in .
Using or non-default created files that were incompatible with or MySQL 5.6. and higher will convert affected files from earlier releases to a compatible format.This prevents a downgrade to earlierversions.
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the current development series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
is extended with TO # clause which allows one to specify the number of the first binary log. ()
New system variables , and .
New system variable for determining how often the buffer pool dump status should be printed in the logs.
For a complete list of changes made in , with links to detailed
information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 10.1.5 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 4 Jun 2015
is the current development series of MariaDB. It is an evolution
of with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview ofsee the
MariaDB 10.1.21 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 18 Jan 2017
is the current stable series of MariaDB. It is an evolution
of with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview ofsee the
MariaDB 10.1.12 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 25 Feb 2016
is the current stable series of MariaDB. It is an evolution
of with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For a complete overview ofsee the
MariaDB 10.1.40 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 8 May 2019
is a previous stable series of MariaDB. It is an evolution
of with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview ofsee the
Bug #27326796 - MYSQL CRASH WITH INNODB ASSERTION FAILURE IN FILE PARS0PARS.CC
A new column, INFO_BINARY, has been added to the in order to avoid truncating queries with binary data (MDEV-7807)
updated to 3.2.21.
updated to 1.03.0007
Encryption for temporary files: temporary files created by the server (for binary log caches, for filesort, etc) are now encrypted if the encryption plugin is loaded and --encrypt-tmp-files was specified.
Numerous bugfixes.
New system variable allowing statement digests to be calculated using different lengths.
upgraded to 1.3.0, including the QUERY_DCL filter option.
New and Deprecated Distributions
As per the MariaDB Deprecation Policy, this will
be the final release of MariaDB 10.1 for Fedora 19 "Schrödinger's Cat", Ubuntu
10.04 LTS "Lucid", and Mint 9 LTS "Isadora". When the next version of MariaDB
10.1 is released, repositories for these distributions will go away.
We have also added a couple of new Linux distributions with this release. Both
Fedora 21 and Ubuntu 15.04 "Vivid" repositories are now available. As this is
the first release with these repositories, they are considered experimental.
Please let us know if you run into any issues with
them.
Repositories exist for 10.1, but because 10.1 is still Beta, they are not
visible in the repository configuration tool.
To configure a 10.1 apt, yum, or zypper repository using the tool, simply
select 10.0 and then when executing the instructions, change all occurrences of
'10.0' to '10.1'.
For a complete list of changes made in MariaDB 10.1.5, with links to detailed
information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
A file format compatibility bug that was introduced in MariaDB 10.1.0 was fixed in this version of MariaDB. Using or non-default created files that were incompatible with MariaDB 10.0 or MySQL 5.6. MariaDB 10.1.21 and higher will convert affected files from earlier MariaDB 10.1 releases to a compatible format.This prevents a downgrade to earlierMariaDB 10.1versions.See the commit for details.
For a complete list of changes made in MariaDB 10.1.21, with links to detailed
information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
For a complete list of changes made in MariaDB 10.1.12, with links to detailed
information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This release fixes a regression that was introduced by MariaDB 10.1.39 — by the first installation (not upgrades) of MariaDB rpm packages on a non-systemd Linux distribution, such as CentOS6, the newly created /var/lib/mysql was created with too restrictive file permissions, so clients could not access the unix socket /var/lib/mysql/mysql.sock.
Apart from the above bug fix, this release is identical to MariaDB 10.1.39.
Fixes for the following :
CVE-`-```
Changelog
For a complete list of changes made in MariaDB 10.1.40, with links to detailed
information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the previous stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
A file format compatibility bug that was introduced in was fixed in .
Using or non-default created files that were incompatible with or MySQL 5.6. and higher will convert affected files from earlier releases to a compatible format.This prevents a downgrade to earlierversions.
Changelog
For a complete list of changes made in , with links to detailed
information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the previous stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
: IMPORT TABLESPACE may corrupt ROW_FORMAT=REDUNDANT tables
: InnoDB writes CRYPT_INFO even though encryption is not enabled (fixes upgrades from 5.5 to 10.1)
Encryption
Temporary files created by merge sort and row log are encrypted if is set to 1, regardless of whether the table encrypted or not ().
Security Fixes
Fixes for the following :
CVE-`-```
Notes
For a complete list of changes made in , with links to detailed
information on each push, see the .
A file format compatibility bug that was introduced in was fixed in .
Using or non-default created files that were incompatible with or MySQL 5.6. and higher will convert affected files from earlier releases to a compatible format.This prevents a downgrade to earlierversions.
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the current stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
The support for system variable has now been added and thus its values will no longer be ignored by the server. In order to be backward compatible its default value has been changed to 0 (from 131072), which essentially allows writesets of any size.
The default value of has been raised from 1GB to 2GB.
Changelog
For a complete list of changes made in , with links to detailed
information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 10.1.8 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 17 Oct 2015
is the current stable series of MariaDB. It is an evolution
of with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
The release notes here only document changes from the previous version of. For a complete overview of
MariaDB 10.1.9 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 23 Nov 2015
is the current stable series of MariaDB. It is an evolution
of with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
CVE-2016-6662 (MDEV-10465). That allowed a malicious user to create a my.cnf in the datadir and, under certain circumstances, execute arbitrary code as mysql (or even root) user. This vulnerability was discovered by Dawid Golunski.
systemd support has been added for those distributions that support it.
For tables, the option
enables IETF-compatible parsing of embedded quote and comma characters
(MDEV-8682).
now
supports IPv6 ().
--silent-startup . If specified, mysqld does not
print Notes to log during startup.
Replication from MySQL 5.6 with GTID, binlog_rows_query_log_events and
ignorable events now works. In this case MariaDB will remove the MySQL GTIDs
and other unneeded events and instead adds its own .
New proxy server option for the , , for use when http calls cannot be made, such as in a firewall environment.
Explicit or implicit casts from MAX(string) to INT, DOUBLE or DECIMAL now produce warnings ().
Fixes for the following :
For a complete list of changes made in MariaDB 10.1.8, with links to detailed
information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
The field, seconds_behind_master, is now, with , only updated after transactions commit.
Includes all bug fixes from , , and releases.
Fixes for the following :
For a complete list of changes made in MariaDB 10.1.9, with links to detailed
information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the current stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Updating from to is highly recommended due to two high-priority regression fixes. See below for links to the relevant MDEVs.
updated to 5.6.35-80.0
updated to 5.6.35-80.0
updated to 8.40
A file format compatibility bug that was introduced in was fixed in .
Using or non-default created files that were incompatible with or MySQL 5.6. and higher will convert affected files from earlier releases to a compatible format.This prevents a downgrade to earlierversions.
Changelog
For a complete list of changes made in , with links to detailed
information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
maximum index size increased from 1000 to 3500 bytes ()
issue ()
Changelog
For a complete list of changes made in with links to detailed
information on each push, see the .
Contributors
For a full list of contributors to , see the .
A file format compatibility bug that was introduced in was fixed in .
Using or non-default created files that were incompatible with or MySQL 5.6. and higher will convert affected files from earlier releases to a compatible format.This prevents a downgrade to earlierversions.
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the previous stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Updating from to or higher is highly recommended due to two high-priority regression fixes. See and for details.
updated to 5.6.36-82.0
updated to 5.6.36-82.0
updated to 5.6.36
A file format compatibility bug that was introduced in was fixed in .
Using or non-default created files that were incompatible with or MySQL 5.6. and higher will convert affected files from earlier releases to a compatible format.This prevents a downgrade to earlierversions.
Changelog
For a complete list of changes made in , with links to detailed
information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the previous stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
- does not work properly when used with DATA DIRECTORY.
Security Fixes
Fixes for the following :
Notes
For a complete list of changes made in , with links to detailed
information on each push, see the .
Contributors
For a full list of contributors to , see the .
A file format compatibility bug that was introduced in was fixed in .
Using or non-default created files that were incompatible with or MySQL 5.6. and higher will convert affected files from earlier releases to a compatible format.This prevents a downgrade to earlierversions.
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 10.1.4 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 13 Apr 2015
is the current development series of MariaDB. It is an evolution
of with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release.
For an overview ofsee the
MariaDB 10.1.1 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 17 October 2014
is the current development series of MariaDB. It is an evolution
of with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
default changed from backoff to legacy to prevent potential deadlock issue in I/O-bound workloads with several small buffer pool instances in combination with small redo log files (see #1651657.)
Lots of changes related to encryption. See the . In particular:
The distinction between “tablespace encryption” and “page encryption” was removed, now there is only one single encryption feature. One can use both per-table encryption options and the global option at the same time.
Per table PAGE_ENCRYPTION option that could accept values of ON and OFF was renamed to ENCRYPTED with values YES and NO.
Per table PAGE_ENCRYPTION_KEY was renamed to ENCRYPTION_KEY_ID.
Global variable innodb_default_page_encryption_key become a session .
The command-line option can take the value of FORCE. In this case XtraDB/InnoDB will refuse to create unencrypted tables (CREATE TABLE ... ENCRYPTED=NO will fail).
XtraDB/InnoDB on disk format for encrypted tablespaces and logs was changed. Tables encrypted in 10.1.3 may fail to open.
Key management plugins were renamed not to have “plugin” in the name, for example, “file_key_management_plugin” is now “file_key_management”.
“Key management plugin” type was expanded and renamed to match the new broader set of responsibilities. It is now called .
Command-line option innodb-scrub-log-interval was renamed to and now sets the log scrubbing speed in bytes per second.
Command-line option innodb-scrub-force-testing was renamed to innodb-debug-force-scrubbing.
Consistent support for IF EXISTS, IF NOT EXISTS, and OR REPLACE clauses was added to:
and ()
New status variables to show the number of grants on different objects (see ).
New server variable
xid cache scalability was significantly improved (by using lock-free hash)
definitions are now cached in memory (in the table definition cache).
New status variables to track MASTER_GTID_WAIT time. This feature was contributed by Daniel Black. See .
New status variable . This feature was contributed by Daniel Black.
Starting with this release, commits in certain instances in parallel replication complete immediately, avoiding losing throughput when many transactions need conflicting locks. See .
can now analyze leaf pages to estimate how fragmented an index is and how much benefit can be gained from defragmentation.
Fixes for the following :
CVE-`-```
Repositories exist for 10.1, but because 10.1 is still Beta, they are not visible in the repository configuration tool. To configure a 10.1 apt, yum, or zypper repository using the tool, simply select 10.0 and then when executing the instructions, manually change all occurrences of '10.0' to '10.1'.
For a complete list of changes made in MariaDB 10.1.4, with links to detailed
information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This is the second alpha release in the MariaDB 10.1 series.
Notable changes of this release include:
for row-based events.
allow roles to be enabled automatically when a user connects.
InnoDB: merged the Facebook/Kakao defragmentation patch (see ) which uses to defragment InnoDB tablespaces).
tables no longer use .frm files.
is merged into MariaDB server, binaries automatically support Galera out of the box.
InnoDB: report progress of inplace alter table (Kakao patch).
can now be aborted.
statement now supports out parameters.
.
The has been deprecated. Engine condition pushdown is now always enabled for all engines that support it.
New Information Schema table shows for every system variable its session and global variable values as well as various metadata.
. New statements in this release:
Two new columns added to the and Information Schema tables (TOTAL_SSL_CONNECTIONS and MAX_STATEMENT_TIME_EXCEEDED).
MariaDB can execute without a temporary table. (MySQL 5.7 patch)
@@sql_log_slow is now a session variable, not global.
Merge with
As per the , this will be the last release of for both Ubuntu 13.10 "Saucy" and Mint 16 "Petra".
With the recent release of CentOS 7 and RHEL 7, we are pleased to now provide packages for both distributions. Instructions for how to enable the repositories can be found by visiting the "" page and the .
Do not use alpha releases on production systems!
For a complete list of changes made in MariaDB 10.1.1, with links to detailed
information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the current development series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
option to use the MySQL-5.6 low level formats to store , and types. ()
Support for Spatial Reference systems for the GIS data (), new REF_SYSTEM_ID column attribute can be used to specify Spatial Reference System ID for columns of spatial data types:
It can be queried via the table.
table.
More functions from the standard added ():
Do not use alpha releases on production systems!
Repositories exist for 10.1, but because 10.1 is still Alpha, they are not visible in the . To configure a 10.1 apt, yum, or zypper repository using the tool, simply select 10.0 and then when executing the instructions, manually change all occurrences of '10.0' to '10.1'.
For a complete list of changes made in , with links to detailed
information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Minimum value of raised to 8 (previously 4)
so fixed size like and are not truncated for lower values of max_sort_length ().
InnoDB
updated to 5.6.49
Fixed corruption in delete buffering ()
Fixed a deadlock in FLUSH TABLES…FOR EXPORT ()
Replication
Make the binlog dump thread to log into errorlog a requested GTID position ()
Fix stop of the optimistic parallel slave at requested START-SLAVE-UNTIL position ()
Properly handle RESET MASTER TO value, when the value exceeds the max allowed 2147483647 ()
Optimizer
ALTER TABLE ... ANALYZE PARTITION ... with EITS reads and locks all rows ... ()
Print ranges in the optimizer trace created for non-indexed columns when optimizer_use_condition_selectivity >2 Now the optimizer trace shows the ranges constructed while getting estimates from EITS ()
LATERAL DERIVED is not clearly visible in
Other
is now taken into account for all intermediate calculations. Previously results could be unpredictable. Note that this means results will have a lower precision in some cases - see ()
updated to 5.6.49-89.0
updated to 5.6.49-89.0
Changelog
For a complete list of changes made in with links to detailed
information on each push, see the .
Contributors
For a full list of contributors to , see the .
A file format compatibility bug that was introduced in was fixed in .
Using or non-default created files that were incompatible with or MySQL 5.6. and higher will convert affected files from earlier releases to a compatible format.This prevents a downgrade to earlierversions.
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the current development series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
MariaDB can now also encrypt (including relay
logs). To enable binary logs make sure
that an encryption plugin is loaded and add encrypt-binlog to
your my.cnf file.
The
variable no longer affects the replication of events in a
Variable name
Old value
New value
One can now explicitly request MariaDB to select a good value for certain
command-line options by using the --autoset prefix. For example,
in my.cnf:
At the moment only the and options support this prefix.
Fixes for the following :
CVE-`-```
For a complete list of changes made in , with links to detailed
information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the current development series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
, Allow > 16K pages on InnoDB - InnoDB now allows to be configured as 16K, 32K and 64K. Note that single row size must be < 16K. This feature will allow especially more blob columns to be created.
, Force PK option - Added a new dynamic configuration variable default off. If option is true, create table without primary key or unique key where all keyparts are NOT NULL is not accepted. Instead an error message is printed. Variable value can be changed with set global innodb_force_primary_key = .
Do not use alpha releases on production systems!
For a complete list of changes made in , with links to detailed
information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the current stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
For a complete overview ofMariaDB 10.1see thepage.
Thanks, and enjoy MariaDB!
Notable Changes
updated to 3.2.37
new variable,
: now supports --persistent option, when used
together with --analyze
This release includes all bug fixes from , , and
releases.
SLES 11 Support
Previous builds of for Suse Linux Enterprise Server (SLES) 11 only
supported SLES 11 SP3 and SP4. Starting with this release, SLES 11 builds for
x86_64 also support SLES 11 SP1 and SP2.
Deprecated Distributions
As per the , this will be the
last release of for Fedora 21.
Changelog
For a complete list of changes made in , with links to detailed
information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the previous stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
mariadb-backup --apply-log-only crashes if incomplete transactions with update_undo logs are present
Fix backup for Innodb tables with DATA DIRECTORY
mariadb-backup --copy-back: Copy all undo tablespace files
InnoDB/XtraDB
ALTER TABLE…DISCARD TABLESPACE takes a lot of time
Allow online table rebuild when encryption or compression parameters change
'Undo log record is too big.' error occurring in very narrow range of string lengths
General
updated to 7.07.
Security Fixes
Fixes for the following :
,
Notes
For a complete list of changes made in , with links to detailed
information on each push, see the .
A file format compatibility bug that was introduced in was fixed in .
Using or non-default created files that were incompatible with or MySQL 5.6. and higher will convert affected files from earlier releases to a compatible format.This prevents a downgrade to earlierversions.
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 10.1.3 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 2 Mar 2015
is the current development series of MariaDB. It is an evolution
of with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
is a release. One should not expect any notable new features or incompatible interface changes in 10.1 after this release.
password validation plugin. It can enforce a minimum password length and guarantee that a password contains at least a specified number of uppercase and lowercase letters, digits, and punctuation characters.
password validation plugin. It only allows passwords that are strong enough to pass CrackLib test. This is the same test that pam_cracklib.so does, installed by default on many Linux distributions.
The number of rows affected by a slow UPDATE or DELETE is now recorded in the - see also . (MDEV-4412)
now supports microseconds in the timeout, no longer rounding fractions to the nearest integer (MDEV-4018)
domain_id based replication filters - see (MDEV-6593)
Two new Information Schema tables for examining wsrep information, and (MDEV-7053)
MDEV-5730, enhance security using special compilation options - MariaDB is now compiled with security hardening options by default. It
is an additional protection layer that makes new, yet unknown, security
vulnerabilities more difficult to exploit.
Storage Engine functionality
MDEV-6107, merge default_tmp_storage_engine - Added server variable and the command line
option.
MDEV-4260, Don't create frm files for temporary tables - Temporary tables no longer create frm files on disk. Which means that if the temporary table is created in the engine, it will not touch the disk at all.
The storage engine is no longer enabled by default, and the plugin needs to be specifically enabled.
The storage engine is no longer enabled by default, and the plugin needs to be specifically enabled.
Optimizer
MDEV-406, - Check how close the optimizer's estimates about the query plan are to the reality.
Administration
MDEV-6248, GUI-friendly cmake options to enable/disable plugins - MariaDB now uses PLUGIN_xxx cmake options to enable or disable plugins, not a combination of WITH_xxx, WITHOUT_xxx, WITH_PLUGINX_xxx, WITHOUT_PLUGIN_xxx, WITH_xxx_STORAGE_ENGINE, WITHOUT_xxx_STORAGE_ENGINE. See .
Improvements from WebScaleSQL
Fix errors detected by ASan at compile time - Not merged but ASan was run against MariaDB. It generated the following:
MDEV-6314 - Compile/run MariaDB with ASan (fixed in 10.0.13)
- TokuDB: ERROR: AddressSanitizer: attempting to call malloc_usable_size() for pointer which is not owned: 0x601200008f80 (not fixed)
- ‘explain_node’ may be used uninitialized in this function (not fixed)
- TokuDB: hatoku_hton.cc:1021:5: warning: ‘do_commit’ may be used uninitialized in this function (not fixed)
, Fix errors detected by ASan at runtime. Merged to 5.5.39.
Use single quotes for perl paths, in case of special symbols. Merged to 10.0.13.
Stop spawning dummy threads on client library initialization. Merged to 10.0.13.
: : Fixed incorrect implementation of the --ssl-verify-server-cert
option that allowed a malicious attacker (with a capability to perform a
man-in-the-middle attack) to replace the server SSL certificate, bypassing
the client-side hostname verification. This vulnerability was discovered by
Paul Kehrer and Alex Gaynor.
This is the first beta release in the MariaDB 10.1 series. One should not expect any notable new features or incompatible interface changes in 10.1 after this release.
Major new features
.
(MDEV-6676) and two new associated system variables:
Enhanced semisync replication ()
Other notable changes
Consistent support for IF EXISTS, IF NOT EXISTS, and OR REPLACE clauses:
These statements now also support IF NOT EXISTS and OR REPLACE:
()
()
()
These statements now support IF EXISTS:
()
()
Dump Thread Enhancements from Google ()
The system variable for permitting dirty reads.
new read-only server variable that shows the version of currently used SSL library.
new command-line option that makes it possible to disable historical "unambiguous prefix" matching in the command-line option parsing.
table has a new IS_DEFAULT column (). See .
table has a new ALGORITHM column ().
Improved concurrency: table definition cache now has lock-free implementation completely avoiding any global locks.
now supports and prints more optimizations (range+MRR, "range checked for each record", full scan on NULL key, expensive constants, etc)
Do not use beta releases on production systems!
Repositories exist for 10.1, but because 10.1 is still Beta, they are not visible in the repository configuration tool. To configure a 10.1 apt, yum, or zypper repository using the tool, simply select 10.0 and then when executing the instructions, manually change all occurrences of '10.0' to '10.1'.
For a complete list of changes made in MariaDB 10.1.3, with links to detailed
information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the current stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Updating from to or higher is highly recommended due to two high-priority regression fixes. See and for details.
: Fixed some race conditions in InnoDB encryption
alpha introduced, see for more information
updated to 25.3.20
A file format compatibility bug that was introduced in was fixed in .
Using or non-default created files that were incompatible with or MySQL 5.6. and higher will convert affected files from earlier releases to a compatible format.This prevents a downgrade to earlierversions.
Changelog
For a complete list of changes made in , with links to detailed
information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
The following lists the major new features in MariaDB 10.1:
Implemented Features
Galera
, a true multi-master solution, is a standard part of .
Two new Information Schema tables for examining wsrep information, and ()
Encryption
.
Page Compression
Page compression for .
Replication
()
domain_id based replication filters - see ()
Enhanced semisync replication; Wait for at least one slave to acknowledge transaction before committing ().
Roles
().
New columns for the table.
Optimization
by several fixes for real-world cases.
Don't create frm files for temporary tables ().
can be used to automatically abort long running queries. ().
GIS
Support for Spatial Reference systems for the GIS data (), new REF_SYSTEM_ID column attribute can be used to specify Spatial Reference System ID for columns of spatial data types:
More functions from the standard added ():
Syntax
Consistent support for IF EXISTS, IF NOT EXISTS, and OR REPLACE clauses:
()
XtraDB / InnoDB
Allow up to 64K pages in InnoDB (old limit was 16K) ().
The Facebook/Kakao defragmentation patch (see ) which uses to defragment InnoDB tablespaces).
Collations
Added the utf8_thai_520_w2, utf8mb4_thai_520_w2, ucs2_thai_520_w2, utf16_thai_520_w2 and utf32_thai_520_w2 .
Variables
For a list of all new variables, see and . Some of these, and other variable-related changes, include:
gives information, like description and value origin, for system variables ().
New server variable
New status variables to show the number of grants on different objects (see )
Plugins
().
password validation plugin. It can enforce a minimum password length and guarantee that a password contains at least a specified number of uppercase and lowercase letters, digits, and punctuation characters.
password validation plugin. It only allows passwords that are strong enough to pass test. This is the same test that pam_cracklib.so does, installed by default on many Linux distributions.
Security
Enhance security using special compilation options - MariaDB is now compiled with security hardening options by default. It is an additional protection layer that makes new, yet unknown, security vulnerabilities more difficult to exploit. ()
Security Vulnerabilities Fixed in
For a complete list of security vulnerabilities (CVEs) fixed across all
versions of MariaDB, see the
page.
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
for row-based events.
Dump Thread Enhancements from Google. Makes multiple slave setups faster by allowing concurrent reading of binary log. (MDEV-7257)
Commits in certain instances in parallel replication complete immediately, avoiding losing throughput when many transactions need conflicting locks. See .
is extended with TO # which allows one to specify the number of the first binary log. (MDEV-8469)
Due to the implementation of SQL standards-compliant behavior when dealing with , in certain edge cases, there may be replication issues when replicating from a MariaDB 10.0 master to a MariaDB 10.1 slave using . See MDEV-12248.
works without usage of a temporary table (MDEV-334). The feature was backported from MySQL 5.7
Scalability fixes (MDEV-7004). Up to 60% higher throughput in sysbench benchmarks on Power8.
Make simple queries faster as we call malloc() fewer times.
Automatic discovery of tables (simpler mysql_install_db code). (MDEV-4262), tables no longer use .frm files.
provides output that looks like EXPLAIN output, but also includes data from the query execution (how many rows were actually read, etc).
is a re-implementation of similar feature in MySQL 5.6
produces detailed information about the statement execution
now supports microseconds in the timeout, no longer rounding fractions to the nearest integer (MDEV-4018)
.
The number of rows affected by a slow UPDATE or DELETE is now recorded in the - see also . (MDEV-4412)
SQL standards-compliant behavior when dealing with . Note that this could cause replication issues in certain edge cases when replicating from a MariaDB 10.0 master to a MariaDB 10.1 slave. using . See MDEV-12248.
Explicit or implicit casts from MAX(string) to INT, DOUBLE or DECIMAL now produce warnings (MDEV-8852).
Default size of changed from 8192 to 16384 and from 8192 to 24576 to avoid the need for simple queries with one join to call my_malloc.
- set variables for the duration of the query (MDEV-5231). This is a backport of Per-query Variable Statement feature of Percona Server 5.6 (which, in turn, is based in MySQL GSoC 2009 project by Joseph Lukas), with many bugs fixed.
option to use the MySQL-5.6 low level formats to store , and types. (MDEV-5528)
MariaDB 10.1 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Starting with this release, we are now providing for
updated to 5.6.44
updated to 8.43
Changelog
For a complete list of changes made in , with links to detailed
information on each push, see the .
Contributors
For a full list of contributors to , see the .
A file format compatibility bug that was introduced in was fixed in .
Using or non-default created files that were incompatible with or MySQL 5.6. and higher will convert affected files from earlier releases to a compatible format.This prevents a downgrade to earlierversions.
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
updated to 5.6.43-84.3
updated to 5.6.43-84.3
- Add option to PAM authentication plugin to allow case insensitive username matching
- InnoDB fails to rollback after exceeding FOREIGN KEY recursion depth
- Data corruption will happen on the Galera cluster size change
- Merge InnoDB and XtraDB changes from MySQL 5.6.44
As per the , this will be
the last release of for Ubuntu 14.04 Trusty
MariaDB 10.1 is the current stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
For a complete overview ofMariaDB 10.1see thepage.
Thanks, and enjoy MariaDB!
Notable Changes
New authentication plugin for clients connecting on Windows using .
New .
has been updated from 25.3.9 to 25.3.12.
This release includes all bug fixes from , , and
releases.
Deprecated Distributions
As per the , this will be the
last release of for Ubuntu 15.04 "Vivid".
Changelog
For a complete list of changes made in , with links to detailed
information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the current stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
A repository for the newly-released Ubuntu 16.04 "xenial" has been added.
Currently the repository is using packages built on Ubuntu 15.10 "wily", but in
the next release they will be built on xenial builders.
- APT 1.2.7 (and later) prefers SHA2 GPG keys and now prints warnings when a repository is signed using a SHA1 key. We have created a new SHA2 key for use with our Ubuntu 16.04 "xenial" repository.
The Key ID is: C74CD1D8
The full fingerprint of the new key is: 177F 4010 FE56 CA33 3630 0305 F165 6F24 C74C D1D8
The instructions in the
for Ubuntu 16.04 "xenial" have been updated to refer to this new key.
Repositories for previous versions of Ubuntu will continue to use the old key.
Changelog
For a complete list of changes made in , with links to detailed
information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.1 is the current stable series of MariaDB. It is an evolution
of MariaDB 10.0 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
For a complete list of changes made in , with links to detailed
information on each push, see the .
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This page is licensed: CC BY-SA / Gnu FDL
The limit for the system variable has been increased to 1024K
updated to 25.3.19
packages for Debian 9 "stretch" amd64 and Debian 8 "jessie" ppc64el added