MariaDB 10.2 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.1 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all users due to bug which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from or earlier to or higher,
running is required due to changes introduced in .
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 .
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.2 is the current stable series of MariaDB. It is an evolution
of MariaDB 10.1 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
Release Notes - MariaDB 10.2 Series
MariaDB 10.2 was a short-term maintenance series of MariaDB maintained until November 2023
MDEV-21024: Remove redundant writes to the redo log
MDEV-21069: Crash on DROP TABLE if the data file is corrupted
MariaDB 10.2 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.1 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
This release fixes a blocking problem with the release when manually running . ()
See for other changes since the previous release.
Security
Fixes for the following :
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all users due to bug which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from or earlier to or higher,
running is required due to changes introduced in .
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 .
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.2.0 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 18 Apr 2016
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.
This is the first alpha release in the MariaDB 10.2 series.
Notable changes of this release include:
Syntax:
have been introduced. This release adds support for a limited set of functions, and the basic execution algorithm. Development continues to expand the set of supported functions and optimize the execution.
The statement was introduced.
New options for limiting resource usage and tls/ssl.
New statement.
New : OVER and RECURSIVE. These can no longer be used as without being quoted.
Scripts:
Continuous binary log backup has been added to - MDEV-8713.
The server version can now be faked to work around dated applications that require a particular version string - MDEV-7780
is now an alias for slave_parallel_threads.
New status variables , and .
EXPLAIN:
now shows outer_ref_condition field which contains the condition that the(?) SELECT checks on each re-execution - MDEV-9652.
now shows sort_key field which shows the sort criteria used by filesort operation. (commit 2078392)
EXPLAIN used to show incorrect information about how the optimizer resolved ORDER BY clause or Distinct. This is a long-standing problem coming from MySQL. Now, after and related fixes, the problem doesn't exist anymore. (For testcases, see , , )
Optimizations:
Connection setup was made faster by moving creation of THD to new thread (MDEV-6150)
Code:
"fast mutexes" have been removed. These aren't faster than normal mutexes, and have been disabled by default for years - MDEV-8111.
Notes
Do not use alpha releases on production systems!
Repositories exist for 10.2, but because 10.2 is still alpha, it is not
visible in the repository configuration tool.
To configure a 10.2 apt, yum, or zypper repository using the tool, simply
select 10.1 and then when executing the instructions, change all occurrences of
'10.1' to '10.2'.
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 Debian "sid" repository. When we add an Ubuntu 16.04 "xenial" repository, it will also use this new 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:
Changelog
For a complete list of changes made in MariaDB 10.2.0, 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 Distributions which Include MariaDB page.
MariaDB 10.2 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.1 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all users due to bug which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from or earlier to or higher,
running is required due to changes introduced in .
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 .
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.2.44 Release Notes
| | |
Release date: 20 May 2022
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!
MariaDB 10.2.42 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 9 Feb 2022
This release is no longer available for download after a problem was noticed when manually running mariadb-upgrade. See for more details.Please use a later 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.
MariaDB 10.2.29 Release Notes
The most recent release of is: Stable (GA)
Note that this version contains an issue that disabled all events created by a server with a different server_id. See for details.
| | |
Release date: 8 Nov 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.
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all Galera users due to bug MDEV-12837 which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher,
running is required due to changes introduced in MDEV-14637.
Changelog
For a complete list of changes made in MariaDB 10.2.44 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 Distributions which Include MariaDB page.
script updated to version 2022-02-08, with the following fixes and enhancements:
Default location of the script has been moved to: mariadb_repo_setup (old location is deprecated, but still works)
The GPG keyring file, used with Debian and Ubuntu repositories, has moved to: and the checksum for the file can be found at:
Support for RHEL and SLES aarch64 repositories added
New function added to verify that the MariaDB Server version, if specified on the command line, follows the correct naming and that a corresponding repository actually exists.
Fixed repository pinning for Ubuntu and Debian repositories
MariaDB Server 10.7 is now the default server version
Docker Library
Faster initialization by disabling binary logging during initialization (MDEV-27074)
mysql_upgrade can be run if needed using the environment variable MARIADB_AUTO_UPGRADE=1 (MDEV-25670)
A healthcheck script /usr/local/bin/healthcheck.sh is installed in the container with various checking options (MDEV-25434)
mysql@localhost user is created with the environment variable MARIADB_MYSQL_LOCALHOST_USER=1 and additional grants (beyond USAGE) with MARIADB_MYSQL_LOCALHOST_GRANTS={global grant list} ()
skip innodb buffer pool loads/dumps on temporary startup/shutdown for faster startup/initialization, and accurate "healthcheck.sh --innodb_buffer_pool_loaded"
change group ownership on datadir/socket dir ()
log note about note on Securing system users, mysql_secure_installation not required ()
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all Galera users due to bug MDEV-12837 which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher,
running is required due to changes introduced in MDEV-14637.
Changelog
For a complete list of changes made in MariaDB 10.2.42 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 Distributions which Include MariaDB page.
MDEV-20987: InnoDB fails to start when FTS table has FK relation
See also the release notes for MariaDB 10.2.28 for additional items of note
Fixes for the following :
CVE-`-```
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all Galera users due to bug MDEV-12837 which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher,
running is required due to changes introduced in MDEV-14637.
Changelog
For a complete list of changes made in MariaDB 10.2.29 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 Distributions which Include MariaDB page.
MariaDB 10.2 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.1 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Fix for WSREP: invalid state ROLLED_BACK (FATAL) ()
InnoDB
ALTER TABLE…IMPORT TABLESPACE fixes (, )
innodb_undo_log_truncate fixes (, )
Replication
Memory hogging on slave by ROW event applier is eliminated ()
mysql --binary-mode now properly handles \\0 in data ()
Missed statement rollback in case transaction drops or create temporary table is corrected ()
Packaging & Misc
Session tracking flag in OK_PACKET ()
Some views force server (and mysqldump) to generate invalid SQL for their definitions ()
Security
Fixes for the following :
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all users due to bug which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from or earlier to or higher,
running is required due to changes introduced in .
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 .
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.2 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.1 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Follow up to to alter protocol checks to support the following implementations (which add garbage to the end of some packets):
PHP PDO (all versions) ()
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all users due to bug which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from or earlier to or higher,
running is required due to changes introduced in .
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 .
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.2 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.1 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
: A race condition in InnoDB transaction commit that affects record locking was fixed
: Table doesn't exist in engine after ALTER of FOREIGN KEY
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all users due to bug which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from or earlier to or higher,
running is required due to changes introduced in .
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 .
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.2 is the previous stable series of MariaDB. It is an evolution
of MariaDB 10.1 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information.
Thanks, and enjoy MariaDB!
Notable Changes
updated to 9.5
Backport .
: Maximum value of is now 2097152.
When upgrading from or earlier to or higher,
running is required due to changes introduced in.
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 .
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.2 is the previous stable series of MariaDB. It is an evolution
of MariaDB 10.1 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information.
Thanks, and enjoy MariaDB!
Notable Changes
- Stack-buffer-overflow with indexed varchar (utf8) field
- possible in read-only mode (forbid ALTER DATABASE in read_only)
- does not handle
When upgrading from or earlier to or higher,
running is required due to changes introduced in.
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 .
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.2 is the previous stable series of MariaDB. It is an evolution
of MariaDB 10.1 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information.
Thanks, and enjoy MariaDB!
Notable Changes
Data type validation:
: ALTER TABLE is not enforcing prefix index size limit
When upgrading from or earlier to or higher,
running is required due to changes introduced in.
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 .
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.2 is the previous stable series of MariaDB. It is an evolution
of MariaDB 10.1 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information.
Thanks, and enjoy MariaDB!
Notable Changes
is now
: now supports MyRocks
- InnoDB fails to shut down purge workers, causing hang
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 .
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.2 is the current stable series of MariaDB. It is an evolution
of MariaDB 10.1 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information.
Thanks, and enjoy MariaDB!
Notable Changes
is now
- Added the , for monitoring disk space
- does not work properly when used with DATA DIRECTORY.
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 .
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.2 is the current stable series of MariaDB. It is an evolution
of MariaDB 10.1 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information.
Thanks, and enjoy MariaDB!
Notable Changes
- WSREP: BF lock wait long
- After UPDATE of indexed columns, old values will not be purged from secondary indexes
- Assertion failure when reporting duplicate key error in online table rebuild
Updates
The WINDOW is now only disallowed for table aliases.
Fixes for the following :
Notes
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.2.40 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 6 Aug 2021
Warning: This version can cause InnoDB file corruption on FreeBSD and on AIX. Stick to an earlier release, or upgrade to a more recent release, if you are running either of these environments. See .
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.
MariaDB 10.2.39 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 23 Jun 2021
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.
MariaDB 10.2.37 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 22 Feb 2021
Last month long-time MariaDB VP of Engineering, Rasmus Johansson, passed due to complications from cancer. His loss has been felt keenly by the whole MariaDB team. Our thoughts are with his family during this difficult time and this release is dedicated to his memory.
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.
MariaDB 10.2.31 Release Notes
The most recent release of is: Stable (GA)
Note that this version contains an issue that disabled all events created by a server with a different server_id. See for details.
| | |
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.
MariaDB 10.2.28 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: 5 Nov 2019
MariaDB 10.2.25 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 17 Jun 2019
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 thepage.
MariaDB 10.2.18 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 25 Sep 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 thepage.
MariaDB 10.2.17 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 14 Aug 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 thepage.
MariaDB 10.2.13 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 13 Feb 2018
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 thepage.
MariaDB 10.2.11 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 28 Nov 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 thepage.
MariaDB 10.2.5 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 5 Apr 2017
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 ofsee thepage.
MariaDB 10.2.7 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 12 Jul 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 thepage.
MariaDB 10.2.8 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 18 Aug 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 thepage.
MariaDB 10.2.3 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 24 Dec 2016
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.
Do not use beta releases on production systems!
MariaDB 10.2.1 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 4 Jul 2016
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.
Fixes for regressions introduced in MariaDB Server 10.2.19 by the backup-safe TRUNCATE TABLE (MDEV-13564, innodb_safe_truncate=ON) and innodb_undo_log_truncate:
A query that uses ORDER BY .. LIMIT clause and "Range checked for
each record optimization" could produce incorrect results under some
circumstances (MDEV-25858)
Queries that have more than 32 equality conditions
comparing columns of different tables ("tableX.colX=tableY.colY) could cause
a stack overrun in the query optimizer (MDEV-17783, MDEV-23937)
"Condition pushdown into derived table" optimization cannot be
applied if the expression being pushed refers to a derived table column which
is computed from expression that has a stored function call, @session variable
reference, or other similar construct.
The fix for MDEV-25969 makes it so that only the problematic part of the
condition is not pushed. The rest of the condition is now pushed. (MDEV-25969)
A query with window function on the left side of the subquery could
cause a crash. ()
Wrong result selecting from simple view with LIMIT and ORDER BY
Queries with views/derived table/CTEs that have this form: "(SELECT ... LIMIT )
ORDER BY ...>" could produce wrong results ()
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all Galera users due to bug MDEV-12837 which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher,
running is required due to changes introduced in MDEV-14637.
Changelog
For a complete list of changes made in MariaDB 10.2.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 Distributions which Include MariaDB page.
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all Galera users due to bug MDEV-12837 which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher,
running is required due to changes introduced in MDEV-14637.
MongoDB protocol support files for the engine are missing in this release.
If you want to use engine with MongoDB, you need to download Mongo2.jar or Mongo3.jar and put a path to this file into the connect_class_path in the my.cnf.
Changelog
For a complete list of changes made in MariaDB 10.2.39 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 Distributions which Include MariaDB page.
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all Galera users due to bug MDEV-12837 which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher,
running is required due to changes introduced in MDEV-14637.
Changelog
For a complete list of changes made in MariaDB 10.2.37 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 Distributions which Include MariaDB page.
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all Galera users due to bug MDEV-12837 which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher,
running is required due to changes introduced in MDEV-14637.
Changelog
For a complete list of changes made in MariaDB 10.2.31 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 Distributions which Include MariaDB page.
MariaDB 10.2 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.1 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
MDEV-20864: Debug-only option for dumping the contents of the InnoDB change buffer to the server error log at startup.
mariadb-backup:
MDEV-18438: mbstream recreates xtrabackup_info on same directory as backup file
: mariadb-backup creates binlog files in server binlog directory on --prepare --export step
FULLTEXT INDEX:
: Server hangs after dropping full text indexes and restart
: InnoDB hang on DROP FULLTEXT INDEX
: Duplicate key with auto increment
ALTER TABLE:
: DROP Virtual Column crash
: BtrBulk is unnecessarily holding dict_index_t::lock
updated to 25.3.28
Fixes for the following :
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all Galera users due to bug MDEV-12837 which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher,
running is required due to changes introduced in MDEV-14637.
Changelog
For a complete list of changes made in MariaDB 10.2.28 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 Distributions which Include MariaDB page.
Upgrading from earlier 10.2.x versions is highly recommended for allGalera users due to bug MDEV-12837 which caused serious stability issues
with earlier versions. See the bug issue page for more information.
MDEV-19490: show tables fails when selecting the information_schema database
MDEV-19491: multi-update with triggers and stored routines
: InnoDB skips the tablespace in rotation list
: SET GLOBAL innodb_ deadlock due to LOCK_global_system_variables
: Malicious SUPER user can possibly change audit log configuration without leaving traces
: Wrong results from query, using left join
: RIGHT JOIN hangs in MariaDB
ALTER TABLE fixes: ,
FULLTEXT INDEX fixes: ,
Virtual columns: , ,
Crash recovery fixes: , , ,
: Fixed row-based event applying with an error anymore when the events aim at the blackhole engine and row annotation is enabled
: Fixed slave_parallel_mode=optimistic did not always properly order replication events on temporary tables in some case to attempt execution before a parent event has been already processed
: Fixed duplicated entries in binlog occurred in combination of LOCK TABLES and binlog_format=MIXED when a being locked table was under replication unsafe operation
As per the , this will be the last release of for OpenSUSE 42.3
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 Distributions which Include MariaDB page.
Upgrading from earlier 10.2.x versions earlier than 10.2.17 is highly recommended for all Galera users due to bug MDEV-12837 which caused serious stability issues with earlier versions. See the bug issue page for more information.
Thanks, and enjoy MariaDB!
Notable Changes
MDEV-15511 - if available, stunnel can be used during
MDEV-15088 - Remove debuginfo files from Windows .zip files and put in optional supplemental .zip file
- add new system variable to speed up queries that new long nested IN lists. The default value, for backward compatibility, is 0 meaning "unlimited"./25.
The in the repositories has been updated to version 25.3.24.
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 Distributions which Include MariaDB page.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug MDEV-12837 which caused serious stability issues with earlier versions. See the bug issue page for more information.
Thanks, and enjoy MariaDB!
Notable Changes
New variable for avoiding delay due to page flushing and allowing concurrent backup
New variable, for specifying whether to write a core file on crash.
updated to 5.7.23
ALTER TABLE fixes:
- Fix hang due to DDL with FOREIGN KEY or persistent statistics
- Alter InnoDB Partitioned Table Moves Files (which were originally not in the datadir) to the datadir
- InnoDB: Failing assertion: ++retries < 10000 in file dict0dict.cc line 2737
Temporary tables: - InnoDB hang with repeating log entry
- Windows - redo log does not work on native 4K sector disks
indexed virtual columns: - Deadlock between purge thread and DDL statement
locking: - Change the default to innodb_lock_schedule_algorithm=fcfs
Galera: - WSREP: BF lock wait long for trx
Packages and a repository for openSUSE 15 have been added with this release, visit the for instructions on adding the repository
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 Distributions which Include MariaDB page.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug MDEV-12837 which caused serious stability issues with earlier versions. See the bug issue page for more information.
For a complete list of changes made in MariaDB 10.2.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 Distributions which Include MariaDB page.
MDEV-14499 mariadb-backup 10.2 fails to back up a multi-file InnoDB system tablespace
MDEV-14447 mariadb-backup incremental incorrectly extends system tablespace for multi-file innodb_data_file_path
MDEV-13560 Copy all innodb undo tablespaces from the backup directory to destination
Other
updated to 7.07.
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for RHEL 7.2 and CentOS 7.2. Starting with the next 10.2 release we will be building MariaDB for CentOS 7 and RHEL 7 on version 7.3.
For a complete list of changes made in MariaDB 10.2.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 Distributions which Include MariaDB page.
: Fix a 10.1.21 regression with failed INSERT, BEFORE INSERT triggers, and columns with no default value
: Fix a 10.1.21 regression in the InnoDB data file extension code
: better InnoDB crash recovery progress reporting
: improvements to how InnoDB data files are extended
Improvements to InnoDB startup/shutdown to make it more robust
: compatible bintar files now available
: alpha storage engine added
This is an alpha version of this storage engine with limited functionality at this time
Currently, zlib and snappy compression is supported (only zlib on Windows)
added for Windows, CentOS, RHEL, and Fedora packages
: Shutdown fails to wait for rollback of recovered transactions to finish
: Discard temporary undo logs at transaction commit
: compatibility fix for upgrading from 5.5 or 10.x
: Two new columns added to the table, providing information about columns.
Fixes for the following :
Notes
For a complete list of changes made in MariaDB 10.2.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 Distributions which Include MariaDB page.
This is the second stable release in the MariaDB 10.2 series.
A file format compatibility bug that was introduced in MariaDB 10.2.2 was fixed in this version of MariaDB. Creating tables with the attribute created InnoDB internal data dictionary records that are incompatible with MariaDB 10.1. MariaDB 10.2.7 and later will write the dictionary records in a format that is compatible with MariaDB 10.1 and will also support the malformed metadata from affected 10.2 versions.This may prevent a downgrade to earlierMariaDB 10.2versions.See the commit for details.
The (an alias for LONGTEXT) was introduced.
updated to 5.7.18
updated to 5.6.36-82.0
beta now included for Red Hat, CentOS, and Fedora packages. See for an important note about restoring with this version.
: Core dumps can now be enabled dynamically
: Literals in the COLUMN_DEFAULT column in the table are now quoted to distinguish them from expressions.
New variables:
As per the , this will be the last release of for Ubuntu 16.10 "Yakkety"
Fixes for the following :
CVE-`-```
Notes
For a complete list of changes made in MariaDB 10.2.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 Distributions which Include MariaDB page.
Fixed bug that permitted columns being dropped which would result in an additional constraint being added to the table. See the example in ().
Nonsensical combinations of SIGNED, UNSIGNED and ZEROFILL are no longer permitted - see ().
now included for Debian and Ubuntu (in it was released only for Red Hat, CentOS, and Fedora)
Fedora 26 repositories have been added in this release.
As per the , this will be the last release of for Fedora 24.
Fixes for the following :
Notes
For a complete list of changes made in MariaDB 10.2.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 Distributions which Include MariaDB page.
Packages for Debian 9 "stretch" amd64 and x86 and Debian 8 "jessie" ppc64el added
Fix for FULLTEXT index crash ().
Replication
New variable permits restricting the speed at which the slave reads the binlog from the master (MDEV-11064) — Tencent Game DBA Team, developed by chouryzhou.
The FOLLOWS/PRECEDES clauses have been added to the statement.
Multiple triggers are now counted in the Executed_triggers status variable (MDEV-10915).
and now include the date and time the trigger was created.
Fixes for the following :
CVE-`-```
Notes
Do not use beta releases on production systems!
Changelog
For a complete list of changes made in MariaDB 10.2.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 Distributions which Include MariaDB page.
Views now support subqueries in the FROM clause ()
Number of supported decimals in has increased from 30 to 38. ()
Optimizations for faster connection creation time.
New variable for setting a directory for storing temporary non-tablespace InnoDB files, .
Temporary tables can be referred to many times in the same query ()
Various other optimizations and refactorings
updated to 5.6.30-76.3
updated to 5.6.31
updated to 5.6.31
updated to 8.39
updated to 5.6.30-76.3
updated to 9.3
Various packages and bintar builds for POWER8 ppc64 and ppc64le architectures now available
The default value of the system variable is nowCRC32.
As per the , this will be the last release of for Ubuntu 15.10 "wily"
Notes
Do not use Alpha releases on production systems!
Changelog
For a complete list of changes made in MariaDB 10.2.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 Distributions which Include MariaDB page.
MariaDB 10.2 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.1 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
for calculating the spherical distance between two geometries (point or multipoint) on a sphere ()
Crash with invalid multi-table update of view in 2nd execution of SP ()
Incorrect name resolution for subqueries in ON expressions ()
mariadb-backup
RENAME TABLE causes "Ignoring data file" messages ()
InnoDB
MVCC read from index on CHAR or VARCHAR wrongly omits rows ()
Race conditions in persistent statistics (, , )
Galera
updated to 25.3.33
SET PASSWORD command fail with wsrep api ()
Long BF log wait turns on InnoDB Monitor output without telling, never turns it off ()
Replication
Replication Heartbeat event was uncapable to cary 4GB+ offsets ()
FLUSH LOGS race against Binlog checkpoint event creation ()
Audit Plugin
The QUERY_DDL setting now logs CREATE/DROP [PROCEDURE / FUNCTION / USER] statements. See . ()
Packaging & Misc
As per the , this will be the last release of for Ubuntu 16.04 Xenial
Security
Fixes for the following :
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all users due to bug which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from or earlier to or higher,
running is required due to changes introduced in .
MongoDB protocol support files for the engine are missing in this release.
If you want to use engine with MongoDB, you need to download or and put a path to this file into the connect_class_path in the my.cnf.
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 .
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.2 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.1 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Fixed issue that, from , disabled all created by a server with a different server_id. Note that the fix does not re-enable affected events. ()
Other
updated to 11.0 ()
mariadb-backup does not honor ignore_db_dirs from server config ()
mariadb-backup --ftwrl-wait-timeout never times out on explicit lock ()
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all users due to bug which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from or earlier to or higher,
running is required due to changes introduced in .
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 .
Thanks, and enjoy MariaDB!
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.2 is the current stable series of MariaDB. It is an evolution
of MariaDB 10.1 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
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 .
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.2 is the current stable series of MariaDB. It is an evolution
of MariaDB 10.1 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
: Allow ALTER TABLE…ADD SPATIAL INDEX…ALGORITHM=INPLACE
: DELETE with CASCADE takes a long time when Galera is enabled
Backup
--export option implemented for ()
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 ().
Variables
The following variables have been deprecated, and will be removed in a future release ():
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 .
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.2.26 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 thepage.
MariaDB 10.2.4 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 17 Feb 2017
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 ofsee thepage.
MariaDB 10.2.6 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 23 May 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 thepage.
MariaDB 10.2.23 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 25 Mar 2019
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.
will be a release.
For an overview ofsee thepage.
MariaDB 10.2.2 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 27 Sep 2016
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.
Ubuntu 18.04 "bionic" and Fedora 28 packages and repositories are being introduced in this release. See the MariaDB Repository Configuration Tool for instructions on setting up these repositories.
MDEV-17228: Encrypted temporary tables are not encrypted.
: is now stable and requires the .
Merge relevant InnoDB changes from MySQL 5.7.27
: When the ctas from a big table is interrupted ,then you can't drop or recreate the table
: InnoDB's row size calculations were fixed, which might result in "Row size too large" errors when creating or altering tables with lots columns. This can occur even if previous MariaDB releases did not throw errors for the same tables. Some workarounds are listed at .
ALTER TABLE:
Indexed virtual columns: ,
FULLTEXT INDEX:
Encryption: ,
Galera + FOREIGN KEY:
Recovery & mariadb-backup:
: Add page id matching check in innochecksum tool
: DROP TEMPORARY table is logged despite no CREATE was logged
: Basic 3-way join queries are not parsed - parsing problem of joins fixed
: mysql_upgrade_service throws exception upgrading from 10.0 to 10.3
: loading the audit plugin causes performance regression
: REPLACE on table with virtual_field can cause crash
: fix Aria ER_CRASHED_ON_USAGE and Assertion
: Make DISKS plugin check some privilege to access information_schema.DISKS table
As per the , this will be the last release of for Ubuntu 18.10 "Cosmic"
Fixes for the following :
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all Galera users due to bug MDEV-12837 which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher,
running is required due to changes introduced in MDEV-14637.
Changelog
For a complete list of changes made in MariaDB 10.2.26 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 Distributions which Include MariaDB page.
Default value of changed to zlib - this does not mean pages are now compressed by default, see ().
Default value of changed to ON ().
Default value of and changed to ON.
The unused variables have been removed ().
Numerous other system variable changes.
DML_only can rollback instances/databases/tables to an old snapshot ().
Implement and functions so the spatial features can be imported/exported using GeoJSON format ().
for the CONNECT storage engine ().
Persistent for InnoDB ().
Default values of the and system variables changed to BACKUP,QUICK.
Support COM_RESET_CONNECTION ().
can now be set to 1 ().
MariaDB now works when started with a MySQL 5.7.6+ data directory. ()
OpenSUSE 42 repositories have been added in this release.
As per the , this will be the last release of for Ubuntu 12.04 "precise", Fedora 23, and openSUSE 13
New status variables
Fixes for the following :
CVE-`-```
Notes
For a complete list of changes made in MariaDB 10.2.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 Distributions which Include MariaDB page.
This is the first stable release in the MariaDB 10.2 series. As such, please refer to the What is MariaDB 10.2? page for details on all of the new features.
A file format compatibility bug that was introduced in MariaDB 10.2.2 was present in this release.
Creating tables with the attribute created InnoDB internal data dictionary records that are incompatible with MariaDB 10.1. MariaDB 10.2.7 and later will write the dictionary records in a format that is compatible with MariaDB 10.1 and will also support the malformed metadata from affected 10.2 versions.This bug may prevent a downgrade from laterMariaDB 10.2versions toMariaDB 10.2.6.See the commit for details.
Changelog
For a complete list of changes made in MariaDB 10.2.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 Distributions which Include MariaDB page.
Upgrading from earlier 10.2.x versions is highly recommended for allGalera users due to bug MDEV-12837 which caused serious stability issues
with earlier versions. See the bug issue page for more information.
: InnoDB fails to rollback after exceeding FOREIGN KEY recursion depth
: Data corruption on Galera cluster size change
:
: fix incremental MyRocks backup
: mariadb-backup terminated while copying InnoDB redo log
Debug symbols on CentOS 7, RHEL 7, and SLES 12 distributions have been moved
into debuginfo packages ()
The in the repositories has
been updated to version 25.3.26
As per the , this will be
the last release of for Ubuntu 14.04 Trusty,
Debian has also stopped supporting the ppc64el architecture for Debian 8
Jessie and so this is the last release of 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 Distributions which Include MariaDB page.
This is the first beta release in the MariaDB 10.2 series.
was merged from MySQL-5.7.14 (XtraDB is disabled in MariaDB-10.2.2 pending a similar merge)
Note that there have been numerous variable changes, both new variables and changes to defaults, for example now defaults to ON.
InnoDB tables now support .
has been re-implemented so as not to lock the entire table when collecting engine independent statistics ()
The CONNECT engine now supports the ()
Internal CRC32 routines use the optimized implementation on Power8 —
Old GPL client library is gone; now MariaDB Server comes with the LGPL Connector/C client library ()
Recursive Common Table Expressions ()
Further improvements and bugfixing for CHECK CONSTRAINT () and DEFAULT with expressions ()
Optimizer improvement: conditions can be ()
Support for NO PAD , with 88 new NO PAD collations included in the server ()
Table cache can automatically partition itself as needed to reduce the contention ()
The thread pool now gives higher priority to connections that have an active transaction. This can be controlled with the new and system variables. ()
Window functions support extended. All standard aggregate functions (except GROUP_CONCAT) can be used as window functions. ()
New added: , , , , . ()
Performance improvements for faster computing of window functions. Multiple window functions with compatible sorting criteria are computed during the same pass. ()
Default changed from 0 to 1.
New options.
Fixes for the following :
CVE-`-```
Do not use beta releases on production systems!
For a complete list of changes made in MariaDB 10.2.2, 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 Distributions which Include MariaDB page.
MariaDB 10.2 is a previous stable series of MariaDB. It is an evolution
of MariaDB 10.1 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.7.29
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 ()
MariaDB could crash after changing the query_cache size ()
Errors and SIGSEGV on CREATE TABLE w/ various charsets ()
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all users due to bug which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from or earlier to or higher,
running is required due to changes introduced in .
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 .
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.2 is the previous stable series of MariaDB. It is an evolution
of MariaDB 10.1 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Upgrading from earlier 10.2.x versions is highly recommended for allGalera users due to bug which caused serious stability issues
with earlier versions. See the bug issue page for more information.
Thanks, and enjoy MariaDB!
Notable Changes
General server
- Both (WHERE 0.1) and (WHERE NOT 0.1) return empty set
- Unsafe to log updates on tables referenced by foreign keys with triggers in statement format
- Server crashes in Field::set_warning_truncated_wrong_value
InnoDB
Merge InnoDB changes from MySQL 5.6.44 and 5.7.26
InnoDB persistent corruption fixes: , , ,
InnoDB recovery fixes and speedup: , , ,
Encryption
- innodb_encrypt_tables will work even with innodb_encryption_rotate_key_age=0
Protocol
- BULK with replace doesn't take the first parameter in account
Replication
- Slave crashes in show_status_array upon running a trigger with select from I_S
mariadb-backup
- mariadb-backup continues, despite failing to open a tablespace
Packaging & Misc
- mysql_upgrade_service now allows MySQL 5.7 to upgrade
Starting with this release, we are now providing for ()
As per the , this will be the last release of for Fedora 28
Security
- Add option to PAM authentication plugin to allow case insensitive username matching
bugfix - multi-update checked privileges on views incorrectly (commit 5057d4637525eadad438d25ee6a4870a4e6b384c)
- during connect, write error log warning for ER_DBACCESS_DENIED_ERROR, if log_warnings > 1
When upgrading from or earlier to or higher,
running is required due to changes introduced in.
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 .
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.2 is the previous stable series of MariaDB. It is an evolution
of MariaDB 10.1 with several entirely new features not found anywhere else
and with backported and reimplemented features from MySQL 5.6 and 5.7.
Upgrading from earlier 10.2.x versions is highly recommended for all Galera users due to bug which caused serious stability issues with earlier versions. See the bug issue page for more information.
Thanks, and enjoy MariaDB!
Notable Changes
system variable for a backup-safe TRUNCATE TABLE implementation that is based
on RENAME, CREATE, DROP (, , )
Default value for this variable is ON
If you absolutely must use instead of , you can set it to OFF
When upgrading from or earlier to or higher,
running is required due to changes introduced in.
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 .
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.2.35 Release Notes
The most recent release of is: Stable (GA)
| | |
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.
Correct 'relay-log.info' updating by concurrent parallel workers (MDEV-22806)
Eliminate deadlock involving parallel workers, STOP SLAVE and FLUSH TABLES WITH READ LOCK (MDEV-23089)
Correct master-slave automatic reconnection by slave to always pass through all steps of the initial connect. Specifically, do not skip master notification about slave binlog checksum awareness (MDEV-14203)
Upgrading from 10.2 versions earlier than 10.2.17 is highly recommended
for all Galera users due to bug MDEV-12837 which caused serious stability
issues with earlier versions. See the bug issue page for more information.
When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher,
running is required due to changes introduced in MDEV-14637.
Changelog
For a complete list of changes made in MariaDB 10.2.35 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 Distributions which Include MariaDB page.
The following lists the major new features in MariaDB 10.2:
Implemented Features
InnoDB as Default
is now the default storage engine. Until , MariaDB used the XtraDB storage engine as default. XtraDB in 10.2 is not up to date with the latest features of InnoDB and cannot be used. As the InnoDB on disk format is identical to XtraDB's this will not cause any problems when upgrading to . See
Syntax / General Features
storage engine added. (It has its own . In , it is considered Gamma) ()
have been introduced.
The statement was introduced
Incompatible Changes
has been split into a separate package, mariadb-plugin-tokudb.
has been changed; in particular, NOT NULL fields with no default will no longer fall back to a dummy value for inserts which do not specify a value for that field.
Replication from legacy MySQL servers may require setting to NONE.
Triggers
Multiple for the same event ()
The FOLLOWS/PRECEDES clauses have been added to the statement
Multiple triggers are now counted in the Executed_triggers status variable ()
Replication / Binary Log
DML_only can rollback instances/databases/tables to an old snapshot ()
New variable permits restricting the speed at which the slave reads the binlog from the master () — Original code from Tencent Game DBA Team, developed by chouryzhou.
is supported () — Backported from MySQL 5.6 by Kristian Nielsen funded by Booking.com.
GeoJSON / JSON
The (an alias for LONGTEXT) was introduced.
added ()
Implement and functions so the spatial features can be imported/exported using GeoJSON format ()
Information Schema
An information schema plugin to report all user variables, which creates the ()
Changes to the table. Literals are now quoted in the COLUMN_DEFAULT column to distinguish them from expressions (), and two new columns added providing information about columns ().
EXPLAIN
now shows outer_ref_condition field which contains the condition that the(?) SELECT checks on each re-execution ()
now shows sort_key field which shows the sort criteria used by filesort operation. ()
Optimizations
Connection setup was made faster by moving creation of THD to new thread ()
Pushdown conditions into non-mergeable views/derived tables (, ) — Original code from Galina Shalygina
has been re-implemented so as not to lock the entire table when collecting engine independent statistics ()
Compatibility
88 new added. In NO PAD collations, end spaces are significant in comparisons () — Original code from Daniil Medvedev
MariaDB now works when started with a MySQL 5.7.6+ data directory ()
CONNECT
for the CONNECT storage engine ()
The CONNECT engine now supports the ()
System Variables
For a list of all new system variables, see . Variable changes include:
New variable to disable deadlock detection
has been renamed to ()
Default values of the and system variables changed to BACKUP,QUICK
Status Variables
For a list of all new status variables, see .
Scripts
Continuous binary log backup has been added to ()
and mysqlbug have been removed (, )
Other Changes
Added support for OpenSSL 1.1 and LibreSSL ()
Persistent for InnoDB ()
Support COM_RESET_CONNECTION ()
Security Vulnerabilities Fixed in
For a complete list of security vulnerabilities (CVEs) fixed across all
versions of MariaDB, see the
page.
:
:
:
Comparison with MySQL
List of All Releases
Date
Release
Status
Release Notes
Changelog
See Also
Plans for 10.x for features under consideration for features under consideration
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
New options for limiting resource usage and tls/ssl
New statement. WITH is a common table expression that allows you to refer to a subquery expression many times in a query (MDEV-8308 & MDEV-9864) — Original code from Galina Shalygina
Default value of reduced to 60 seconds (MDEV-7635)
Default changed from 0 to 1
EXPLAIN used to show incorrect information about how the optimizer resolved ORDER BY clause or Distinct. This was a long-standing problem with roots back in MySQL. Now, after MDEV-8646 and related fixes, the problem doesn't exist anymore. (For test cases, see MDEV-7982, MDEV-8857, MDEV-7885, MDEV-326)
Internal CRC32 routines use the optimized implementation on Power8 — MDEV-9872
Table cache can automatically partition itself as needed to reduce the contention (MDEV-10296)
The server version can now be faked to work around dated applications that require a particular (MDEV-7780)
is now an alias for slave_parallel_threads
New status variables , and
New variable for setting a directory for storing temporary non-tablespace InnoDB files,
New variable permits restricting the speed at which the slave reads the binlog from the master (MDEV-11064)
The thread pool now gives higher priority to connections that have an active transaction. This can be controlled with the new and system variables. (MDEV-10297)
Default value of changed to STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION (MDEV-7635) (MariaDB 10.2.4 and later)
Default value of changed to zlib - this does not mean pages are now compressed by default, see (MDEV-11838)
The unused variables have been removed (MDEV-12050)
was added to allow one to limit the size of temporary disk tables stored in tmpdir. At the same time was added an alias for . At some point we plan to deprecate tmp_table_size. (MariaDB 10.2.7 and later).
"fast mutexes" have been removed. These aren't faster than normal mutexes, and have been disabled by default for years (MDEV-8111)
Old GPL client library is gone; now MariaDB Server comes with the LGPL Connector/C client library (MDEV-9055)
MariaDB is no longer compiled with jemalloc
TokuDB is now a separate package, not part of the server RPM (because TokuDB still needs jemalloc).
Upgrading to a new major release no longer requires setting to 0. Omitting it can make the upgrade process a lot faster. (MDEV-12289)