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.
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 10.2.43 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 12 Feb 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.
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.43 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.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.
Server crashes in Expression_cache_tracker::fetch_current_stats ()
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
Incomplete replication event groups are detected to error out by the slave IO thread (MDEV-27697)
now flushes the result file to disk after each processed event so the file can be listed with the actual bytes (MDEV-14608)
mariadb-backup prepare fails for incrementals if a new schema is created after full backup is taken (MDEV-28446)
MariaDB server crash at Item_subselect::init_expr_cache_tracker (MDEV-26164, MDEV-26047)
Crash with union of my_decimal type in ORDER BY clause (MDEV-25994)
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 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 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.
: 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 :
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.9 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 27 Sep 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.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.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.21 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 2 Jan 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.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.30 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: 11 Dec 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.
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.36 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 11 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.
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.22 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 11 Feb 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.14 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 27 Mar 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.12 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 4 Jan 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.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.
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:
Temporary files created by merge sort and row log are encrypted if is set to 1, regardless of whether the table encrypted or not (MDEV-12634).
Variables
The following variables have been deprecated, and will be removed in a future release (MDEV-13674):
Security Fixes
Fixes for the following :
CVE-`-```
Notes
For a complete list of changes made in MariaDB 10.2.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.
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 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 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
MDEV-17589 - Stack-buffer-overflow with indexed varchar (utf8) field
MDEV-16987 - possible in read-only mode (forbid ALTER DATABASE in read_only)
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.
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 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.30 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 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 page.
The query optimizer consumed a lot of memory when handling construct in form of key_column [NOT] IN (large-list-of constants) ()
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.36 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.
: 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 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.
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.
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.
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.
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.12 with links to detailed
information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This 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 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 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.
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 MDEV-26537.
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.
InnoDB no longer acquires advisory file locks by default ()
Encryption: Automatically disable key rotation checks for file_key_management plugin ()
Some fixes from MySQL 5.7.35 ()
Optimizer
A query that uses ORDER BY .. LIMIT clause and "Range checked for
each record optimization" could produce incorrect results under some
circumstances ()
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 (, )
"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 makes it so that only the problematic part of the
condition is not pushed. The rest of the condition is now pushed. ()
Packaging & Misc
updated to 25.3.34
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.
: Threadpool/Unix- wait_begin() function does not wake/create threa
ds, when it should
mariadb-backup
: Deadlock of parallel slave and mariadb-backup (with failed log copy thread)
InnoDB
: Reduce size of record offsets
: Reduce the memory usage during recovery
: TRUNCATE and OPTIMIZE are being refused due to "row size too large"
Aria
: aria_pack segfaults in compress_maria_file
Optimizer
: Wrong results with window functions and implicit grouping
: Wrong result of query using DISTINCT COUNT() OVER ()
Replication
: Crashes caused by random values to the offset option of SHOW BINLOG EVENT offset command
: Semisync Master could crash when it executed RESET MASTER and a replica reconnects using GTID protocol
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 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 earlier than 10.2.17 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
- if available, stunnel can be used during
- Remove debuginfo files from Windows .zip files and put in optional supplemental .zip file
- : Support DDL commands during backup
Bug Fixes
- errors on InnoDB lock conflict
Report all InnoDB redo log corruption
- Purge of indexed virtual columns may cause hang on table-rebuilding DDL
Code Cleanup
- Remove INNOBASE_SHARE
- Simplify trx_lock_t memory management
Fixes for the following :
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 development 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.
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 .
Do not use beta 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.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
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
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.
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 5.7.21
The storage engine is now Beta.
updated to 25.3.23
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 .
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.
MariaDB 10.2 is the current development 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
MariaDB 10.2.32 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 12 May 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 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.
MDEV-18669: mariadb-backup writes timestamp in version line
MDEV-18855: mariadb-backup should fetch innodb_compression_level from running server
A query with window function on the left side of the subquery could
cause a crash. (MDEV-25630)
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 (MDEV-25679)
MDEV-13564 - Refuse MLOG_TRUNCATE in mariadb-backup
MDEV-16934 - 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 Galera library in the repositories has been updated to version 25.3.24.
- corruption of InnoDB temporary tables
MDEV-16465 - Invalid (old?) table or database name or hang in ha_innobase::delete_table and log semaphore wait upon concurrent DDL with foreign keys
MDEV-17026 - Assertion srv_undo_sources || ... failed on slow shutdown
MDEV-10754 - wsrep_sst_rsync does not support innodb_data_home_dir
Further improvements and bugfixing for CHECK CONSTRAINT (MDEV-7563) and DEFAULT with expressions (MDEV-10134)
Optimizer improvement: conditions can be (MDEV-9197)
Support for NO PAD , with 88 new NO PAD collations included in the server (MDEV-9711)
Table cache can automatically partition itself as needed to reduce the contention (MDEV-10296)
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)
Window functions support extended. All standard aggregate functions (except GROUP_CONCAT) can be used as window functions. (MDEV-9526)
Performance improvements for faster computing of window functions. Multiple window functions with compatible sorting criteria are computed during the same pass. (MDEV-10059)
MDEV-14637 - Fix hang due to DDL with FOREIGN KEY or persistent statistics
MDEV-15953 - Alter InnoDB Partitioned Table Moves Files (which were originally not in the datadir) to the datadir
MDEV-16515 - InnoDB: Failing assertion: ++retries < 10000 in file dict0dict.cc line 2737
- Allow full redo logging for ALTER TABLE
Temporary tables: MDEV-16713 - InnoDB hang with repeating log entry
MDEV-16596 - Windows - redo log does not work on native 4K sector disks
indexed virtual columns: MDEV-15855 - Deadlock between purge thread and DDL statement
locking: MDEV-16664 - Change the default to innodb_lock_schedule_algorithm=fcfs
Galera: MDEV-15822 - WSREP: BF lock wait long for trx
Packages and a repository for openSUSE 15 have been added with this release, visit the Repository Configuration Tool for instructions on adding the repository
Fixed issue that, from MariaDB 10.2.28, disabled all created by a server with a different server_id. Note that the fix does not re-enable affected events. (MDEV-21758)
mariadb-backup does not honor ignore_db_dirs from server config (MDEV-19347)
mariadb-backup --ftwrl-wait-timeout never times out on explicit lock (MDEV-20230)
FULLTEXT INDEX, Assertion ``!table->fts->in_queue' failed in fts_optimize_remove_table` ()
Wrong estimate of affected BLOB columns in update of PRIMARY KEY ()
Duplicate key value is silently truncated to 64 characters in print_keydup_error ()
Session tracking returns incorrectly long tracking data ()
Add pam_user_map.so file to binary tarball package ()
Running out of file descriptors and eventual crash ()
mysql_upgrade is made aware of the upstream slave tables to issue warnings when that takes place ()
Corruption for SET GLOBAL innodb_ string variables ()
wsrep performance optimization ()
parameter, --ignore-table-data, added ()
Server can fail while replicating conditional comments (Bug#28388217)
updated to 25.3.29
Added the xml-report option to ()
As per the , this will be the last release of for Debian 8 "Jessie"
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.32 with links to detailed
information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
This is the 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 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 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 release is no longer available for download after a problem was noticed when manually running mariadb-upgrade. See MDEV-27789 for more details.Please use a later release.
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.
Galera SST scripts should use ssl_capath (not ssl_ca) for CA directory ()
Replication
Seconds behind master corrected from artificial spikes at relay-log rotation ()
Statement rollback in binlog when transaction creates or drop temporary table is set right ()
Packaging & Misc
prohibition running two upgrades in parallel (, , )
script updated to version 2022-02-08, with the following fixes and enhancements:
Default location of the script has been moved to: (old location is deprecated, but still works)
Docker Library
Faster initialization by disabling binary logging during initialization ()
mysql_upgrade can be run if needed using the environment variable MARIADB_AUTO_UPGRADE=1 ()
A healthcheck script /usr/local/bin/healthcheck.sh is installed in the container with various checking options ()
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.
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
: Debug-only option for dumping the contents of the InnoDB change buffer to the server error log at startup.
mariadb-backup:
: mbstream recreates xtrabackup_info on same directory as backup file
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
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.
MariaDB 10.2 is the current development 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 is the first release candidate (RC) release in the series.
New : ROWS. This can no longer be used as an without being quoted.
Default changed to mixed ().
Default values of and changed to ON ()..
New status variables
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.33 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 10 Aug 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 thepage.
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.
is an release.
Do not use alpha releases on production systems!
MariaDB 10.2.15 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 17 May 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.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.27 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 11 Sep 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.
MDEV-20102: When the ctas from a big table is interrupted ,then you can't drop or recreate the table
MDEV-19292: 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 .
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
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} (MDEV-27732)
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 (issue #401)
log note about note on Securing system users, mysql_secure_installation not required (reddit suggestion)
Fixed a deadlock in FLUSH TABLES…FOR EXPORT (MDEV-22890)
InnoDB data file extension is not crash-safe ()
Minor fixes related to encryption and FULLTEXT INDEX
Dropping the adaptive hash index may cause DDL to lock up InnoDB ()
innodb_log_optimize_ddl=OFF is not crash safe ()
Mariadb service won't shutdown when it's running and the OS datetime updated backwards ()
Doublewrite recovery can corrupt data pages ()
Fixed race conditions related to buffer pool resizing
Crash recovery fixes (, , )
Replication
Make the binlog dump thread to log into errorlog a requested GTID position (MDEV-20428)
Fix stop of the optimistic parallel slave at requested START-SLAVE-UNTIL position (MDEV-15152)
Properly handle RESET MASTER TO value, when the value exceeds the max allowed 2147483647 (MDEV-22451)
Correct 'relay-log.info' updating by concurrent parallel workers ()
Eliminate deadlock involving parallel workers, STOP SLAVE and FLUSH TABLES WITH READ LOCK ()
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 ()
Optimizer
ALTER TABLE ... ANALYZE PARTITION ... with EITS reads and locks all rows ... (