> 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.5/10.5.7.md).

# MariaDB 10.5.7 Release Notes

{% hint style="info" %}

<p align="center">The most recent release of MariaDB 10.5 is:</p>

<h4 align="center"><a href="/pages/9W6JxPPj6M0eZxUmmE6T"><strong>MariaDB 10.5.29</strong></a> Stable (GA) <a href="https://mariadb.com/downloads/" class="button primary">Download Now</a></h4>

<p align="center"><a href="https://downloads.mariadb.org/mariadb/10.5.29/"><sub><em>Alternate download from mariadb.org</em></sub></a></p>
{% endhint %}

<a href="https://downloads.mariadb.org/mariadb/10.5.7/" class="button primary">Download</a> <a href="/pages/7q27ab1eEitrqSixL65A" class="button secondary">Release Notes</a> <a href="/pages/12Ap53T4YbIY3M7HTicO" class="button secondary">Changelog</a> <a href="/pages/UMff9uEph8CgRLMkeKnM" class="button secondary">Overview of 10.5</a>

**Release date:** 3 Nov 2020

[MariaDB 10.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) is the current *stable* series of MariaDB. It is an evolution of [MariaDB 10.4](/docs/release-notes/community-server/old-releases/10.4/what-is-mariadb-104.md) with several entirely new features not found anywhere else and with backported and reimplemented features from MySQL.

[MariaDB 10.5.7](/docs/release-notes/community-server/old-releases/10.5/10.5.7.md) is a [***Stable (GA)***](/docs/release-notes/community-server/about/release-criteria.md) release.

Thanks, and enjoy MariaDB!

## Notable Changes

This release introduced an InnoDB data corruption bug ([MDEV-24096](https://jira.mariadb.org/browse/MDEV-24096)). If any InnoDB tables contain indexed virtual columns or unique indexes on BLOB or TEXT columns, any InnoDB tables or tablespaces may become irreparably corrupted.

* Improved write performance ([MDEV-23399](https://jira.mariadb.org/browse/MDEV-23399), [MDEV-23855](https://jira.mariadb.org/browse/MDEV-23855), [MDEV-24037](https://jira.mariadb.org/browse/MDEV-24037))
* [MDEV-18323](https://jira.mariadb.org/browse/MDEV-18323) It is now possible to upgrade from MySQL 5.7 Tables containing JSON, by loading the MYSQL\_JSON datatype plugin first. See [Making MariaDB understand MySQL JSON](https://mariadb.org/making-mariadb-understand-mysql-json/).
* Update [S3 engine](/docs/server/server-usage/storage-engines/s3-storage-engine.md) to maturity Gamma
* [mariadbd --temp-pool](/docs/server/server-management/starting-and-stopping-mariadb/mariadbd-options.md) option deprecated and defaulted to zero ([MDEV-22278](https://jira.mariadb.org/browse/MDEV-22278))
* [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-23199](https://jira.mariadb.org/browse/MDEV-23199), [MDEV-23356](https://jira.mariadb.org/browse/MDEV-23356), [MDEV-23499](https://jira.mariadb.org/browse/MDEV-23499), [MDEV-23672](https://jira.mariadb.org/browse/MDEV-23672), [MDEV-23685](https://jira.mariadb.org/browse/MDEV-23685), [MDEV-23722](https://jira.mariadb.org/browse/MDEV-23722))
* Diskspace not reused for BLOB in data file ([MDEV-23072](https://jira.mariadb.org/browse/MDEV-23072))
* InnoDB: Failing assertion: `!space->referenced()` ([MDEV-23651](https://jira.mariadb.org/browse/MDEV-23651))
* `SIGSEGV` in `maria_create()` because of double free ([MDEV-23222](https://jira.mariadb.org/browse/MDEV-23222))
* `CREATE TEMPORARY TABLE .. LIKE` (system versioned table) returns error if unique index is defined in the table ([MDEV-23968](https://jira.mariadb.org/browse/MDEV-23968))
* Error upon querying the view, that selecting from versioned table with partitions ([MDEV-23779](https://jira.mariadb.org/browse/MDEV-23779))
* `CREATE .. SELECT` wrong result on join versioned table ([MDEV-23799](https://jira.mariadb.org/browse/MDEV-23799))
* `SIGSEGV` in `check_fields` on `UPDATE` ([MDEV-22805](https://jira.mariadb.org/browse/MDEV-22805))
* Parser fix ([MDEV-23094](https://jira.mariadb.org/browse/MDEV-23094))
* Add CRC-32 code to `mysys`, giving notable speedup in checksum calculation on x64 ([MDEV-19935](https://jira.mariadb.org/browse/MDEV-19935))
* Faster CRC-32C checksum calculations ([MDEV-23495](https://jira.mariadb.org/browse/MDEV-23495), [MDEV-22749](https://jira.mariadb.org/browse/MDEV-22749))
* Fixes to potential corruption bugs ([MDEV-23973](https://jira.mariadb.org/browse/MDEV-23973), [MDEV-24054](https://jira.mariadb.org/browse/MDEV-24054))
* Fixed delayed replication with S3 storage engine slave ([MDEV-23691](https://jira.mariadb.org/browse/MDEV-23691))
* Deadlock between `BACKUP STAGE BLOCK_COMMIT` and parallel replication ([MDEV-23586](https://jira.mariadb.org/browse/MDEV-23586))
* `CREATE` fails after `DROP` without `.frm` ([MDEV-23549](https://jira.mariadb.org/browse/MDEV-23549))

### S3 Storage Engine

* Update [S3 engine](/docs/server/server-usage/storage-engines/s3-storage-engine.md) to maturity Gamma
* Add the [s3\_use\_http](/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables.md#s3_use_http) and [s3\_port](/docs/server/server-usage/storage-engines/s3-storage-engine/s3-storage-engine-system-variables.md#s3_port) system variables

### Galera

* [Galera wsrep library](/docs/galera-cluster/readme/mariadb-galera-cluster-guide.md) updated to 26.4.6
* Fixed assertion failure on before\_commit ([MDEV-22681](https://jira.mariadb.org/browse/MDEV-22681))
* Fixed assertion after ROLLBACK AND CHAIN ([MDEV-22055](https://jira.mariadb.org/browse/MDEV-22055))
* Fixed replication of DROP TRIGGER ([MDEV-23638](https://jira.mariadb.org/browse/MDEV-23638))
* 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 ([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.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) for CentOS/RHEL 6 and Fedora 31
* Packages for [Ubuntu 20.10 "Groovy Gorilla"](https://downloads.mariadb.org/mariadb/repositories/#distro=Ubuntu\&distro_release=groovy--ubuntu_groovy) added
* Packages for [Debian 10 "buster"](https://downloads.mariadb.org/mariadb/repositories/#distro=Debian\&distro_release=buster--buster) arm64 and ppc64el added
* Packages for [Debian 9 "stretch"](https://downloads.mariadb.org/mariadb/repositories/#distro=Debian\&distro_release=stretch--stretch) arm64 added
* 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))
  * [CVE-2022-21427](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2022-21427)

## Changelog

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

## Contributors

For a full list of contributors to [MariaDB 10.5.7](/docs/release-notes/community-server/old-releases/10.5/10.5.7.md), see the [MariaDB Foundation release announcement](https://mariadb.org/first-mariadb-10-5-alpha-release/).

{% 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" %}
