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.
: 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.44 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 28 Jan 2020
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.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
MariaDB 10.1.48 Release Notes
| | |
Release date: 3 Nov 2020
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.
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.
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.
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 MDEV-20987 for more details.Do not download or use this release.
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 thepage.
Thanks, and enjoy MariaDB!
Notable Changes
: Improved innochecksum error messages
: Replication hangs with "preparing" and never starts
FULLTEXT INDEX:
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.
: InnoDB should use case-insensitive column name comparisons like the rest of the server
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.39 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 2 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.
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). Setting the
variable to strict can cause more certification failures.
Debian has stopped supporting the ppc64el architecture for Debian 8
Jessie and so this is the last release of MariaDB 10.1 on Jessie for that
architecture
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.
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 EXPLAIN FORMAT=JSON
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 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 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.
Update InnoDB/XtraDB from MySQL 5.6.45 and Percona Server 5.6.44-86.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.
This page is licensed: CC BY-SA / Gnu FDL
InnoDB data file extension is not crash-safe (MDEV-23190)
Minor fixes related to encryption and FULLTEXT INDEX
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.
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 XtraDB-5.6.28-76.1
updated to InnoDB-5.6.29
updated to 5.6.29
This release includes all bug fixes from , , and
releases.
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.
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.36 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 8 Sep 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.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.34 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 18 Jun 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.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.6 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 27 Jul 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.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.
is a release.
For an overview ofsee the
MariaDB 10.1.11 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 29 Jan 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.
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.
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.
is extended with TO # clause which allows one to specify the number of the first binary log. (MDEV-8469)
New system variables , and .
New system variable for determining how often the buffer pool dump status should be printed in the logs.
was enabled and updated to 5.04 (earlier versions of Mroonga did not work in 10.1).
Added support for for compatibility with MySQL.
New status variables and for tracking the number of CREATE/DROP TEMPORARY TABLE statements.
Fixes for the following :
CVE-`-```
For a complete list of changes made in MariaDB 10.1.6, 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.
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.
For a complete list of changes made in MariaDB 10.1.11, 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.
: 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 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.
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 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 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.
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 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 release notes here only document changes from the previous version ofMariaDB 10.1. For a complete overview ofsee thepage.
Thanks, and enjoy MariaDB!
Notable Changes
updated to XtraDB-5.6.26-74.0
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
().
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.
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 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.
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 10.1.7 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 9 Sep 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 (RC) release.
For an overview of
MariaDB 10.1.13 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 25 Mar 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 an overview ofsee the
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.
is a release.
For a complete overview ofsee the
MariaDB 10.1.32 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 27 Mar 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.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.24 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 31 May 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.10 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 24 Dec 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.
For a complete overview ofsee the
Bug #27326796 - MYSQL CRASH WITH INNODB ASSERTION FAILURE IN FILE PARS0PARS.CC
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.
--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 (MDEV-8852).
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 Galera
cluster.
SQL standards-compliant behavior when dealing with .
Default values of server variables were changed as follows:
Variable name
Old value
New value
128K
256K
1M
4M
0
1M
ON
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:
For a complete list of changes made in MariaDB 10.1.7, 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 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.
MDEV-9781 - 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 key can be added using the following command:
The instructions in the repository configuration tool
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 MariaDB 10.1.13, 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.
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.
: information schema - errors populating fail to free memory, unlock mutexes
: support for streaming in tar format in has been removed
: Fixes from coverity report on MariaDB
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 .)
For a complete list of changes made in MariaDB 10.1.24, 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.
Previous builds of MariaDB 10.1 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.
For a complete list of changes made in MariaDB 10.1.10, 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.
The embedded server library now supports SSL when connecting to remote servers.
ALTER TABLE fixes: , ,
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.
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 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.
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 roles to be enabled automatically when a user connects.
InnoDB: merged the Facebook/Kakao defragmentation patch (see ) which uses to defragment InnoDB tablespaces).
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 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 .
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.
CVE-2016-2047: MDEV-9212: 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.
In this release experimental Ubuntu 18.04 "bionic" packages are present in the MariaDB 10.1 repository. However, because Ubuntu includes MariaDB 10.1 in its main repositories we recommend using the Ubuntu provided MariaDB 10.1 packages for general use.
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.
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 repository configuration tool.
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.
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.
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)
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.
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.