All pages
Powered by GitBook
1 of 47

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Release Notes - MariaDB 10.2 Series

MariaDB 10.2 was a short-term maintenance series of MariaDB maintained until November 2023

MariaDB 10.2.34 Release Notes

The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

Download 10.2.34 | Release Notes | Changelog | Overview of 10.2

Release date: 7 Oct 2020

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.

MariaDB 10.2.34 is a Stable (GA) release.

For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

Thanks, and enjoy MariaDB!

Notable Changes

  • 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 .

MariaDB 10.2.41 Release Notes

The most recent release of is: Stable (GA)

| | |

Release date: 8 Nov 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 of see the page.

Thanks, and enjoy MariaDB!

Notable Items

Galera

  • Fix for WSREP: invalid state ROLLED_BACK (FATAL) (MDEV-25114)

InnoDB

  • ALTER TABLE…IMPORT TABLESPACE fixes (MDEV-20931, MDEV-26131)

  • innodb_undo_log_truncate fixes (MDEV-26450, MDEV-26864)

Replication

  • Memory hogging on slave by ROW event applier is eliminated (MDEV-26712)

  • mysql --binary-mode now properly handles \\0 in data (MDEV-25444)

  • Missed statement rollback in case transaction drops or create temporary table is corrected (MDEV-26833)

Packaging & Misc

  • Session tracking flag in OK_PACKET (MDEV-26868)

  • Some views force server (and mysqldump) to generate invalid SQL for their definitions (MDEV-26299)

Security

  • Fixes for the following :

    • CVE-2021-35604

    • CVE-2021-46667

    • CVE-2022-31624

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.41 with links to detailed information on each push, see the changelog.

Contributors

For a full list of contributors to MariaDB 10.2.41, see the MariaDB Foundation release announcement.

MariaDB 10.2
MariaDB 10.2.44
Download Now
Download 10.2.41
Release Notes
Changelog
Overview of 10.2
MariaDB 10.2
MariaDB 10.1
MariaDB 10.2.41
Stable (GA)
MariaDB 10.2
What is MariaDB 10.2?
CVE-2020-15180
Galera
MDEV-12837
MariaDB 10.2.16
MariaDB 10.2.17
MDEV-14637
MariaDB 10.2.34
changelog
MariaDB 10.2.34
MariaDB Foundation release announcement

MariaDB 10.2.32 Release Notes

The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

Download | Release Notes | Changelog | Overview of 10.2

Release date: 12 May 2020

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.

MariaDB 10.2.32 is a Stable (GA) release.

For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

Thanks, and enjoy MariaDB!

Notable Changes

Events

  • 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 ()

  • FULLTEXT INDEX, Assertion ``!table->fts->in_queue

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!

MariaDB 10.2.40 Release Notes

The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

Download 10.2.40 | Release Notes | Changelog | Overview of 10.2

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 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.

MariaDB 10.2.40 is a Stable (GA) release.

For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

Thanks, and enjoy MariaDB!

Notable Items

InnoDB

  • 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 .

MariaDB 10.2.39 Release Notes

The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

Download 10.2.39 | Release Notes | Changelog | Overview of 10.2

Release date: 23 Jun 2021

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.

MariaDB 10.2.39 is a Stable (GA) release.

For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

Thanks, and enjoy MariaDB!

Notable Items

This version of MariaDB is being released now to fix the following two regressions:

  • Table alias from previous statement interferes later commands ()

  • Join using derived with aggregation returns incorrect results ()

In addition to the above, this release also contains the following fixes:

InnoDB

  • Change buffer entries are lost on InnoDB restart ()

  • InnoDB spatial indexes miss large geometry fields after ()

  • Double free of transaction during truncate operation ()

  • Double free of table when inplace alter FTS add index fails ()

Replication

  • Do not replicate killed multi-table OPTIMIZE TABLE when the signal arrives before any table has been processed ()

  • Fix optistic parallel applier to not deadlock on admin commands OPTIMIZE, REPAIR, and ANALYZE ()

  • Backport parallel slave server shutdown hang ()

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 .

MariaDB 10.2.36 Release Notes

The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

Download 10.2.36 | Release Notes | Changelog | Overview of 10.2

Release date: 11 Nov 2020

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.

MariaDB 10.2.36 is a Stable (GA) release.

For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

Thanks, and enjoy MariaDB!

Notable Changes

  • Out-of-cycle release to fix regressions in

  • 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) ()

    • mysqlnd (from PHP < 7.3) ()

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 .

MariaDB 10.2.43 Release Notes

The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

Download 10.2.43 | Release Notes | Changelog | Overview of 10.2

Release date: 12 Feb 2022

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.

MariaDB 10.2.43 is a Stable (GA) release.

For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

Thanks, and enjoy MariaDB!

Notable Items

  • 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 .

' failed in
fts_optimize_remove_table` (
)
  • Wrong estimate of affected BLOB columns in update of PRIMARY KEY (MDEV-22384)

  • Duplicate key value is silently truncated to 64 characters in print_keydup_error (MDEV-20604)

  • Session tracking returns incorrectly long tracking data (MDEV-22504)

  • Add pam_user_map.so file to binary tarball package (MDEV-21913)

  • Running out of file descriptors and eventual crash (MDEV-18027)

  • mysql_upgrade is made aware of the upstream slave tables to issue warnings when that takes place (MDEV-10047)

  • Corruption for SET GLOBAL innodb_ string variables (MDEV-22393)

  • wsrep performance optimization (MDEV-7962)

  • parameter, --ignore-table-data, added (MDEV-22037)

  • Server can fail while replicating conditional comments (Bug#28388217)

  • Galera wsrep library updated to 25.3.29

  • Added the xml-report option to (MDEV-22176)

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Debian 8 "Jessie"

  • Fixes for the following :

    • CVE-2020-2752

    • CVE-2020-2812

    • CVE-2020-2814

  • MariaDB 10.2.28
    MDEV-21758
    MDEV-22032
    MDEV-19347
    MDEV-20230
    Galera
    MDEV-12837
    MariaDB 10.2.16
    MariaDB 10.2.17
    MDEV-14637
    MariaDB 10.2.32
    changelog
    MariaDB 10.2.32
    MariaDB Foundation release announcement
    MDEV-21550

    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-24393
    MDEV-14180
    MDEV-26205
    MDEV-25858
    MDEV-17783
    MDEV-23937
    MDEV-25969
    MDEV-25969
    Galera
    CVE-2021-2372
    CVE-2021-2389
    CVE-2021-46658
    Galera
    MDEV-12837
    MariaDB 10.2.16
    MariaDB 10.2.17
    MDEV-14637
    MariaDB 10.2.40
    changelog
    MariaDB 10.2.40
    MariaDB Foundation release announcement

    Potential hang in purge for virtual columns (MDEV-25664)

  • Change buffer entries for secondary indexes are lost on InnoDB restart (MDEV-25869)

  • MDEV-25672
    MDEV-25714
    MDEV-25869
    MDEV-25459
    MDEV-25758
    MDEV-25663
    MDEV-25721
    MDEV-22530
    MDEV-17515
    MDEV-20821
    MDEV-22370
    CVE-2021-46666
    CVE-2021-46657
    Galera
    MDEV-12837
    MariaDB 10.2.16
    MariaDB 10.2.17
    MDEV-14637
    Mongo2.jar
    Mongo3.jar
    MariaDB 10.2.39
    changelog
    MariaDB 10.2.39
    MariaDB Foundation release announcement

    mysql-connector-python (all versions) (MDEV-24134)

  • and mysql-connector-java (all versions)

  • The query optimizer consumed a lot of memory when handling construct in form of key_column [NOT] IN (large-list-of constants) (MDEV-24117)

  • Fixes for the following :

    • CVE--``#

  • MariaDB 10.2.35
    MDEV-19838
    MDEV-24121
    MDEV-24121
    Galera
    MDEV-12837
    MariaDB 10.2.16
    MariaDB 10.2.17
    MDEV-14637
    MariaDB 10.2.36
    changelog
    MariaDB 10.2.36
    MariaDB Foundation release announcement

    CVE-2021-46668

  • CVE-2021-46663

  • MariaDB 10.2.42
    MDEV-27789
    MariaDB 10.2.42
    CVE-2021-46665
    CVE-2021-46664
    CVE-2021-46661
    Galera
    MDEV-12837
    MariaDB 10.2.16
    MariaDB 10.2.17
    MDEV-14637
    MariaDB 10.2.43
    changelog
    MariaDB 10.2.43
    MariaDB Foundation release announcement
    CVE-2022-31621

    MariaDB 10.2.37 Release Notes

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    Download 10.2.37 | Release Notes | Changelog | Overview of 10.2

    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.

    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.

    MariaDB 10.2.37 is a Stable (GA) release.

    For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

    Thanks, and enjoy MariaDB!

    Notable Changes

    InnoDB

    • - Hang in buf_page_create() after reusing a previously freed page

    • - analyze forces full scan forcing lock crash

    • - Corruption of system tablespace or last recovered page

    Galera

    • updated to 25.3.32

    • - Server hang due to Galera lock conflict resolution

    • - BF-BF Conflict issue because of UK GAP locks

    • - Plugin system variables and activation options can break

    Replication

    • - relay-log is corrected to rotate past 999999

    • - fixed slave applier for row-based events with FK constraints on virtual columns

    • - Relay_Log_Space of Show-Slave-Status is made thread-safe

    Misc

    • - anomalies in mysql.user tables on previously 5.7 MySQL versions corrected

    • - option

    • 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 .

    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.

    For an overview of see the page.

    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 of see the page.

    Thanks, and enjoy MariaDB!

    MariaDB 10.2.38 Release Notes

    The most recent release of is: Stable (GA)

    | | |

    Release date: 7 May 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 of see the page.

    Thanks, and enjoy MariaDB!

    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 of see the page.

    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.

    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.

    is a release.

    For an overview of see the page.

    Thanks, and enjoy MariaDB!

    MDEV-25179 - and system variables are now read-only

    MDEV-24188
    MDEV-24275
    MDEV-24449
    Galera
    MDEV-23328
    MDEV-23851
    MDEV-20717
    MDEV-8134
    MDEV-23033
    MDEV-4633
    MDEV-24122
    MDEV-23630
    CVE-2021-27928
    Galera
    MDEV-12837
    MariaDB 10.2.16
    MariaDB 10.2.17
    MDEV-14637
    MariaDB 10.2.37
    changelog
    MariaDB 10.2.37
    MariaDB Foundation release announcement

    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.

    Thanks, and enjoy MariaDB!

    Notable Items

    InnoDB

    • does not disallow .isl file creation (MDEV-26870)

    Galera

    • Galera updated to 25.3.35

    • Galera SST scripts should use ssl_capath (not ssl_ca) for CA directory (MDEV-27181)

    Replication

    • Seconds behind master corrected from artificial spikes at relay-log rotation (MDEV-16091)

    • Statement rollback in binlog when transaction creates or drop temporary table is set right (MDEV-26833)

    Packaging & Misc

    • prohibition running two upgrades in parallel (MDEV-27068, MDEV-27107, MDEV-27279)

    • 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 ()

    Security

    • Fixes for the following :

      • CVE-2022-24052

      • CVE-2022-24051

      • CVE-2022-24050

    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.

    Contributors

    For a full list of contributors to MariaDB 10.2.42, see the MariaDB Foundation release announcement.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    Download 10.2.42
    Release Notes
    Changelog
    Overview of 10.2
    MDEV-27789
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.42
    Stable (GA)
    MariaDB 10.2
    What is MariaDB 10.2?

    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.

    Notable Changes

    Variables

    • Limit to 255 (MDEV-22258).

    • Minimum value of raised to 8 (previously 4) so fixed size like and are not truncated for lower values of max_sort_length (MDEV-22715).

    InnoDB

    • updated to 5.7.29

    • Fixed corruption in delete buffering (MDEV-22497)

    • Fixed a deadlock in FLUSH TABLES…FOR EXPORT (MDEV-22890)

    • InnoDB data file extension is not crash-safe (MDEV-23190)

    • 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 ... (MDEV-21472)

    • 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 (MDEV-22665)

    • LATERAL DERIVED is not clearly visible in EXPLAIN FORMAT=JSON, make LATERAL DERIVED tables visible in EXPLAIN FORMAT=JSON output ()

    • Crash on WITH RECURSIVE large query ()

    • Crash with Prepared Statement with a '?' parameter inside a re-used CTE ()

    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 (MDEV-19232)

    • MariaDB could crash after changing the query_cache size (MDEV-5924)

    • Errors and SIGSEGV on CREATE TABLE w/ various charsets (MDEV-22111)

    • Crash in CREATE TABLE AS SELECT when the precision of returning type = 0 ()

    • XA: Reject DDL operations between PREPARE and COMMIT ()

    • Stop mariadb-backup --prepare on errors during innodb redo log applying ()

    • Server crashes in mysql_alter_table upon adding a non-null date column under NO_ZERO_DATE with ALGORITHM=INPLACE ()

    • Can't uninstall plugin if the library file doesn't exist ()

    • 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.33 with links to detailed information on each push, see the changelog.

    Contributors

    For a full list of contributors to MariaDB 10.2.33, see the MariaDB Foundation release announcement.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    Download
    Release Notes
    Changelog
    Overview of 10.2
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.33
    Stable (GA)
    MariaDB 10.2
    What is MariaDB 10.2?

    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.

    Notable Changes
    • for calculating the spherical distance between two geometries (point or multipoint) on a sphere (MDEV-13467)

    • Crash with invalid multi-table update of view in 2nd execution of SP (MDEV-24823)

    • Incorrect name resolution for subqueries in ON expressions (MDEV-25362)

    • Complex query in Store procedure corrupts results (MDEV-25182)

    mariadb-backup

    • RENAME TABLE causes "Ignoring data file" messages (MDEV-25568)

    InnoDB

    • MVCC read from index on CHAR or VARCHAR wrongly omits rows (MDEV-25459)

    • Race conditions in persistent statistics (MDEV-10682, MDEV-18802, MDEV-25051)

    Galera

    • Galera updated to 25.3.33

    • SET PASSWORD command fail with wsrep api (MDEV-25258)

    • Long BF log wait turns on InnoDB Monitor output without telling, never turns it off (MDEV-25319)

    Replication

    • Replication Heartbeat event was uncapable to cary 4GB+ offsets (MDEV-16146)

    • FLUSH LOGS race against Binlog checkpoint event creation (MDEV-24526)

    Audit Plugin

    • The QUERY_DDL setting now logs CREATE/DROP [PROCEDURE / FUNCTION / USER] statements. See . (MDEV-23457)

    Packaging & Misc

    • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Ubuntu 16.04 Xenial

    Security

    • Fixes for the following :

      • CVE-2021-2180

      • CVE-2021-2166

      • CVE-2021-2154

    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.38 with links to detailed information on each push, see the changelog.

    Contributors

    For a full list of contributors to MariaDB 10.2.38, see the MariaDB Foundation release announcement.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    Download 10.2.38
    Release Notes
    Changelog
    Overview of 10.2
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.38
    Stable (GA)
    MariaDB 10.2
    What is MariaDB 10.2?

    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.

    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)

    • MDEV-17720 - does not handle

    • MDEV-6453 - Assertion `inited==NONE || (inited==RND && scan)' failed in handler::ha_rnd_init(bool) with InnoDB, joins, AND/OR conditions

    • - fails to copy encrypted InnoDB system tablespace if LSN>4G

    • - Database corruption after renaming a prefix-indexed column

    • - Orphan temporary files after interrupted cause InnoDB: Operating system error number 17 and eventual fatal error 71

    • Fixes for the following :

      • CVE-`-```

    When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced inMDEV-14637.

    Changelog

    For a complete list of changes made in MariaDB 10.2.21 with links to detailed information on each push, see the changelog.

    Contributors

    For a full list of contributors to MariaDB 10.2.21, see the MariaDB Foundation release announcement.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    Download
    Release Notes
    Changelog
    Overview of 10.2
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.21
    Stable (GA)
    MariaDB 10.2
    What is MariaDB 10.2?
    MDEV-12837

    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.

    Notable Changes
    • updated to Connect 1.06.0010

    • MDEV-15326: A race condition in InnoDB transaction commit that affects record locking was fixed

    • MDEV-17187: Table doesn't exist in engine after ALTER of FOREIGN KEY

    • MDEV-20301: InnoDB's MVCC has O(N^2) behaviors

    • : Simplify .ibd file creation

    • : Failing assertion: srv_log_file_size <= 512ULL << 30 while preparing backup

    • : Replication hangs with "preparing" and never starts

    • : Remove unnecessary locking for INSERT...ON DUPLICATE KEY UPDATE

    • 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.27 with links to detailed information on each push, see the changelog.

    Contributors

    For a full list of contributors to MariaDB 10.2.27, see the MariaDB Foundation release announcement.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    Download
    Release Notes
    Changelog
    Overview of 10.2
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.27
    Stable (GA)
    MariaDB 10.2
    What is MariaDB 10.2?

    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.

    CVE-2020-2760
    CVE-2020-13249

    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.44 Release Notes

    Download | Release Notes | Changelog | Overview of 10.2

    Release date: 20 May 2022

    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.

    MariaDB 10.2.44 is a Stable (GA) release.

    For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

    Thanks, and enjoy MariaDB!

    Notable Items

    • As per the , this will be the final release of

    Replication

    • Automatically generated Gtid_log_list_event is made to recognize within replication event group as a formal member ()

    • using two or more unique key values at a time with is corrected ()

    • stops issuing unnecessary "Unsafe statement" with ()

    Backup

    • Incorrect binlogs after Galera SST using rsync and ()

    • does not detect multi-source replication slave ()

    • Useless warning "InnoDB: Allocated tablespace ID for , old maximum was 0" during backup stage ()

    • prepare fails for incrementals if a new schema is created after full backup is taken ()

    Optimizer

    • Subquery in an UPDATE query uses full scan instead of range ()

    • Assertion `item1->type() == Item::FIELD_ITEM ... ()

    • Server crashes in Expression_cache_tracker::fetch_current_stats ()

    • MariaDB server crash at Item_subselect::init_expr_cache_tracker (, )

    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 .

    MariaDB 10.2.8 Release Notes

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    Download | Release Notes | Changelog | Overview of 10.2

    Release date: 18 Aug 2017

    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.

    MariaDB 10.2.8 is a Stable (GA) release.

    For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

    Thanks, and enjoy MariaDB!

    Notable Changes

    • updated to 5.7.19

    • updated to 5.6.36-82.1

    • engine updated to 1.06.0001

      • Beta support for added

    Notes

    For a complete list of changes made in , with links to detailed information on each push, see the .

    MariaDB 10.2.9 Release Notes

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    Download | Release Notes | Changelog | Overview of 10.2

    Release date: 27 Sep 2017

    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.

    MariaDB 10.2.9 is a Stable (GA) release.

    For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

    Thanks, and enjoy MariaDB!

    Notable Changes

    Updates

    • updated to 5.6.37-82.2

    Bug Fixes

    • : 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

    • : CREATE FULLTEXT INDEX on encrypted table fails

    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 .

    MariaDB 10.2.30 Release Notes

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    Note that this version contains an issue that disabled all events created by a server with a different server_id. See MDEV-21758 for details.

    Download | Release Notes | Changelog | Overview of 10.2

    Release date: 11 Dec 2019

    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.

    MariaDB 10.2.30 is a Stable (GA) release.

    For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

    Thanks, and enjoy MariaDB!

    Notable Changes

    General

    • : SEC_E_INVALID_TOKEN when server sends large message during SSL handshake

    mariadb-backup

    • : Aria engine: Undo phase failed from incremental backup

    InnoDB

    • : Stop issuing 'row size' error on DML

    • : Don't print "row size too large" warnings in error log if innodb_strict_mode=OFF and log_warnings<=2

    • : Remove redundant writes to the redo log

    Optimizer

    • : Wrong result when using a smaller size for sort buffer

    Replication

    • : Repl_semi_sync_master::commit_trx assertion failure

    • Fixes for the following :

      • CVE-`-```

    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 .

    MariaDB 10.2.5 Release Notes

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    Download | Release Notes | Changelog | Overview of 10.2

    Release date: 5 Apr 2017

    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.

    MariaDB 10.2.5 is a Release Candidate (RC) release.

    For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

    Thanks, and enjoy MariaDB!

    Notable Changes

    • updated to 5.6.35-80.0

    • updated to 8.40

    • :

    • : Fix a 10.1.21 regression with failed INSERT, BEFORE INSERT triggers, and columns with no default value

    Notes

    For a complete list of changes made in , with links to detailed information on each push, see the .

    MariaDB 10.2.16 Release Notes

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    Download | Release Notes | Changelog | Overview of 10.2

    Release date: 26 Jun 2018

    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.

    MariaDB 10.2.16 is a Stable (GA) release.

    For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? 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

    • is now

    • : now supports MyRocks

    • - InnoDB fails to shut down purge workers, causing hang

    • - Wrong INFORMATION_SCHEMA.INNODB_BUFFER_PAGE.TABLE_NAME

    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 .

    MariaDB 10.2.28 Release Notes

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    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.

    Download | Release Notes | Changelog | Overview of 10.2

    Alternate download from mariadb.org

    Release date: 5 Nov 2019

    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.

    is a release.

    For an overview of see the page.

    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

      • : mariadb-backup creates binlog files in server binlog directory on --prepare --export step

    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 .

    MariaDB 10.2.22 Release Notes

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    Download | Release Notes | Changelog | Overview of 10.2

    Release date: 11 Feb 2019

    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.

    MariaDB 10.2.22 will be a Stable (GA) release.

    For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? 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

    • updated to 9.5

    • Backport .

    • : Maximum value of is now 2097152.

    • InnoDB ALTER TABLE fixes:, , ,

    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 .

    MariaDB 10.2.11 Release Notes

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    Download | Release Notes | Changelog | Overview of 10.2

    Release date: 28 Nov 2017

    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.

    MariaDB 10.2.11 is a Stable (GA) release.

    For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

    Thanks, and enjoy MariaDB!

    Notable Changes

    InnoDB

    • INSERT ON DUPLICATE KEY UPDATE foreign key fail

    • Support CRC32 SSE2 implementation under Windows

    • / Corruption during online table-rebuilding ALTER when VIRTUAL columns exist

    • ALTER TABLE…DISCARD TABLESPACE takes a lot of time

    • mariadb-backup 10.2 fails to back up a multi-file InnoDB system tablespace

    • mariadb-backup incremental incorrectly extends system tablespace for multi-file innodb_data_file_path

    • Copy all innodb undo tablespaces from the backup directory to destination

    Other

    • updated to 7.07.

    • As per the , this will be the last release of 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 Ubuntu 17.10 Artful added

    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 .

    MariaDB 10.2.10 Release Notes

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    Download | Release Notes | Changelog | Overview of 10.2

    Release date: 31 Oct 2017

    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.

    MariaDB 10.2.10 is a Stable (GA) release.

    For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

    Thanks, and enjoy MariaDB!

    Notable Changes

    • updated to 5.7.20

    • updated to 1.6.0005

    • now Stable (GA)

    • : 'Undo log record is too big.' error occurring in very narrow range of string lengths

    Notes

    For a complete list of changes made in , with links to detailed information on each push, see the .

    MariaDB 10.2.14 Release Notes

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    Download | Release Notes | Changelog | Overview of 10.2

    Release date: 27 Mar 2018

    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.

    MariaDB 10.2.14 is a Stable (GA) release.

    For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? 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

    • is now

    • - Added the , for monitoring disk space

    • - does not work properly when used with DATA DIRECTORY.

    • - MariaDB (still) slow start

    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.

    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.

    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.

    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.

    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.

    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.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.

    is a release.

    For an overview of see the page.

    Thanks, and enjoy MariaDB!

    MariaDB 10.2.20 Release Notes

    The most recent release of is: Stable (GA)

    | | |

    Release date: 24 Dec 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.

    will be a release.

    For an overview of see the page.

    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.

    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 of see the page.

    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.

    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 of see the page.

    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.

    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.

    For an overview of see the page.

    Thanks, and enjoy MariaDB!

    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 of see the page.

    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.

    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!

    For an overview of see the page.

    Thanks, and enjoy MariaDB!

    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)

  • Crash with union of my_decimal type in ORDER BY clause (MDEV-25994)

  • SIGSEGV in st_join_table::cleanup (MDEV-24560)

  • Assertion `!eliminated' failed in Item_subselect::exec (MDEV-28437)

  • CVE-2022-27378

  • CVE-2022-27380

  • CVE-2022-27381

  • CVE-2022-27383

  • CVE-2022-27384

  • CVE-2022-27386

  • CVE-2022-27387

  • CVE-2022-27445

  • CVE-2022-32083

  • CVE-2022-32088

  • MariaDB Maintenance Policy
    MariaDB 10.2
    MDEV-28550
    MDEV-28310
    MDEV-21810
    mariadb-backup
    MDEV-27524
    mariadb-backup
    MDEV-21037
    MDEV-27343
    mariadb-backup
    MDEV-28446
    MDEV-22377
    MDEV-19398
    MDEV-28268
    MDEV-26164
    MDEV-26047
    CVE-2021-46669
    CVE-2022-21427
    CVE-2022-27377
    Galera
    MDEV-12837
    MariaDB 10.2.16
    MariaDB 10.2.17
    MDEV-14637
    MariaDB 10.2.44
    changelog
    MariaDB 10.2.44
    MariaDB Foundation release announcement

    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 (MDEV-12181)

  • Fix (MDEV-12180)

  • Fixed bug that permitted columns being dropped which would result in an additional constraint being added to the table. See the example in (MDEV-11114).

  • Nonsensical combinations of SIGNED, UNSIGNED and ZEROFILL are no longer permitted - see (MDEV-8659).

  • mariadb-backup now included for Debian and Ubuntu (in MariaDB 10.2.7 it was released only for Red Hat, CentOS, and Fedora)

  • Fedora 26 repositories have been added in this release.

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Fedora 24.

  • Fixes for the following :

    • CVE-2017-3636

    • CVE-2017-3641

    • CVE-2017-3653

  • MariaDB 10.2.8
    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.

    MDEV-13318: Crash recovery failure after the server is killed during innodb_encrypt_log startup

  • MDEV-13488: InnoDB writes CRYPT_INFO even though encryption is not enabled (fixes upgrades from 5.5 to 10.1)

  • MDEV-13437: InnoDB fails to return error for XA COMMIT or XA ROLLBACK in read-only mode

  • MDEV-13637: InnoDB change buffer housekeeping can cause redo log overrun and possibly deadlocks

  • MDEV-13534: InnoDB STATS_PERSISTENT fails to ignore garbage delete-mark flag on node pointer pages (caused by MDEV-12698)

  • MDEV-13606: XA PREPARE transactions should survive innodb_force_recovery=1 or 2

  • MDEV-13167: InnoDB key rotation is not skipping unused pages

  • MDEV-12988: mariadb-backup fails if innodb_undo_tablespaces>0

  • MDEV-13471: Test failure on innodb.log_file_size,4k (fixes Galera when using innodb_page_size=4k)

  • MDEV-13684: InnoDB race condition between fil_crypt_thread and btr_scrub_init

  • MDEV-13899
    MDEV-13847
    MDEV-13678
    MDEV-13826
    MariaDB backup
    MDEV-13466
    MDEV-12634
    MDEV-13674
    MariaDB 10.2.9
    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.

    MDEV-21069: Crash on DROP TABLE if the data file is corrupted

  • some cleanup of AIO code, to better report errors

  • MDEV-13492
    MDEV-18310
    MDEV-20949
    MDEV-20832
    MDEV-21024
    MDEV-21044
    MDEV-19376
    Galera
    MDEV-12837
    MariaDB 10.2.16
    MariaDB 10.2.17
    MDEV-14637
    MariaDB 10.2.30
    changelog
    MariaDB 10.2.30
    MariaDB Foundation release announcement

    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-12075: Fix a 10.1.21 regression in the InnoDB data file extension code

  • MDEV-11027: better InnoDB crash recovery progress reporting

  • MDEV-11520: improvements to how InnoDB data files are extended

  • Improvements to InnoDB startup/shutdown to make it more robust

  • MDEV-9734: compatible bintar files now available

  • MDEV-9658: 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)

    • MyRocks is not available for 32-bit platforms

  • added for Windows, CentOS, RHEL, and Fedora packages

  • MDEV-12091: Shutdown fails to wait for rollback of recovered transactions to finish

  • MDEV-12219: Discard temporary undo logs at transaction commit

  • MDEV-12289: compatibility fix for upgrading from 5.5 or 10.x

  • MDEV-9255: Two new columns added to the table, providing information about columns.

  • Fixes for the following :

    • CVE-2017-3313

    • CVE-2017-3302

  • MDEV-12160
    MDEV-11842
    MariaDB 10.2.5
    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.

    MDEV-13834 - Upgrade failure from 10.1 innodb_encrypt_log

  • MDEV-16283 - ALTER TABLE...DISCARD TABLESPACE still takes long on a large buffer pool

  • MDEV-16376 - ASAN: heap-use-after-free in gcol.innodb_virtual_debug

  • MDEV-15824 - innodb_defragment=ON trumps innodb_optimize_fulltext_only=ON in OPTIMIZE TABLE

  • MDEV-16124 - fil_rename_tablespace() times out and crashes server during table-rebuilding ALTER TABLE

  • MDEV-16416 - Crash on IMPORT TABLESPACE of a ROW_FORMAT=COMPRESSED table

  • MDEV-16456 - InnoDB error "returned OS error 71" complains about wrong path

  • MDEV-13103 - Deal with page_compressed page corruption

  • MDEV-16496 - mariadb-backup: Implement --verbose option to instrument InnoDB log apply

  • MDEV-16087 - Inconsistent SELECT results when query cache is enabled

  • MDEV-15114 - ASAN heap-use-after-free in mem_heap_dup or dfield_data_is_binary_equal (fix for indexed virtual columns)

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Ubuntu 17.10 Artful

  • Fixes for the following :

    • CVE-`-```

  • Stable (GA)
    MDEV-13122
    mariadb-backup
    MDEV-13779
    MDEV-16267
    MariaDB 10.2.16
    changelog
    MariaDB 10.2.16
    MariaDB Foundation release announcement

    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.

  • FULLTEXT INDEX:

    • MDEV-19647: Server hangs after dropping full text indexes and restart

    • MDEV-19529: InnoDB hang on DROP FULLTEXT INDEX

    • MDEV-19073: FTS row mismatch after crash recovery

    • : FULLTEXT INDEX activity causes InnoDB hang

  • MDEV-20927: Duplicate key with auto increment

  • ALTER TABLE:

    • MDEV-20799: DROP Virtual Column crash

    • MDEV-20852: BtrBulk is unnecessarily holding dict_index_t::lock

  • Galera wsrep library updated to 25.3.28

  • Fixes for the following :

    • CVE-2019-2974

    • CVE-2019-2938

    • CVE-2020-2780

  • MariaDB 10.2.28
    Stable (GA)
    MariaDB 10.2
    What is MariaDB 10.2?
    MDEV-20864
    MDEV-18438
    MDEV-20703
    Galera
    MDEV-12837
    MariaDB 10.2.16
    MariaDB 10.2.17
    MDEV-14637
    MariaDB 10.2.28
    changelog
    MariaDB 10.2.28
    MariaDB Foundation release announcement

    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-backup fixes: MDEV-18185, MDEV-18201, MDEV-18194

  • Galera crash recovery fix: MDEV-15740

  • Encryption fixes: MDEV-18129, MDEV-18183, MDEV-18279

  • Fixes for the following :

    • CVE-2019-2510

    • CVE-2019-2537

  • MDEV-17475
    MDEV-16499
    MDEV-18186
    MDEV-18237
    MariaDB 10.2.16
    MariaDB 10.2.17
    MDEV-14637
    MariaDB 10.2.22
    changelog
    MariaDB 10.2.22
    MariaDB Foundation release announcement

    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-18222
    MDEV-18256
    MDEV-18016
    MDEV-16849

    MDEV-14140 IMPORT TABLESPACE must not go beyond FSP_FREE_LIMIT

  • MDEV-14244 MariaDB 10.2.10 fails to run on Debian Stretch with ext3 and O_DIRECT

  • MDEV-14219 Allow online table rebuild when encryption or compression parameters change

  • MDEV-13206
    MDEV-13795
    MDEV-14332
    MDEV-13328
    mariadb-backup
    MDEV-14499
    MDEV-14447
    MDEV-13560
    MariaDB Deprecation Policy
    MariaDB 10.2
    Repositories
    MariaDB 10.2.11
    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.

    MDEV-13918: Race condition between and //

  • MDEV-13838: Wrong result after altering a partitioned table

  • fixed bugs in InnoDB

    • MDEV-12676: InnoDB FTS duplicate key error

    • MDEV-13051: InnoDB crash after failed ADD INDEX and table_definition_cache eviction

    • MDEV-13446: fts_create_doc_id() unnecessarily allocates 8 bytes for every inserted row

  • MDEV-13941 Fix high NTFS fragmentation

  • MDEV-13512 Fix corruption of SPATIAL INDEX in tables

  • MDEV-14023 10.1 InnoDB tables with virtual columns cannot be accessed in 10.2

  • MDEV-11336 was enabled

  • Fixes for the following :

    • CVE-2017-10378, MDEV-13819

    • CVE-2017-10268

    • CVE-2017-15365

  • mariadb-backup
    MDEV-14051
    MariaDB 10.2.10
    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.

    MDEV-12255 - Wrong result with

  • MDEV-12396 - cleanup

  • MDEV-14648 - Restore fix for MySQL BUG#39053 - does not allow the storage engine to cleanup open connections

  • MDEV-15249 - IMPORT fixes

  • MDEV-14988 - tries to modify files if transactions were recovered in COMMITTED state

  • MDEV-14773 - hangs for InnoDB table with (fixing a recent regression from upstream)

  • MDEV-15529 - IMPORT TABLESPACE unnecessarily uses the doublewrite buffer

  • MDEV-15554 - InnoDB page_cleaner shutdown sometimes hangs

  • MDEV-14545 - mariadb-backup - Backup fails due to MLOG_INDEX_LOAD record

  • Fixes for the following :

    • CVE-`-```

  • Gamma (RC)
    MDEV-14533
    MDEV-14611
    MDEV-15333
    MariaDB 10.2.14
    changelog
    MariaDB 10.2.14
    MariaDB Foundation release announcement

    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.

    Notable Changes
    • Set the default value of to OFF by default (MDEV-23720)

    • maximum index size increased from 1000 to 3500 bytes (MDEV-24017)

    • issue (MDEV-23702)

    • Temporary tables can no longer overwrite existing files. Instead an error is returned should a conflict occur ()

    • Binlog checksum verification at recovery time ()

    • Verbose print-out of by ()

    • from validates when binlog checksummed ()

    • Freeing memory of ()

    • Corrected verbose output for multi-record Rows-log-event ()

    • no longer causes crash ()

    • that were running an index condition pushdown in InnoDB will now return an error ()

    • Wrong direxec param data caused crash; Numerous fixes about Mac builds (by Dmitri Shulga) ()

    • now logs proxy users ()

    • Crash on SELECT on a table with indexed virtual columns ()

    • updated to 5.7.32 ()

    • Bug fixes related to adaptive hash index (, )

    • Fixed a bug in the recovery of encrypted tables ()

    • Fixed a race condition in MVCC reads ()

    • fixes (, , , )

    • Fixed a crash with the function ()

    • Computing certain on a server started with could cause a wrong query result or crash ()

    • A query with a certain form of WHERE clause over a table with multiple indexes could pick a less efficient range plan ()

    Galera

    • Galera wsrep library updated to 25.3.31

    • Fixed galera got stuck after flush tables (MDEV-22707)

    • IPv6 SST handling improved (MDEV-21770, MDEV-23576, MDEV-23580, MDEV-23581, MDEV-23574)

    • Fixed SIGSEGV in lock_rec_unlock (MDEV-23101)

    • Fixed replication of timezone if only 1 timezone is loaded ()

    • Fixed replication of ()

    • Fixed SST FLUSH TABLES WITH READ LOCK timeout ()

    Notes

    • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for CentOS/RHEL 6

    • Fixes for the following :

      • CVE-2020-14812

      • CVE-2020-14765

      • ()

      • ()

    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.

    Contributors

    For a full list of contributors to MariaDB 10.2.35, see the MariaDB Foundation release announcement.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    Download 10.2.35
    Release Notes
    Changelog
    Overview of 10.2
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.35
    Stable (GA)
    MariaDB 10.2
    What is MariaDB 10.2?

    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.

    Thanks, and enjoy MariaDB!

    Notable Changes

    • Data type validation:

      • MDEV-17833: ALTER TABLE is not enforcing prefix index size limit

      • MDEV-17989: InnoDB: Failing assertion: dict_tf2_is_valid(flags, flags2)

    • MDEV-17765: Locking bug fix for SPATIAL INDEX

    • , , : Fixes for FULLTEXT INDEX

    • Fixes for regressions introduced in MariaDB Server 10.2.19 by the backup-safe TRUNCATE TABLE (, innodb_safe_truncate=ON) and innodb_undo_log_truncate:

      • , , , ,

    • Several improvements to MariaDB Server and backup for dealing with encrypted or page_compressed pages:

      • : corruption in encrypted table may be overlooked

      • : On little-endian systems, remove bug-compatible variant of innodb_checksum_algorithm=crc32

      • : Make innodb_checksum_algorithm stricter for strict_* values

    • The in the repositories has been updated to version 25.3.25

    • Fixes for the following :

      • CVE-`-```

    When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced inMDEV-14637.

    Changelog

    For a complete list of changes made in MariaDB 10.2.20 with links to detailed information on each push, see the changelog.

    Contributors

    For a full list of contributors to MariaDB 10.2.20, see the MariaDB Foundation release announcement.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    Download
    Release Notes
    Changelog
    Overview of 10.2
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.20
    Stable (GA)
    MariaDB 10.2
    What is MariaDB 10.2?
    MDEV-12837

    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.

    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

    • MDEV-16791 - mariadb-backup: Support DDL commands during backup

    • MDEV-13564 - Refuse MLOG_TRUNCATE in mariadb-backup

    • - 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.

    Bug Fixes

    • MDEV-13333 - errors on InnoDB lock conflict

    • Report all InnoDB redo log corruption

    • MDEV-17043 - Purge of indexed virtual columns may cause hang on table-rebuilding DDL

    • MDEV-16868 - corruption of InnoDB temporary tables

    • - Invalid (old?) table or database name or hang in ha_innobase::delete_table and log semaphore wait upon concurrent DDL with foreign keys

    • - Assertion srv_undo_sources || ... failed on slow shutdown

    • - wsrep_sst_rsync does not support innodb_data_home_dir

    Code Cleanup

    • MDEV-16557 - Remove INNOBASE_SHARE

    • MDEV-16136 - Simplify trx_lock_t memory management

    • Fixes for the following :

      • CVE-2019-2503

    When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced inMDEV-14637.

    Changelog

    For a complete list of changes made in MariaDB 10.2.18 with links to detailed information on each push, see the changelog.

    Contributors

    For a full list of contributors to MariaDB 10.2.18, see the MariaDB Foundation release announcement.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    Download
    Release Notes
    Changelog
    Overview of 10.2
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.18
    Stable (GA)
    MariaDB 10.2
    What is MariaDB 10.2?
    MDEV-12837

    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.

    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

      • - Allow full redo logging for ALTER TABLE

    • 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

    • Fixes for the following :

    When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced inMDEV-14637.

    Changelog

    For a complete list of changes made in MariaDB 10.2.17 with links to detailed information on each push, see the changelog.

    Contributors

    For a full list of contributors to MariaDB 10.2.17, see the MariaDB Foundation release announcement.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    Download
    Release Notes
    Changelog
    Overview of 10.2
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.17
    Stable (GA)
    MariaDB 10.2
    What is MariaDB 10.2?
    MDEV-12837

    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.

    Notable Changes

    General

    • MDEV-21337: fix aligned_malloc()

    • MDEV-21343: Threadpool/Unix- wait_begin() function does not wake/create threa ds, when it should

    mariadb-backup

    • MDEV-21255: Deadlock of parallel slave and mariadb-backup (with failed log copy thread)

    InnoDB

    • MDEV-20950: Reduce size of record offsets

    • MDEV-19176: Reduce the memory usage during recovery

    • MDEV-21429: TRUNCATE and OPTIMIZE are being refused due to "row size too large"

    • MDEV-21500: Server hang when using simulated AIO

    • : Possible hang during purge of history, or rollback

    • : Wrong estimate of affected BLOB columns in update

    • : InnoDB may hang due to SPATIAL INDEX

    • : Avoid some crashes in ALTER TABLE...IMPORT TABLESPACE

    Aria

    • MDEV-14183: aria_pack segfaults in compress_maria_file

    Optimizer

    • MDEV-21318: Wrong results with window functions and implicit grouping

    • MDEV-16579: Wrong result of query using DISTINCT COUNT() OVER ()

    Replication

    • MDEV-18046: Crashes caused by random values to the offset option of SHOW BINLOG EVENT offset command

    • MDEV-19376: Semisync Master could crash when it executed RESET MASTER and a replica reconnects using GTID protocol

    Security

    • Fixes for the following :

      • CVE-2020-2574

    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.

    Contributors

    For a full list of contributors to MariaDB 10.2.31, see the MariaDB Foundation release announcement.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    MDEV-21758
    Download
    Release Notes
    Changelog
    Overview of 10.2
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.31
    Stable (GA)
    MariaDB 10.2
    What is MariaDB 10.2?

    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.

    Thanks, and enjoy MariaDB!

    Notable Changes

    • MDEV-13992: and

    • MDEV-19490: show tables fails when selecting the information_schema database

    • MDEV-19491: multi-update with triggers and stored routines

    • MDEV-19509: 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

    • Fixes for the following :

      • CVE-`-```

    When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced inMDEV-14637.

    Changelog

    For a complete list of changes made in MariaDB 10.2.25 with links to detailed information on each push, see the changelog.

    Contributors

    For a full list of contributors to MariaDB 10.2.25, see the MariaDB Foundation release announcement.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    Download
    Release Notes
    Changelog
    Overview of 10.2
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.25
    Stable (GA)
    MariaDB 10.2
    What is MariaDB 10.2?
    MDEV-12837

    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.

    Notable Changes

    This is the second beta release in the MariaDB 10.2 series.

    • updated to 9.4

    • Galera wsrep library updated to 25.3.19

    • Packages for Debian 9 "stretch" amd64 and x86 and Debian 8 "jessie" ppc64el added

    • Fix for FULLTEXT index crash (MDEV-11233).

    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.

    • is supported (MDEV-7145)

    • is supported (MDEV-11065) — Tencent Game DBA Team, developed by vinchen.

    Statements

    • added (MDEV-9143).

    • Oracle-style statement (MDEV-10585).

    • /Dynamic SQL now understand most expressions (MDEV-10866, MDEV-10709).

    Triggers

    • Multiple per table (MDEV-6112)

    • 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.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    Download
    Release Notes
    Changelog
    Overview of 10.2
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.3
    Beta
    MariaDB 10.2
    What is MariaDB 10.2?

    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-keyring-2019.gpg
    mariadb-keyring-2019.gpg.sha256
    MDEV-27732
    issue #401
    reddit suggestion
    CVE-2022-24048
    CVE-2021-46659
    CVE-2022-0778
    CVE-2022-21595
    CVE-2022-31622
    CVE-2022-31623
    subscribing
    MDEV-22456
    MDEV-21347
    MDEV-17481
    MDEV-11799
    MDEV-21347
    MDEV-23190
    MDEV-11799
    MDEV-22806
    MDEV-23089
    MDEV-14203
    MDEV-17568
    MDEV-22748
    MDEV-22779
    MDEV-22502
    MDEV-22420
    MDEV-22354
    MDEV-18042
    MDEV-21258
    CVE-2021-2022
    subscribing
    CVE-2022-21451
    subscribing
    MDEV-18105
    mariadb-backup
    MDEV-18041
    MDEV-17470
    subscribing
    MDEV-18128
    MDEV-20060
    MDEV-20247
    MDEV-17614
    subscribing
    subscribing
    subscribing
    subscribing
    subscribing
    subscribing
    subscribing
    subscribing
    subscribing

    MariaDB 10.2.13 Release Notes

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    Download | Release Notes | Changelog | Overview of 10.2

    Release date: 13 Feb 2018

    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.

    MariaDB 10.2.13 is a Stable (GA) release.

    For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? 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

    • updated to 5.7.21

    • The storage engine is now Beta.

    • updated to 25.3.23

    • - ALTER TABLE EXCHANGE PARTITION does not work properly when used with DATA DIRECTORY

    Security Fixes

    • Fixes for the following :

    Notes

    For a complete list of changes made in with links to detailed information on each push, see the .

    MariaDB 10.2.15 Release Notes

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    Download | Release Notes | Changelog | Overview of 10.2

    Release date: 17 May 2018

    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.

    MariaDB 10.2.15 is a Stable (GA) release.

    For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

    Thanks, and enjoy MariaDB!

    Notable Changes

    • updated to 5.7.22

    • updated to 8.42

    • The embedded server library now supports SSL when connecting to remote servers

    • - Incomplete validation of missing tablespace during recovery

    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 .

    MariaDB 10.2.19 Release Notes

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    Download | Release Notes | Changelog | Overview of 10.2

    Release date: 13 Nov 2018

    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.

    MariaDB 10.2.19 will be a Stable (GA) release.

    For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? 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

    • 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 and restart the server.

    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 .

    MariaDB 10.2.7 Release Notes

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    Download | Release Notes | Changelog | Overview of 10.2

    Release date: 12 Jul 2017

    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.

    MariaDB 10.2.7 is a Stable (GA) release.

    For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

    Notable Changes

    This is the second stable release in the series.

    A file format compatibility bug that was introduced in was fixed in this version of MariaDB. Creating tables with the attribute created InnoDB internal data dictionary records that are incompatible with . and later will write the dictionary records in a format that is compatible with and will also support the malformed metadata from affected 10.2 versions.This may prevent a downgrade to earlier versions.

    • 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.

    Notes

    For a complete list of changes made in , with links to detailed information on each push, see the .

    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 of see the page.

    Thanks, and enjoy MariaDB!

    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 of see the page.

    Thanks, and enjoy MariaDB!

    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 of see the page.

    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.

    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.

    is an release.

    Do not use Alpha releases on production systems!

    For an overview of see the page.

    Thanks, and enjoy MariaDB!

    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.

    is a release.

    Do not use beta releases on production systems!

    For an overview of see the page.

    Thanks, and enjoy MariaDB!

    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 of see the page.

    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.

    MDEV-18025: mariadb-backup fails to detect corrupted page_compressed=1 tables

    MDEV-17923
    MDEV-17904
    MDEV-17938
    MDEV-13564
    MDEV-17780
    MDEV-17816
    MDEV-17849
    MDEV-17851
    MDEV-17885
    MDEV-12112
    MDEV-17958
    MDEV-17957
    Galera library
    subscribing

    CVE-2018-3058

  • CVE-2018-3066

  • MDEV-14637
    MDEV-15953
    MDEV-16515
    MDEV-16809
    MDEV-16713
    MDEV-16596
    MDEV-15855
    MDEV-16664
    MDEV-15822
    Repository Configuration Tool
    CVE-2018-3060
    CVE-2018-3064
    CVE-2018-3063
    subscribing

    MDEV-15249 - Crash in MVCC read after IMPORT TABLESPACE

  • Foreign key bugs:

    • MDEV-15199 - Referential integrity broken in ON DELETE CASCADE / MDEV-14222 Unnecessary 'cascade' memory allocation for every updated row

    • MDEV-15219 - FOREIGN KEY CASCADE or SET NULL operations will not resume after lock wait

    • MDEV-15042 - INSERT ON DUPLICATE KEY UPDATE produces error 1032 (Can't find record)

    • - InnoDB: Failing assertion: !dict_index_is_online_ddl(index) upon ALTER TABLE

  • MDEV-14958 - Merge new release of InnoDB MySQL 5.7.21 to 10.2

  • MDEV-15165 - InnoDB purge for index on virtual column is trying to access an incomplete record

  • MDEV-15143 - InnoDB: Rollback of trx with id 0 completed

  • MDEV-11415 - Remove excessive undo logging during

  • MDEV-15016 - multiple page cleaner threads use a lot of CPU

  • MDEV-14941 - Timeouts on persistent statistics tables caused by MDEV-14511

  • MDEV-14985 - innodb_undo_log_truncate may be blocked if transactions were recovered at startup

  • MDEV-14441 - InnoDB hangs when setting innodb_adaptive_hash_index=OFF during UPDATE

  • MDEV-14887 - On a 32-bit system, MariaDB 10.2 mishandles data file sizes exceeding 4GiB

  • Fedora 27 packages added

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Fedora 25

  • CVE-2018-2665

  • CVE-2018-2668

  • CVE-2018-2612

  • Galera wsrep library
    MDEV-14611
    CVE-2018-2562
    CVE-2018-2622
    CVE-2018-2640
    MariaDB 10.2.13
    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.

    MDEV-15720 - ib_buffer_pool unnecessarily includes the temporary tablespace

  • MDEV-15764 - InnoDB may write uninitialized garbage to redo log

  • MDEV-15553 - Virtual Columns: Assertion failed in dict_table_get_col_name

  • MDEV-14705 - slow innodb startup/shutdown can exceed systemd timeout

  • MDEV-15707 - deadlock in Innodb IO code, caused by change buffering (Windows)

  • MDEV-15507 - Assertion failed in dict_check_sys_tables on upgrade from 5.5

  • MDEV-15916 - Change buffer crash during TRUNCATE or DROP TABLE

  • encryption fixes - MDEV-12632, MDEV-13516, MDEV-15752, MDEV-15566, MDEV-16092

  • temporary table ROLLBACK fixes - MDEV-15826, MDEV-15374

  • applicable changes from 5.7.22 - MDEV-16142

  • 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.

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Debian 7 Wheezy and Fedora 26

  • Fixes for the following :

    • CVE-2018-2755

    • CVE-2018-2759

    • CVE-2018-2761

  • MDEV-15325
    MariaDB 10.2.15
    changelog
    MariaDB 10.2.15
    MariaDB Foundation release announcement

    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-17289: Multi-pass recovery fails to apply some redo log records

  • MDEV-17073: INSERT…ON DUPLICATE KEY UPDATE became more deadlock-prone

  • MDEV-17491: micro optimize page_id_t

  • MDEV-13671: InnoDB should use case-insensitive column name comparisons like the rest of the server

  • Fixes for indexed virtual columns: MDEV-17215, MDEV-16980

  • MDEV-17433: Allow InnoDB start up with empty ib_logfile0 from mariadb-backup --prepare

  • MDEV-12547: InnoDB FULLTEXT index has too strict innodb_ft_result_cache_limit max limit

  • MDEV-17541: KILL QUERY during lock wait in FOREIGN KEY check causes hang

  • MDEV-17531: Crash in RENAME TABLE with FOREIGN KEY and FULLTEXT INDEX

  • MDEV-17532: Performance_schema reports wrong directory for the temporary files of ALTER TABLE…ALGORITHM=INPLACE

  • MDEV-17545: Predicate lock for SPATIAL INDEX should lock non-matching record

  • MDEV-17546: SPATIAL INDEX should not be allowed for FOREIGN KEY

  • MDEV-17548: Incorrect access to off-page column for indexed virtual column

  • MDEV-12023: Assertion failure sym_node->table != NULL on startup

  • MDEV-17230: encryption_key_id from alter is ignored by encryption threads

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Fedora 27

  • Fixes for the following :

    • CVE-2018-3282

    • CVE-2016-9843

    • CVE-2018-3174

  • MDEV-14717
    MDEV-14585
    MDEV-13564
    mariadb-backup
    MariaDB 10.2.16
    MariaDB 10.2.17
    MDEV-14637
    MariaDB 10.2.19
    changelog
    MariaDB 10.2.19
    MariaDB Foundation release announcement

    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-13125: Core dumps can now be enabled dynamically

  • MDEV-13132: Literals in the COLUMN_DEFAULT column in the table are now quoted to distinguish them from expressions.

  • New variables:

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Ubuntu 16.10 "Yakkety"

  • Fixes for the following :

    • CVE-`-```

  • MariaDB 10.2
    MariaDB 10.2.2
    MariaDB 10.1
    MariaDB 10.2.7
    MariaDB 10.1
    MariaDB 10.2
    See the commit for details.
    mariadb-backup
    MDEV-13311
    MariaDB 10.2.7
    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.

    Notable Changes
    • MDEV-19922: updated to 10.2

    • MDEV-19795: Merge upstream .

    • MDEV-17228: Encrypted temporary tables are not encrypted.

    • MDEV-18328: 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.

    Contributors

    For a full list of contributors to MariaDB 10.2.26, see the MariaDB Foundation release announcement.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    Download
    Release Notes
    Changelog
    Overview of 10.2
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.26
    Stable (GA)
    MariaDB 10.2
    What is MariaDB 10.2?

    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.

    Notable Changes

    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.

    • alpha storage engine added (MDEV-9658)

    • have been introduced.

    • Recursive Common Table Expressions (MDEV-9864)

    • added for Windows, CentOS, RHEL, and Fedora packages

    • Update InnoDB to 5.7.18 ()

    • updated to 25.3.20

    • Packages for Ubuntu 17.04 "zesty"

    • : The --add-drop-trigger option has been added to

    • : Ignore XtraDB-specific parameters in InnoDB, warning that they are ignored

    • , : Numerous Encryption fixes

    • : Disabled defragmentation

    • : Added support for OpenSSL 1.1 and LibreSSL

    • and variables introduced

    • : columns are no longer permitted in , and . They were permitted in earlier versions, but did not work correctly.

    • Fixes for the following :

    Notes

    • (as of 2.4) will not work with MariaDB 10.2 (and MariaDB 10.1) compression. However, MariaDB's fork, mariadb-backup, will work with compression. A beta version of mariadb-backup was included in MariaDB 10.2.7 and declared stable in MariaDB 10.2.10.

    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 later MariaDB 10.2 versions to MariaDB 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.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    Download
    Release Notes
    Changelog
    Overview of 10.2
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.6
    Stable (GA)
    MariaDB 10.2
    What is MariaDB 10.2?

    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.

    Thanks, and enjoy MariaDB!

    Notable Changes

    • InnoDB ALTER TABLE fixes: MDEV-18016, MDEV-18630, MDEV-18775, MDEV-18732,MDEV-18749, MDEV-18637, MDEV-13818, MDEV-17595

    • Performance improvements:

      • MDEV-18878: InnoDB Purge: Optimize away futile table lookups

      • : Regression in connect performance

      • : Purge thread fails to exit on shutdown

    • Corruption bug fixes:

      • : 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

      • : mariadb-backup writes timestamp in version line

    • 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

    • Fixes for the following :

      • CVE-`-```

    When upgrading from MariaDB 10.2.16 or earlier to MariaDB 10.2.17 or higher, running is required due to changes introduced inMDEV-14637.

    Changelog

    For a complete list of changes made in MariaDB 10.2.23 with links to detailed information on each push, see the changelog.

    Contributors

    For a full list of contributors to MariaDB 10.2.23, see the MariaDB Foundation release announcement.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    Download
    Release Notes
    Changelog
    Overview of 10.2
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.23
    Stable (GA)
    MariaDB 10.2
    What is MariaDB 10.2?
    MDEV-12837

    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.

    Notable Changes

    This is the second alpha release in the MariaDB 10.2 series.

    • Common Table Expressions -

    • Support for (MDEV-7563).

    • Support for (MDEV-10134).

    • fields can now have a value.

    • Lots of restrictions lifted for .

    • 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.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    Download
    Release Notes
    Changelog
    Overview of 10.2
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.1
    Alpha
    MariaDB 10.2
    What is MariaDB 10.2

    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.

    Notable Changes

    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.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    Download
    Release Notes
    Changelog
    Overview of 10.2
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.2
    Beta
    MariaDB 10.2
    What is MariaDB 10.2?

    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.

    Thanks, and enjoy MariaDB!

    Notable Changes

    • MDEV-12837 - WSREP: BF lock wait long

    • MDEV-14799 - After UPDATE of indexed columns, old values will not be purged from secondary indexes

    • MDEV-12827 - Assertion failure when reporting duplicate key error in online table rebuild

    • MDEV-14008 - Failure reading auto-increment values in DOUBLE column from storage engine

    • - Rollback progress log messages during crash recovery are intermixed with unrelated log messages

    • - InnoDB shutdown should not be blocked by a large transaction rollback

    • - InnoDB may hang if shutdown is initiated soon after startup while rolling back recovered incomplete transactions

    • - Assertion failure in trx_purge_run() on shutdown

    • - InnoDB should not lock a delete-marked record

    • / / - data corruption caused by error log messages ending up in database files or binary logs

    • - Use fewer transactions for updating InnoDB persistent statistics

    • / - Error log flood : "InnoDB: page_cleaner: 1000ms intended loop took N ms. The settings might not be optimal."

    • : - during backup, retry read of log blocks, if there is (possibly intermittent) checksum mismatch

    • As per the , this will be the last release of for Ubuntu 17.04 "Zesty".

    Updates

    • The WINDOW is now only disallowed for table aliases.

    • Fixes for the following :

      • CVE-2018-3133

    Notes

    For a complete list of changes made in MariaDB 10.2.12 with links to detailed information on each push, see the changelog.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    Download
    Release Notes
    Changelog
    Overview of 10.2
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.12
    Stable (GA)
    MariaDB 10.2
    What is MariaDB 10.2?
    MDEV-12837

    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.

    CVE-2017-10320
    CVE-2017-10365
    CVE-2017-10379
    CVE-2017-10384
    CVE-2017-10286
    CVE-2017-3257
    MDEV-20621
    CVE-2021-2144
    MDEV-23569
    MDEV-23832
    MDEV-22330
    MDEV-21839
    MDEV-23534
    MDEV-16372
    MDEV-20744
    MDEV-23938
    MDEV-19838
    MDEV-19443
    MDEV-18366
    MDEV-23989
    MDEV-23452
    MDEV-23370
    MDEV-23456
    MDEV-22924
    MDEV-22277
    MDEV-22939
    MDEV-23685
    MDEV-23722
    MDEV-15180
    MDEV-23867
    MDEV-23811
    MDEV-22626
    MDEV-21578
    MDEV-22543
    CVE-2020-14776
    CVE-2020-14789
    CVE-2020-28912
    MDEV-24040
    CVE-2021-2194
    MDEV-18366
    subscribing
    MDEV-16934
    Galera library
    MDEV-16465
    MDEV-17026
    MDEV-10754
    CVE-2021-2174
    subscribing
    MDEV-21509
    MDEV-21511
    MDEV-21512
    MDEV-21513
    subscribing
    MDEV-19614
    MDEV-17456
    MDEV-19588
    MDEV-19258
    MDEV-16060
    MDEV-19725
    MDEV-18220
    MDEV-19445
    MDEV-17540
    MDEV-19027
    MDEV-19602
    MDEV-13080
    MDEV-19541
    MDEV-19587
    MDEV-19435
    MDEV-11094
    MDEV-19076
    MDEV-19158
    MariaDB Deprecation Policy
    MariaDB 10.2
    subscribing
    subscribing

    MariaDB 10.2.24 Release Notes

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    Download | Release Notes | Changelog | Overview of 10.2

    Release date: 9 May 2019

    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.

    MariaDB 10.2.24 is a Stable (GA) release.

    For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? 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.

    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 .

    MariaDB 10.2.4 Release Notes

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    Download | Release Notes | Changelog | Overview of 10.2

    Release date: 17 Feb 2017

    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.

    MariaDB 10.2.4 is a Release Candidate (RC) release.

    For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

    Thanks, and enjoy MariaDB!

    Notable Changes

    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 .

    CVE-2019-2737

  • CVE-2019-2758

  • CVE-2020-2922

  • CVE-2021-2007

  • MDEV-20102
    MDEV-19292
    MDEV-15641
    MDEV-16222
    MDEV-17005
    MDEV-14154
    MDEV-17228
    MDEV-19914
    MDEV-19660
    MDEV-19978
    MDEV-19871
    MDEV-20091
    MDEV-19421
    MDEV-19427
    MDEV-18661
    MDEV-19771
    MDEV-19595
    MDEV-18328
    MariaDB Deprecation Policy
    MariaDB 10.2
    CVE-2019-2805
    CVE-2019-2740
    CVE-2019-2739
    subscribing

    CVE-2017-3456

  • CVE-2017-3464

  • MDEV-11751
    Galera wsrep library
    added
    MDEV-10431
    MDEV-12472
    MDEV-12253
    MDEV-12602
    MDEV-11336
    MDEV-10332
    innodb_deadlock_detect
    MDEV-11117
    CVE-2017-3308
    CVE-2017-3309
    CVE-2017-3453
    subscribing

    MDEV-18855: mariadb-backup should fetch innodb_compression_level from running server

    MDEV-14984
    MDEV-18936
    MDEV-18272
    MDEV-9519
    mariadb-backup
    MDEV-18204
    MDEV-18611
    MDEV-18669
    MDEV-18893
    Galera library
    MariaDB Deprecation Policy
    MariaDB 10.2
    MariaDB 10.2
    subscribing

    MDEV-18298 - Crashes server with segfault during role grants

  • MDEV-17610 - Unexpected connection abort after certain operations from within stored procedure

  • MDEV-19112 - WITH clause does not work with information_schema as default database

  • MDEV-17830 - Server crashes in Item_null_result::field_type upon SELECT with CHARSET(date) and ROLLUP

  • MDEV-14041 - Server crashes in String::length on queries with functions and ROLLUP

  • MDEV-18920 - Prepared statements with st_convexhull hang and eat 100% cpu.

  • MDEV-15837 - Assertion item1->type() == Item::FIELD_ITEM && item2->type() == Item::FIELD_ITEM

  • MDEV-9531 - GROUP_CONCAT with ORDER BY inside takes a lot of memory while it's executed

  • MDEV-17036 - BULK with replace doesn't take the first parameter in account

  • Bug#28986737 - RENAMING AND REPLACING MYSQL.USER TABLE CAN LEAD TO A SERVER CRASH

  • MDEV-19350 - Server crashes in delete_tree_element / ... / Item_func_group_concat::repack_tree

  • MDEV-19188 - Server Crash When Using a Trigger With A Number of Virtual Columns on INSERT/UPDATE

  • MDEV-19352 - Server crash in alloc_histograms_for_table_share upon query from information schema

  • MDEV-17456 - Malicious SUPER user can possibly change audit log configuration without leaving traces.
  • Fixes for the following :

    • CVE-2019-2614

    • CVE-2019-2627

    • CVE-2019-2628

  • MDEV-18968
    MDEV-18466
    MDEV-18899
    MDEV-19426
    MDEV-19022
    MDEV-19241
    MDEV-13942
    MDEV-18733
    MDEV-12699
    MDEV-19356
    MDEV-19426
    MDEV-14398
    MDEV-17036
    MDEV-14784
    MDEV-19060
    MDEV-19054
    MariaDB 10.2
    MDEV-7066
    MariaDB Deprecation Policy
    MariaDB 10.2
    MDEV-18686
    MDEV-19276
    MariaDB 10.2.16
    MariaDB 10.2.17
    MDEV-14637
    MariaDB 10.2.24
    changelog
    MariaDB 10.2.24
    MariaDB Foundation release announcement

    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.

    Default value of reduced to 60 seconds (MDEV-7635).
  • Default value of changed to 1M (MDEV-7635).

  • Default value of changed to zlib - this does not mean pages are now compressed by default, see (MDEV-11838).

  • Default value of changed to ON (MDEV-7635).

  • Default value of and changed to ON.

  • The unused variables have been removed (MDEV-12050).

  • Numerous other system variable changes.

  • DML_only can rollback instances/databases/tables to an old snapshot (MDEV-10570).

  • Implement and functions so the spatial features can be imported/exported using GeoJSON format (MDEV-11042).

  • for the CONNECT storage engine (MDEV-11295).

  • Persistent for InnoDB (MDEV-6076).

  • Default values of the and system variables changed to BACKUP,QUICK.

  • Support COM_RESET_CONNECTION (MDEV-10340).

  • can now be set to 1 (MDEV-12061).

  • MariaDB now works when started with a MySQL 5.7.6+ data directory. (MDEV-11170)

  • OpenSUSE 42 repositories have been added in this release.

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.2 for Ubuntu 12.04 "precise", Fedora 23, and openSUSE 13

  • Fixes for the following :
    • CVE-`-```

    MariaDB 10.2
    MDEV-7635
    MDEV-7635
    MariaDB 10.2.4
    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.

    MDEV-13205
    CVE-2018-2766
    CVE-2018-2767
    CVE-2018-2771
    CVE-2018-2777
    CVE-2018-2781
    CVE-2018-2782
    CVE-2018-2784
    CVE-2018-2786
    CVE-2018-2787
    CVE-2018-2810
    CVE-2018-2813
    CVE-2018-2817
    CVE-2018-2819
    CVE-2018-3081
    CVE-2019-2455
    CVE-2020-14550
    CVE-2021-2011
    CVE-2018-3143
    CVE-2018-3156
    CVE-2018-3251
    CVE-2018-3185
    CVE-2018-3277
    CVE-2018-3162
    CVE-2018-3173
    CVE-2018-3200
    CVE-2018-3284
    MDEV-3944
    MDEV-10138
    MDEV-5535
    MariaDB Deprecation Policy
    MariaDB 10.2
    subscribing
    MDEV-7901
    MDEV-9765
    MDEV-9872
    MDEV-9055
    MDEV-9864
    MDEV-7563
    MDEV-10134
    MDEV-9197
    MDEV-9711
    MDEV-10296
    MDEV-10297
    MDEV-9526
    MDEV-8091
    MDEV-10059
    subscribing
    MDEV-12323
    MDEV-12352
    MDEV-13797
    MDEV-14422
    MDEV-14589
    MDEV-14714
    MDEV-14488
    MDEV-14644
    MDEV-14511
    MDEV-13670
    MDEV-14550
    mariadb-backup
    MDEV-14536
    MariaDB Deprecation Policy
    MariaDB 10.2
    subscribing

    MariaDB 10.2.0 Release Notes

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    Download | Release Notes | Changelog | Overview of 10.2

    Release date: 18 Apr 2016

    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.

    MariaDB 10.2.0 is an Alpha release.

    Do not use alpha releases on production systems!

    For an overview of MariaDB 10.2 see theWhat is MariaDB 10.2? page.

    Thanks, and enjoy MariaDB!

    Notable Changes

    This is the first alpha release in the 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.

    Scripts:

    • Continuous binary log backup has been added to - .

    • and mysqlbug have been removed - , .

    Information Schema:

    • Added an information schema plugin to report all user variables, which creates the - .

    Variables:

    • has been renamed to - .

    • The server version can now be faked to work around dated applications that require a particular version string -

    • 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 - .

    • now shows sort_key field which shows the sort criteria used by filesort operation. ()

    • EXPLAIN used to show incorrect information about how the optimizer resolved ORDER BY

    Optimizations:

    • Connection setup was made faster by moving creation of THD to new thread ()

    Code:

    • "fast mutexes" have been removed. These aren't faster than normal mutexes, and have been disabled by default for years - .

    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 . 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'.

    • - 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

    Changelog

    For a complete list of changes made in , with links to detailed information on each push, see the .

    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.

    is a release.

    For an overview of see the page.

    Thanks, and enjoy MariaDB!

    New : OVER and RECURSIVE. These can no longer be used as without being quoted.

    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
    ,
    ,
    )

    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:

  • MariaDB 10.2
    MDEV-8713
    MDEV-7376
    MDEV-8654
    MDEV-7331
    aria_recover
    aria_recover_options
    MDEV-8542
    MDEV-7780
    MDEV-9652
    commit 2078392
    MDEV-6150
    MDEV-8111
    repository configuration tool
    MDEV-9781
    MariaDB 10.2.0
    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.

    MDEV-8646
    MDEV-7982
    MDEV-8857
    MDEV-7885
    Notable Changes
    • 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.

    Contributors

    For a full list of contributors to MariaDB 10.2.29, see the MariaDB Foundation release announcement.

    MariaDB 10.2
    MariaDB 10.2.44
    Download Now
    MDEV-21758
    Download
    Release Notes
    Changelog
    Overview of 10.2
    MariaDB 10.2
    MariaDB 10.1
    MariaDB 10.2.29
    Stable (GA)
    MariaDB 10.2
    What is MariaDB 10.2?

    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.

    sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
    subscribing

    MariaDB 10.2 Changes & Improvements

    MariaDB 10.2 is no longer maintained. Please use a more recent release.

    The most recent release of MariaDB 10.2 is:MariaDB 10.2.44 Stable (GA) Download Now

    MariaDB 10.2 is a previous major stable version. The first stable release was in May 2017.

    For details on upgrading from MariaDB 10.1, see .

    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

    • New options for limiting resource usage and tls/ssl

    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.

    • New : OVER, RECURSIVE, and ROWS.

    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 ()

    • and now include the date and time the trigger was created

    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. ()

    • EXPLAIN used to show incorrect information about how the optimizer resolved ORDER BY

    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 ()

    • Internal CRC32 routines use the optimized implementation on Power8 —

    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

    • The server version can now be faked to work around dated applications that require a particular

    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 ()

    • "fast mutexes" have been removed. These aren't faster than normal mutexes, and have been disabled by default for years ()

    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

    New statement

  • (MDEV-9864)

  • 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

  • Support for (MDEV-7563)

  • Support for (MDEV-10134)

  • fields can now have a value

  • Lots of restrictions lifted for

  • Number of supported decimals in has increased from 30 to 38 (MDEV-10138)

  • Added catchall for list partitions (MDEV-8348)

  • Oracle-style statement (MDEV-10585)

  • /Dynamic SQL now understand most expressions (MDEV-10866, MDEV-10709).

  • InnoDB tables now support

  • (MDEV-12160)

  • Better InnoDB crash recovery progress reporting (MDEV-11027)

  • Improvements to InnoDB startup/shutdown to make it more robust

  • added for Windows, CentOS, RHEL, and Fedora packages

  • . Shannon system SSD cards are now supported.

  • is supported (
    ) — Original code from Tencent Game DBA Team, developed by vinchen.
  • Default changed to mixed (MDEV-7635)

  • Default value of changed to ON (MDEV-7635)

  • Default value of reduced to 60 seconds (MDEV-7635)

  • Default changed from 0 to 1

  • clause or
    Distinct
    . This was a long-standing problem with roots back in MySQL. Now, after
    and related fixes, the problem doesn't exist anymore. (For test cases, see
    ,
    ,
    ,
    )
  • Table cache can automatically partition itself as needed to reduce the contention (MDEV-10296)

  • (
    )
  • 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)

  • can now be set to 1 (MDEV-12061)

  • 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 1M (MDEV-7635)

  • 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)

  • Default value of changed to ON from MariaDB 10.1.2 to MariaDB 10.1.25 (MDEV-7635 and MDEV-13247)

  • Default value of and changed to ON

  • 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).

  • 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)

  • CVE-2022-27387: MariaDB 10.2.44

  • CVE-2022-27386: MariaDB 10.2.44

  • CVE-2022-27384: MariaDB 10.2.44

  • CVE-2022-27383: MariaDB 10.2.44

  • CVE-2022-27381: MariaDB 10.2.44

  • CVE-2022-27380: MariaDB 10.2.44

  • CVE-2022-27378: MariaDB 10.2.44

  • CVE-2022-27377: MariaDB 10.2.44

  • CVE-2022-24052: MariaDB 10.2.42

  • CVE-2022-24051: MariaDB 10.2.42

  • CVE-2022-24050: MariaDB 10.2.42

  • CVE-2022-24048: MariaDB 10.2.42

  • CVE-2022-21595: MariaDB 10.2.42

  • CVE-2022-21451: MariaDB 10.2.38

  • CVE-2022-21427: MariaDB 10.2.44

  • CVE-2022-0778: MariaDB 10.2.42

  • CVE-2021-46669: MariaDB 10.2.44

  • CVE-2021-46668: MariaDB 10.2.43

  • CVE-2021-46667: MariaDB 10.2.41

  • CVE-2021-46666: MariaDB 10.2.39

  • CVE-2021-46665: MariaDB 10.2.43

  • CVE-2021-46664: MariaDB 10.2.43

  • CVE-2021-46663: MariaDB 10.2.43

  • CVE-2021-46661: MariaDB 10.2.43

  • CVE-2021-46659: MariaDB 10.2.42

  • CVE-2021-46658: MariaDB 10.2.40

  • CVE-2021-46657: MariaDB 10.2.39

  • CVE-2021-35604: MariaDB 10.2.41

  • CVE-2021-27928: MariaDB 10.2.37

  • CVE-2021-2389: MariaDB 10.2.40

  • CVE-2021-2372: MariaDB 10.2.40

  • CVE-2021-2194: MariaDB 10.2.35

  • CVE-2021-2180: MariaDB 10.2.38

  • CVE-2021-2174: MariaDB 10.2.18

  • CVE-2021-2166: MariaDB 10.2.38

  • CVE-2021-2154: MariaDB 10.2.38

  • CVE-2021-2144: MariaDB 10.2.28

  • CVE-2021-2022: MariaDB 10.2.33

  • CVE-2021-2011: MariaDB 10.2.15

  • CVE-2021-2007: MariaDB 10.2.26

  • CVE-2020-2922: MariaDB 10.2.26

  • CVE-2020-28912: MariaDB 10.2.35

  • CVE-2020-2814: MariaDB 10.2.32

  • CVE-2020-2812: MariaDB 10.2.32

  • CVE-2020-2780: MariaDB 10.2.28

  • CVE-2020-2760: MariaDB 10.2.32

  • CVE-2020-2752: MariaDB 10.2.32

  • CVE-2020-2574: MariaDB 10.2.31

  • CVE-2020-15180: MariaDB 10.2.34

  • CVE-2020-14812: MariaDB 10.2.35

  • CVE-2020-14789: MariaDB 10.2.35

  • CVE-2020-14776: MariaDB 10.2.35

  • CVE-2020-14765: MariaDB 10.2.35

  • CVE-2020-14550: MariaDB 10.2.15

  • CVE-2020-13249: MariaDB 10.2.32

  • CVE-2019-2974: MariaDB 10.2.28

  • CVE-2019-2938: MariaDB 10.2.28

  • CVE-2019-2805: MariaDB 10.2.26

  • CVE-2019-2758: MariaDB 10.2.26

  • CVE-2019-2740: MariaDB 10.2.26

  • CVE-2019-2739: MariaDB 10.2.26

  • CVE-2019-2737: MariaDB 10.2.26

  • CVE-2019-2628: MariaDB 10.2.24

  • CVE-2019-2627: MariaDB 10.2.24

  • CVE-2019-2614: MariaDB 10.2.24

  • CVE-2019-2537: MariaDB 10.2.22

  • CVE-2019-2510: MariaDB 10.2.22

  • CVE-2019-2503: MariaDB 10.2.18

  • CVE-2019-2455: MariaDB 10.2.15

  • CVE-2018-3284: MariaDB 10.2.19

  • CVE-2018-3282: MariaDB 10.2.19

  • CVE-2018-3277: MariaDB 10.2.19

  • CVE-2018-3251: MariaDB 10.2.19

  • CVE-2018-3200: MariaDB 10.2.19

  • CVE-2018-3185: MariaDB 10.2.19

  • CVE-2018-3174: MariaDB 10.2.19

  • CVE-2018-3173: MariaDB 10.2.19

  • CVE-2018-3162: MariaDB 10.2.19

  • CVE-2018-3156: MariaDB 10.2.19

  • CVE-2018-3143: MariaDB 10.2.19

  • CVE-2018-3133: MariaDB 10.2.12

  • CVE-2018-3081: MariaDB 10.2.15

  • CVE-2018-3066: MariaDB 10.2.17

  • CVE-2018-3064: MariaDB 10.2.17

  • CVE-2018-3063: MariaDB 10.2.17

  • CVE-2018-3060: MariaDB 10.2.17

  • CVE-2018-3058: MariaDB 10.2.17

  • CVE-2018-2819: MariaDB 10.2.15

  • CVE-2018-2817: MariaDB 10.2.15

  • CVE-2018-2813: MariaDB 10.2.15

  • CVE-2018-2810: MariaDB 10.2.15

  • CVE-2018-2787: MariaDB 10.2.15

  • CVE-2018-2786: MariaDB 10.2.15

  • CVE-2018-2784: MariaDB 10.2.15

  • CVE-2018-2782: MariaDB 10.2.15

  • CVE-2018-2781: MariaDB 10.2.15

  • CVE-2018-2777: MariaDB 10.2.15

  • CVE-2018-2771: MariaDB 10.2.15

  • CVE-2018-2767: MariaDB 10.2.15

  • CVE-2018-2766: MariaDB 10.2.15

  • CVE-2018-2761: MariaDB 10.2.15

  • CVE-2018-2759: MariaDB 10.2.15

  • CVE-2018-2755: MariaDB 10.2.15

  • CVE-2018-2668: MariaDB 10.2.13

  • CVE-2018-2665: MariaDB 10.2.13

  • CVE-2018-2640: MariaDB 10.2.13

  • CVE-2018-2622: MariaDB 10.2.13

  • CVE-2018-2612: MariaDB 10.2.13

  • CVE-2018-2562: MariaDB 10.2.13

  • CVE-2017-3653: MariaDB 10.2.8

  • CVE-2017-3641: MariaDB 10.2.8

  • CVE-2017-3636: MariaDB 10.2.8

  • CVE-2017-3464: MariaDB 10.2.6

  • CVE-2017-3456: MariaDB 10.2.6

  • CVE-2017-3453: MariaDB 10.2.6

  • CVE-2017-3313: MariaDB 10.2.5

  • CVE-2017-3309: MariaDB 10.2.6

  • CVE-2017-3308: MariaDB 10.2.6

  • CVE-2017-3302: MariaDB 10.2.5

  • CVE-2017-3257: MariaDB 10.2.8

  • CVE-2017-15365: MariaDB 10.2.10

  • CVE-2017-10384: MariaDB 10.2.8

  • CVE-2017-10379: MariaDB 10.2.8

  • CVE-2017-10378: MariaDB 10.2.10

  • CVE-2017-10365: MariaDB 10.2.8

  • CVE-2017-10320: MariaDB 10.2.8

  • CVE-2017-10286: MariaDB 10.2.8

  • CVE-2017-10268: MariaDB 10.2.10

  • CVE-2016-9843: MariaDB 10.2.19

  • Function Differences Between MariaDB 10.2 and MySQL 5.6

    Stable (GA)

    8 Nov 2021

    Stable (GA)

    6 Aug 2021

    Stable (GA)

    23 Jun 2021

    Stable (GA)

    7 May 2021

    Stable (GA)

    22 Feb 2021

    Stable (GA)

    11 Nov 2020

    Stable (GA)

    3 Nov 2020

    Stable (GA)

    7 Oct 2020

    Stable (GA)

    10 Aug 2020

    Stable (GA)

    12 May 2020

    Stable (GA)

    28 Jan 2020

    Stable (GA)

    11 Dec 2019

    Stable (GA)

    8 Nov 2019

    Stable (GA)

    5 Nov 2019

    Stable (GA)

    11 Sep 2019

    Stable (GA)

    31 Jul 2019

    Stable (GA)

    17 Jun 2019

    Stable (GA)

    9 May 2019

    Stable (GA)

    25 Mar 2019

    Stable (GA)

    11 Feb 2019

    Stable (GA)

    2 Jan 2019

    Stable (GA)

    24 Dec 2018

    Stable (GA)

    19 Nov 2018

    Stable (GA)

    25 Sep 2018

    Stable (GA)

    14 Aug 2018

    Stable (GA)

    26 Jun 2018

    Stable (GA)

    17 May 2018

    Stable (GA)

    27 Mar 2018

    Stable (GA)

    13 Feb 2018

    Stable (GA)

    4 Jan 2018

    Stable (GA)

    28 Nov 2017

    Stable (GA)

    31 Oct 2017

    Stable (GA)

    27 Sep 2017

    Stable (GA)

    18 Aug 2017

    Stable (GA)

    12 Jul 2017

    Stable (GA)

    23 May 2017

    Stable (GA)

    5 Apr 2017

    RC

    17 Feb 2017

    RC

    24 Dec 2016

    Beta

    27 Sep 2016

    Beta

    4 Jul 2016

    Alpha

    18 Apr 2016

    Alpha

    20 May 2022

    MariaDB 10.2.44

    Stable (GA)

    Release Notes

    Changelog

    12 Feb 2022

    MariaDB 10.2.43

    Stable (GA)

    Release Notes

    Changelog

    MariaDB 10.1
    MariaDB 10.2
    maturity level
    MariaDB 10.2.14
    MDEV-9658
    MDEV-6112
    MDEV-10915
    MDEV-10570
    MDEV-11064
    MDEV-7145
    MDEV-9143
    MDEV-11042
    MDEV-7331
    MDEV-13132
    MDEV-9255
    MDEV-9652
    commit 2078392
    MDEV-6150
    MDEV-9197
    MDEV-7901
    MDEV-9872
    MDEV-9711
    MDEV-11170
    MDEV-11295
    MDEV-9765
    MDEV-8542
    MDEV-8713
    MDEV-7376
    MDEV-8654
    MDEV-10332
    MDEV-6076
    MDEV-10340
    MDEV-8111
    MariaDB 10.2
    CVE-2022-32088
    MariaDB 10.2.44
    CVE-2022-32083
    MariaDB 10.2.44
    CVE-2022-31624
    MariaDB 10.2.41
    CVE-2022-27445
    MariaDB 10.2.44
    Incompatibilities and Feature Differences Between MariaDB 10.2 and MySQL 5.7
    System Variable Differences Between MariaDB 10.2 and MySQL 5.7
    Function Differences Between MariaDB 10.2 and MySQL 5.7
    System Variable Differences Between MariaDB 10.2 and MySQL 5.6
    MariaDB 10.2
    10.2 Features/fixes by vote (JIRA)

    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.

    9 Feb 2022

    MDEV-11065
    MDEV-8646
    MDEV-7982
    MDEV-8857
    MDEV-7885
    MDEV-326
    MDEV-7780
    MariaDB 10.2.42
    Release Notes
    Changelog
    MariaDB 10.2.41
    Release Notes
    Changelog
    MariaDB 10.2.40
    Release Notes
    Changelog
    MariaDB 10.2.39
    Release Notes
    Changelog
    MariaDB 10.2.38
    Release Notes
    Changelog
    MariaDB 10.2.37
    Release Notes
    Changelog
    MariaDB 10.2.36
    Release Notes
    Changelog
    MariaDB 10.2.35
    Release Notes
    Changelog
    MariaDB 10.2.34
    Release Notes
    Changelog
    MariaDB 10.2.33
    Release Notes
    Changelog
    MariaDB 10.2.32
    Release Notes
    Changelog
    MariaDB 10.2.31
    Release Notes
    Changelog
    MariaDB 10.2.30
    Release Notes
    Changelog
    MariaDB 10.2.29
    Release Notes
    Changelog
    MariaDB 10.2.28
    Release Notes
    Changelog
    MariaDB 10.2.27
    Release Notes
    Changelog
    MariaDB 10.2.26
    Release Notes
    Changelog
    MariaDB 10.2.25
    Release Notes
    Changelog
    MariaDB 10.2.24
    Release Notes
    Changelog
    MariaDB 10.2.23
    Release Notes
    Changelog
    MariaDB 10.2.22
    Release Notes
    Changelog
    MariaDB 10.2.21
    Release Notes
    Changelog
    MariaDB 10.2.20
    Release Notes
    Changelog
    MariaDB 10.2.19
    Release Notes
    Changelog
    MariaDB 10.2.18
    Release Notes
    Changelog
    MariaDB 10.2.17
    Release Notes
    Changelog
    MariaDB 10.2.16
    Release Notes
    Changelog
    MariaDB 10.2.15
    Release Notes
    Changelog
    MariaDB 10.2.14
    Release Notes
    Changelog
    MariaDB 10.2.13
    Release Notes
    Changelog
    MariaDB 10.2.12
    Release Notes
    Changelog
    MariaDB 10.2.11
    Release Notes
    Changelog
    MariaDB 10.2.10
    Release Notes
    Changelog
    MariaDB 10.2.9
    Release Notes
    Changelog
    MariaDB 10.2.8
    Release Notes
    Changelog
    MariaDB 10.2.7
    Release Notes
    Changelog
    MariaDB 10.2.6
    Release Notes
    Changelog
    MariaDB 10.2.5
    Release Notes
    Changelog
    MariaDB 10.2.4
    Release Notes
    Changelog
    MariaDB 10.2.3
    Release Notes
    Changelog
    MariaDB 10.2.2
    Release Notes
    Changelog
    MariaDB 10.2.1
    Release Notes
    Changelog
    MariaDB 10.2.0
    Release Notes
    Changelog
    mysqld --wsrep_recover
    wsrep_provider
    wsrep_notify_cmd
    Galera rsync SST
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    security vulnerabilities
    mysql_upgrade
    security vulnerabilities
    mysql_upgrade
    events
    HeidiSQL
    mysql_upgrade
    mysqldump
    mysql-test-run
    security vulnerabilities
    security vulnerabilities
    mysql_upgrade
    security vulnerabilities
    mysql_upgrade
    CONNECT
    CONNECT
    mysql_upgrade
    security vulnerabilities
    mariadb-upgrade
    security vulnerabilities
    mysql_upgrade
    InnoDB persistent stats
    mysqldump --system
    security vulnerabilities
    mysql_upgrade
    --skip-symbolic-links
    mariadb_repo_setup
    security vulnerabilities
    mysql_upgrade
    innodb_encryption_threads
    max_sort_length
    data types
    DOUBLE
    BIGINT
    InnoDB
    div_precision_increment
    div_precision_increment
    mysql_upgrade
    security vulnerabilities
    ST_DISTANCE_SPHERE
    server_audit_events
    MariaDB Audit Plugin - Log Settings
    security vulnerabilities
    mysql_upgrade
    CONNECT
    CONNECT
    ALTER DATABASE
    slave_ddl_exec_mode=IDEMPOTENT
    DROP DATABASE
    mysql_upgrade
    ALTER
    security vulnerabilities
    Connect
    mysql_upgrade
    security vulnerabilities
    Replication unsafe
    INSERT .. ON DUPLICATE KEY UPDATE
    MIXED format binlogging
    Replication unsafe
    INSERT .. ON DUPLICATE KEY UPDATE
    MIXED binlog format
    security vulnerabilities
    mysql_upgrade
    mysqlbinlog --stop-never --raw
    InnoDB
    TokuDB
    CONNECT
    MongoDB
    ST_GeomFromGeoJSON
    ST_AsGeoJSON
    ALTER TABLE
    Numeric Data Type Overview
    security vulnerabilities
    TokuDB
    innodb_encrypt_log
    innodb_mtflush_threads
    innodb_use_mtflush
    security vulnerabilities
    security vulnerabilities
    mysql_upgrade
    TokuDB
    PCRE
    ed25519 authentication plugin
    systemd
    MyRocks
    AWS Key Management plugin
    Information Schema COLUMNS
    generated (virtual, or computed)
    security vulnerabilities
    MyRocks
    security vulnerabilities
    innodb_change_buffer_dump
    mysql_upgrade
    security vulnerabilities
    HeidiSQL
    Information Schema CHECK_CONSTRAINTS Table
    table_definition_cache
    mysql_upgrade
    security vulnerabilities
    Mroonga
    security vulnerabilities
    InnoDB
    CONNECT
    INFORMATION_SCHEMA.INNODB_SYS_TABLESTATS
    ALTER
    DROP
    TRUNCATE TABLE
    FULLTEXT INDEX
    ROW_FORMAT=COMPRESSED
    innodb_defragment
    security vulnerabilities
    MyRocks
    DISKS plugin
    ALTER TABLE EXCHANGE PARTITION
    innodb_prefix_index_cluster_optimization
    IMPORT TABLESPACE
    UNINSTALL PLUGIN
    innodb_read_only
    DROP TABLE
    FULLTEXT index
    security vulnerabilities
    innodb_log_optimize_ddl
    BLACKHOLE Storage Engine
    Calculating (auto rounding)
    security vulnerabilities
    mysql_upgrade
    Geometry types
    mysqlbinlog
    SHOW BINLOG EVENTS
    replicate_do_table
    mysqlbinlog
    SET GLOBAL replicate_do_db = DEFAULT
    User killed queries
    server_audit plugin
    InnoDB
    ALTER TABLE
    NTH_VALUE
    window functions
    --encrypt-tmp_files=ON
    CREATE OR REPLACE TRIGGER
    mysql_upgrade
    security vulnerabilities
    security vulnerabilities
    mysql_upgrade
    eq_range_index_dive_limit
    innodb_log_optimize_ddl
    core_file
    InnoDB
    mysql_upgrade
    security vulnerabilities
    security vulnerabilities
    mysql_upgrade
    JSON_MERGE_PATCH
    JSON_MERGE_PRESERVE
    mysql_upgrade
    security vulnerabilities
    HeidiSQL
    read_binlog_speed_limit
    Delayed replication
    Compression of events in the binary log
    JSON functions
    EXECUTE IMMEDIATE
    PREPARE Statement
    triggers
    CREATE TRIGGER
    SHOW TRIGGERS
    SHOW CREATE TRIGGER
    security vulnerabilities
    InnoDB
    MyRocks
    security vulnerabilities
    ALTER TABLE…ALGORITHM=COPY
    InnoDB
    PCRE
    security vulnerabilities
    innodb_safe_truncate
    XtraBackup
    mysql_upgrade
    security vulnerabilities
    page_compressed=yes
    JSON data type
    InnoDB
    TokuDB
    Information Schema COLUMNS
    tmp_disk_table_size
    tmp_memory_table_size
    security vulnerabilities
    HeidiSQL
    MyRocks
    Disks Plugin
    FILE privilege
    mysql_upgrade
    InnoDB Row Formats Overview: Upgrading Causes Row Size Too Large Errors
    security vulnerabilities
    MyRocks
    Window functions
    AWS Key Management plugin
    Percona XtraBackup
    page_compressed=yes
    mysqldump
    innodb_stats_include_delete_marked
    Auto_increment
    CHECK constraints
    DEFAULT value expressions
    virtual columns
    security vulnerabilities
    mysql_upgrade
    security vulnerabilities
    WITH
    CHECK CONSTRAINT
    DEFAULT with expressions
    BLOB and TEXT
    DEFAULT
    Virtual computed columns
    DECIMAL
    innodb_tmpdir
    XtraDB
    Innodb
    Performance Schema
    PCRE library
    TokuDB
    HeidiSQL
    binlog_checksum
    InnoDB
    innodb_strict_mode
    spatial indexes
    ANALYZE TABLE
    JDBC Table type
    pushed down into non-mergeable views/derived tables
    collations
    thread_pool_prio_kickup_timer
    thread_pool_priority
    window functions
    LEAD
    LAG
    NTH_VALUE
    FIRST_VALUE
    LAST_VALUE
    server_id
    innochecksum
    security vulnerabilities
    reserved word
    security vulnerabilities
    src.rpm packages
    some platforms
    mysql_upgrade
    security vulnerabilities
    reserved word
    identifier
    binary log format
    replicate_annotate_row_events
    binlog_annotate_row_events
    innodb_have_punch_hole
    innodb_pages0read
    innodb_scrub_log
    innodb_encryption_num_key_requests
    slave_net_timeout
    group_concat_max_len
    innodb_compression_algorithm
    compression
    innodb_log_compressed_pages
    innodb_use_atomic_writes
    innodb_use_trim
    innodb_api_*
    flashback
    ST_AsGeoJSON
    ST_GeomFromGeoJSON
    Zipped File Tables
    AUTO_INCREMENT
    aria_recover
    myisam_recover_options
    innodb_log_files_in_group
    security vulnerabilities
    Window functions
    SHOW CREATE USER
    CREATE USER
    ALTER USER
    mysqlbinlog
    mysql_zap
    Information Schema USER_VARIABLES Table
    slave_parallel_workers
    com_alter_user
    com_multi
    com_show_create_user
    EXPLAIN FORMAT=JSON
    EXPLAN FORMAT=JSON
    reserved-words
    identifier-names
    security vulnerabilities
    mysql_upgrade
    Upgrading from MariaDB 10.1 to 10.2
    InnoDB
    Why does MariaDB 10.2 use InnoDB instead of XtraDB?
    MyRocks
    Window functions
    SHOW CREATE USER
    CREATE USER
    TokuDB
    SQL_MODE
    binlog_checksum
    reserved words
    triggers
    CREATE TRIGGER
    SHOW TRIGGERS
    SHOW CREATE TRIGGER
    flashback
    read_binlog_speed_limit
    Delayed replication
    JSON data type
    JSON functions
    ST_AsGeoJSON
    ST_GeomFromGeoJSON
    Information Schema USER_VARIABLES Table
    Information Schema COLUMNS
    generated (virtual, or computed)
    EXPLAIN FORMAT=JSON
    EXPLAIN FORMAT=JSON
    condition-pushdown-into-derived-table-optimization
    ANALYZE TABLE
    NO PAD collations
    Zipped File Tables
    JDBC Table type
    System Variables Added in MariaDB 10.2
    innodb_deadlock_detect
    aria_recover
    aria_recover_options
    aria_recover
    myisam_recover_options
    Status Variables Added in MariaDB 10.2
    mysqlbinlog
    mysql_zap
    AUTO_INCREMENT
    Security Vulnerabilities Fixed in MariaDB
    Getting, Installing, and Upgrading MariaDB
    ALTER USER
    Non-recursive Common Table Expressions
    Recursive Common Table Expressions
    WITH
    CHECK CONSTRAINT
    DEFAULT with expressions
    BLOB and TEXT
    DEFAULT
    Virtual computed columns
    DECIMAL
    EXECUTE IMMEDIATE
    PREPARE Statement
    spatial indexes
    ed25519 authentication plugin
    AWS Key Management plugin
    Atomic writes support made more general
    Compression of events in the binary log
    binary log format
    replicate_annotate_row_events
    slave_net_timeout
    server_id
    version string
    slave_parallel_workers
    com_alter_user
    com_multi
    com_show_create_user
    innodb_tmpdir
    read_binlog_speed_limit
    innodb_log_files_in_group
    thread_pool_prio_kickup_timer
    thread_pool_priority
    group_concat_max_len
    sql_mode
    innodb_compression_algorithm
    compression
    innodb_log_compressed_pages
    innodb_use_atomic_writes
    innodb_use_trim
    innodb_api_*
    tmp_disk_table_size
    tmp_memory_table_size
    tmp_table_size
    innodb_fast_shutdown

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL