> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/release-notes/community-server/old-releases/10.2/10.2.6.md).

# MariaDB 10.2.6 Release Notes

The most recent release of [MariaDB 10.2](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md) is:[**MariaDB 10.2.44**](/docs/release-notes/community-server/old-releases/10.2/10.2.44.md) Stable (GA) [Download Now](https://downloads.mariadb.org/mariadb/10.2.44/)

[Download](https://downloads.mariadb.org/mariadb/10.2.6) | [Release Notes](/docs/release-notes/community-server/old-releases/10.2/10.2.6.md) | [Changelog](/docs/release-notes/community-server/changelogs/changelogs-mariadb-102-series/mariadb-1026-changelog.md) | [Overview of 10.2](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md)

**Release date:** 23 May 2017

[MariaDB 10.2](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md) is the current stable series of MariaDB. It is an evolution of [MariaDB 10.1](/docs/release-notes/community-server/old-releases/10.1/changes-improvements-in-mariadb-10-1.md) 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.6](/docs/release-notes/community-server/old-releases/10.2/10.2.6.md) is a [***Stable (GA)***](/docs/release-notes/community-server/about/release-criteria.md) release.

**For an overview of** [**MariaDB 10.2**](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md) **see the**[**What is MariaDB 10.2?**](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md) **page.**

Thanks, and enjoy MariaDB!

## Notable Changes

This is the first stable release in the [MariaDB 10.2](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md) series. As such, please refer to the [What is MariaDB 10.2?](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md) page for details on all of the new features.

* [MyRocks](/docs/server/server-usage/storage-engines/myrocks/building-myrocks-in-mariadb.md) alpha storage engine added ([MDEV-9658](https://jira.mariadb.org/browse/MDEV-9658))
* [Window functions](/docs/server/reference/sql-functions/special-functions/window-functions.md) have been introduced.
* Recursive Common Table Expressions ([MDEV-9864](https://jira.mariadb.org/browse/MDEV-9864))
* [AWS Key Management plugin](/docs/server/security/encryption/data-at-rest-encryption/key-management-and-encryption-plugins/aws-key-management-encryption-plugin.md) added for Windows, CentOS, RHEL, and Fedora packages
* Update InnoDB to 5.7.18 ([MDEV-11751](https://jira.mariadb.org/browse/MDEV-11751))
* [Galera wsrep library](https://mariadb.com/docs/galera-cluster/) updated to 25.3.20
* Packages for Ubuntu 17.04 "zesty" [added](https://downloads.mariadb.org/mariadb/repositories/)
* [MDEV-10431](https://jira.mariadb.org/browse/MDEV-10431): The `--add-drop-trigger` option has been added to mysqldump
* [MDEV-12472](https://jira.mariadb.org/browse/MDEV-12472): Ignore XtraDB-specific parameters in InnoDB, warning that they are ignored
* [MDEV-12253](https://jira.mariadb.org/browse/MDEV-12253), [MDEV-12602](https://jira.mariadb.org/browse/MDEV-12602): Numerous Encryption fixes
* [MDEV-11336](https://jira.mariadb.org/browse/MDEV-11336): Disabled defragmentation
* [MDEV-10332](https://jira.mariadb.org/browse/MDEV-10332): Added support for OpenSSL 1.1 and LibreSSL
* [innodb\_deadlock\_detect](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_deadlock_detect) and [innodb\_stats\_include\_delete\_marked](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md) variables introduced
* [MDEV-11117](https://jira.mariadb.org/browse/MDEV-11117): [Auto\_increment](/docs/server/reference/data-types/auto_increment.md) columns are no longer permitted in [CHECK constraints](/docs/server/reference/sql-statements/data-definition/constraint.md), [DEFAULT value expressions](/docs/server/server-usage/tables/create-table.md#default-column-option) and [virtual columns](/docs/server/reference/sql-statements/data-definition/create/generated-columns.md). They were permitted in earlier versions, but did not work correctly.
* Fixes for the following [security vulnerabilities](/docs/server/security/cve.md):
  * [CVE-2017-3308](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2017-3308)
  * [CVE-2017-3309](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2017-3309)
  * [CVE-2017-3453](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2017-3453)
  * [CVE-2017-3456](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2017-3456)
  * [CVE-2017-3464](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2017-3464)

## Notes

* Percona XtraBackup (as of 2.4) will not work with [MariaDB 10.2](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md) (and [MariaDB 10.1](/docs/release-notes/community-server/old-releases/10.1/changes-improvements-in-mariadb-10-1.md)) compression. However, MariaDB's fork, [mariadb-backup](https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup), will work with compression. A beta version of mariadb-backup was included in [MariaDB 10.2.7](/docs/release-notes/community-server/old-releases/10.2/10.2.7.md) and declared stable in [MariaDB 10.2.10](/docs/release-notes/community-server/old-releases/10.2/10.2.10.md).

A file format compatibility bug that was introduced in [MariaDB 10.2.2](/docs/release-notes/community-server/old-releases/10.2/10.2.2.md) was present in this release.\
Creating tables with the attribute [page\_compressed=yes](/docs/server/server-usage/storage-engines/innodb/innodb-page-compression.md) created InnoDB internal data dictionary records that are incompatible with [MariaDB 10.1](/docs/release-notes/community-server/old-releases/10.1/changes-improvements-in-mariadb-10-1.md). [MariaDB 10.2.7](/docs/release-notes/community-server/old-releases/10.2/10.2.7.md) and later will write the dictionary records in a format that is compatible with [MariaDB 10.1](/docs/release-notes/community-server/old-releases/10.1/changes-improvements-in-mariadb-10-1.md) and will also support the malformed metadata from affected 10.2 versions.**This bug may prevent a downgrade from later** [**MariaDB 10.2**](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md) **versions to** [**MariaDB 10.2.6**](/docs/release-notes/community-server/old-releases/10.2/10.2.6.md)**.**[See the commit for details.](https://github.com/MariaDB/server/commit/72378a25830184f91005be7e80cfb28381c79f23)

## Changelog

For a complete list of changes made in [MariaDB 10.2.6](/docs/release-notes/community-server/old-releases/10.2/10.2.6.md), with links to detailed information on each push, see the [changelog](/docs/release-notes/community-server/changelogs/changelogs-mariadb-102-series/mariadb-1026-changelog.md).

{% hint style="info" %}
Be notified of new MariaDB Server releases automatically by [subscribing](https://lists.mariadb.org/postorius/lists/announce.lists.mariadb.org/) to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.

MariaDB may already be included in your favorite OS distribution. More information can be found on the [Distributions which Include MariaDB](/docs/general-resources/distributions-including-mariadb.md) page.
{% endhint %}

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formid="4316" formId="4316" %}