> 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.35.md). # MariaDB 10.2.35 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 10.2.35](https://downloads.mariadb.org/mariadb/10.2.35/) | [Release Notes](/docs/release-notes/community-server/old-releases/10.2/10.2.35.md) | [Changelog](/docs/release-notes/community-server/changelogs/changelogs-mariadb-102-series/mariadb-10235-changelog.md) | [Overview of 10.2](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md) **Release date:** 3 Nov 2020 [MariaDB 10.2](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md) is a previous 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.35](/docs/release-notes/community-server/old-releases/10.2/10.2.35.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 * Set the default value of [innodb\_log\_optimize\_ddl](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_log_optimize_ddl) to `OFF` by default ([MDEV-23720](https://jira.mariadb.org/browse/MDEV-23720)) * [BLACKHOLE Storage Engine](/docs/server/server-usage/storage-engines/blackhole.md) maximum index size increased from 1000 to 3500 bytes ([MDEV-24017](https://jira.mariadb.org/browse/MDEV-24017)) * [Calculating (auto rounding)](/docs/server/server-management/variables-and-modes/server-system-variables.md#div_precision_increment) issue ([MDEV-23702](https://jira.mariadb.org/browse/MDEV-23702)) * Temporary tables can no longer overwrite existing files. Instead an error is returned should a conflict occur ([MDEV-23569](https://jira.mariadb.org/browse/MDEV-23569)) * Binlog checksum verification at recovery time ([MDEV-23832](https://jira.mariadb.org/browse/MDEV-23832)) * Verbose print-out of [Geometry types](/docs/server/reference/sql-structure/geometry/geometry-types.md) by [mysqlbinlog](/docs/server/clients-and-utilities/logging-tools/mariadb-binlog.md) ([MDEV-22330](https://jira.mariadb.org/browse/MDEV-22330)) * [SHOW BINLOG EVENTS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-binlog-events.md) from validates when binlog checksummed ([MDEV-21839](https://jira.mariadb.org/browse/MDEV-21839)) * Freeing memory of [replicate\_do\_table](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#replicate_do_table) ([MDEV-23534](https://jira.mariadb.org/browse/MDEV-23534)) * Corrected verbose [mysqlbinlog](/docs/server/clients-and-utilities/logging-tools/mariadb-binlog.md) output for multi-record Rows-log-event ([MDEV-16372](https://jira.mariadb.org/browse/MDEV-16372)) * [SET GLOBAL replicate\_do\_db = DEFAULT](/docs/server/ha-and-performance/standard-replication/replication-and-binary-log-system-variables.md#replicate_do_db) no longer causes crash ([MDEV-20744](https://jira.mariadb.org/browse/MDEV-20744)) * [User killed queries](/docs/server/reference/sql-statements/administrative-sql-statements/kill.md) that were running an index condition pushdown in InnoDB will now return an error ([MDEV-23938](https://jira.mariadb.org/browse/MDEV-23938)) * Wrong direxec param data caused crash; Numerous fixes about Mac builds (by Dmitri Shulga) ([MDEV-19838](https://jira.mariadb.org/browse/MDEV-19838)) * [server\_audit plugin](/docs/server/reference/plugins/mariadb-audit-plugin.md) now logs proxy users ([MDEV-19443](https://jira.mariadb.org/browse/MDEV-19443)) * Crash on SELECT on a table with indexed virtual columns ([MDEV-18366](https://jira.mariadb.org/browse/MDEV-18366)) * [InnoDB](/docs/server/server-usage/storage-engines/innodb.md) updated to 5.7.32 ([MDEV-23989](https://jira.mariadb.org/browse/MDEV-23989)) * Bug fixes related to adaptive hash index ([MDEV-23452](https://jira.mariadb.org/browse/MDEV-23452), [MDEV-23370](https://jira.mariadb.org/browse/MDEV-23370)) * Fixed a bug in the recovery of encrypted tables ([MDEV-23456](https://jira.mariadb.org/browse/MDEV-23456)) * Fixed a race condition in MVCC reads ([MDEV-22924](https://jira.mariadb.org/browse/MDEV-22924)) * [ALTER TABLE](/docs/server/reference/sql-statements/data-definition/alter/alter-table.md) fixes ([MDEV-22277](https://jira.mariadb.org/browse/MDEV-22277), [MDEV-22939](https://jira.mariadb.org/browse/MDEV-22939), [MDEV-23685](https://jira.mariadb.org/browse/MDEV-23685), [MDEV-23722](https://jira.mariadb.org/browse/MDEV-23722)) * Fixed a crash with the [NTH\_VALUE](/docs/server/reference/sql-functions/special-functions/window-functions/nth_value.md) function ([MDEV-15180](https://jira.mariadb.org/browse/MDEV-15180)) * Computing certain [window functions](/docs/server/reference/sql-functions/special-functions/window-functions.md) on a server started with [--encrypt-tmp\_files=ON](/docs/server/server-management/variables-and-modes/server-system-variables.md#encrypt_tmp_files) could cause a wrong query result or crash ([MDEV-23867](https://jira.mariadb.org/browse/MDEV-23867)) * A query with a certain form of WHERE clause over a table with multiple indexes could pick a less efficient range plan ([MDEV-23811](https://jira.mariadb.org/browse/MDEV-23811)) ### Galera * [Galera wsrep library](https://github.com/mariadb-corporation/docs-release-notes/blob/test/kb/en/what-is-mariadb-galera-cluster/README.md) updated to 25.3.31 * Fixed galera got stuck after flush tables ([MDEV-22707](https://jira.mariadb.org/browse/MDEV-22707)) * IPv6 SST handling improved ([MDEV-21770](https://jira.mariadb.org/browse/MDEV-21770), [MDEV-23576](https://jira.mariadb.org/browse/MDEV-23576), [MDEV-23580](https://jira.mariadb.org/browse/MDEV-23580), [MDEV-23581](https://jira.mariadb.org/browse/MDEV-23581), [MDEV-23574](https://jira.mariadb.org/browse/MDEV-23574)) * Fixed SIGSEGV in lock\_rec\_unlock ([MDEV-23101](https://jira.mariadb.org/browse/MDEV-23101)) * Fixed replication of timezone if only 1 timezone is loaded ([MDEV-22626](https://jira.mariadb.org/browse/MDEV-22626)) * Fixed replication of [CREATE OR REPLACE TRIGGER](/docs/server/server-usage/triggers-events/triggers/create-trigger.md) ([MDEV-21578](https://jira.mariadb.org/browse/MDEV-21578)) * Fixed SST FLUSH TABLES WITH READ LOCK timeout ([MDEV-22543](https://jira.mariadb.org/browse/MDEV-22543)) ### Notes * As per the [MariaDB Deprecation Policy](/docs/release-notes/community-server/about/platform-deprecation-policy.md), this will be the last release of [MariaDB 10.2](/docs/release-notes/community-server/old-releases/10.2/what-is-mariadb-102.md) for CentOS/RHEL 6 * Fixes for the following [security vulnerabilities](/docs/server/security/cve.md): * [CVE-2020-14812](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2020-14812) * [CVE-2020-14765](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2020-14765) * [CVE-2020-14776](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2020-14776) * [CVE-2020-14789](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2020-14789) * [CVE-2020-28912](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2020-28912) ([MDEV-24040](https://jira.mariadb.org/browse/MDEV-24040)) * [CVE-2021-2194](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2021-2194) ([MDEV-18366](https://jira.mariadb.org/browse/MDEV-18366)) Upgrading from 10.2 versions earlier than 10.2.17 is **highly recommended**\ for all [**Galera**](https://github.com/mariadb-corporation/docs-release-notes/blob/test/kb/en/galera/README.md) users due to bug [MDEV-12837](https://jira.mariadb.org/browse/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](/docs/release-notes/community-server/old-releases/10.2/10.2.16.md) or earlier to [MariaDB 10.2.17](/docs/release-notes/community-server/old-releases/10.2/10.2.17.md) or higher,\ running [mysql\_upgrade](/docs/server/clients-and-utilities/legacy-clients-and-utilities/mysql_upgrade.md) is **required** due to changes introduced in [MDEV-14637](https://jira.mariadb.org/browse/MDEV-14637). ## Changelog For a complete list of changes made in [MariaDB 10.2.35](/docs/release-notes/community-server/old-releases/10.2/10.2.35.md) with links to detailed\ information on each push, see the [changelog](/docs/release-notes/community-server/changelogs/changelogs-mariadb-102-series/mariadb-10235-changelog.md). ## Contributors For a full list of contributors to [MariaDB 10.2.35](/docs/release-notes/community-server/old-releases/10.2/10.2.35.md), see the [MariaDB Foundation release announcement](https://mariadb.org/mariadb-10-4-11-10-3-21-and-10-2-31-now-available/). {% 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 %} *This page is licensed: CC BY-SA / Gnu FDL* {% @marketo/form formid="4316" formId="4316" %}