The most recent release of MariaDB 10.5 is:
Alternate download from mariadb.org
{% endhint %} Download Release Notes Changelog Overview of 10.5 **Release date:** 3 Dec 2019 [MariaDB 10.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) is the current development 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.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md) is an [***Alpha***](/docs/release-notes/community-server/about/release-criteria.md) release. {% hint style="danger" %} **Do not use non-stable (non-GA) releases in production!** {% endhint %} **For an overview of** [**MariaDB 10.5**](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) **see the**[**What is MariaDB 10.5?**](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) **page.** Thanks, and enjoy MariaDB! ## Notable Changes This is the first alpha release in the [MariaDB 10.5](/docs/release-notes/community-server/old-releases/10.5/what-is-mariadb-105.md) series. Notable changes of this release include: ### INET 6 Data Type * New [INET6](/docs/server/reference/data-types/string-data-types/inet6.md) data type for storing IPv6 addresses ([MDEV-274](https://jira.mariadb.org/browse/MDEV-274)). ### Syntax * [INSERT ... RETURNING](/docs/server/reference/sql-statements/data-manipulation/inserting-loading-data/insertreturning.md) ([MDEV-10014](https://jira.mariadb.org/browse/MDEV-10014)) * [REPLACE ... RETURNING](/docs/server/reference/sql-statements/data-manipulation/changing-deleting-data/replacereturning.md) ([MDEV-10014](https://jira.mariadb.org/browse/MDEV-10014)) * [EXCEPT ALL](/docs/server/reference/sql-statements/data-manipulation/selecting-data/set-operations/except.md#all-distinct) and [INTERSECT ALL](/docs/server/reference/sql-statements/data-manipulation/selecting-data/set-operations/intersect.md#all-distinct) ([MDEV-18844](https://jira.mariadb.org/browse/MDEV-18844)) * Database comments in [CREATE DATABASE](/docs/server/reference/sql-statements/data-definition/create/create-database.md) and [ALTER DATABASE](/docs/server/reference/sql-statements/data-definition/alter/alter-database.md) statements ([MDEV-307](https://jira.mariadb.org/browse/MDEV-307)) * Setup [default partitions for system versioning](/docs/server/reference/sql-structure/temporal-tables/system-versioned-tables.md) ([MDEV-19903](https://jira.mariadb.org/browse/MDEV-19903)) * Fix [REFERENCES constraint](/docs/server/ha-and-performance/optimization-and-tuning/optimization-and-indexes/foreign-keys.md) in column definition ([MDEV-20729](https://jira.mariadb.org/browse/MDEV-20729)) ### JSON * [JSON\_ARRAYAGG](/docs/server/reference/sql-functions/aggregate-functions/json_arrayagg.md) * [JSON\_OBJECTAGG](/docs/server/reference/sql-functions/aggregate-functions/json_objectagg.md) * Add information about packed addon fields in [ANALYZE FORMAT=JSON](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/analyze-format-json.md) ([MDEV-21838](https://jira.mariadb.org/browse/MDEV-21838)) ### S3 Storage Engine * [S3 Storage Engine](/docs/server/server-usage/storage-engines/s3-storage-engine.md), a read-only storage engine that stores its data in Amazon S3 ([MDEV-17841](https://jira.mariadb.org/browse/MDEV-17841)) ### Thread Pool * Information Schema tables ([THREADPOOL\_GROUPS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-thread_pool_groups-table.md), [THREADPOOL\_QUEUES](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-thread_pool_queues-table.md) and [THREADPOOL\_STATS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-thread_pool_stats-table.md)) for internals of generic threadpool ([MDEV-19313](https://jira.mariadb.org/browse/MDEV-19313)) ### InnoDB * [innodb\_adaptive\_hash\_index](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_adaptive_hash_index) now defaults to `OFF` ([MDEV-20487](https://jira.mariadb.org/browse/MDEV-20487)) * [innodb\_checksum\_algorithm](/docs/server/server-usage/storage-engines/innodb/innodb-system-variables.md#innodb_checksum_algorithm) now defaults to `full_crc32` ([MDEV-19534](https://jira.mariadb.org/browse/MDEV-19534)) * innodb\_checksums has been removed ([MDEV-19534](https://jira.mariadb.org/browse/MDEV-19534)) * innodb\_log\_checksums has been deprecated ([MDEV-19543](https://jira.mariadb.org/browse/MDEV-19543)) * innodb\_locks\_unsafe\_for\_binlog has been removed ([MDEV-19544](https://jira.mariadb.org/browse/MDEV-19544)) * innodb\_stats\_sample\_pages has been removed ([MDEV-19551](https://jira.mariadb.org/browse/MDEV-19551)) * innodb\_undo\_logs has been deprecated ([MDEV-19570](https://jira.mariadb.org/browse/MDEV-19570)) * innodb\_rollback\_segments has been removed ([MDEV-19570](https://jira.mariadb.org/browse/MDEV-19570)) * Set innodb\_log\_files\_in\_group=1 by default ([MDEV-20907](https://jira.mariadb.org/browse/MDEV-20907)) * Extend [SHOW STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-status.md) LIKE 'Innodb\_%' ([MDEV-18582](https://jira.mariadb.org/browse/MDEV-18582)) * Clean up [INFORMATION\_SCHEMA.INNODB\_](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-innodb-tables.md) tables ([MDEV-19940](https://jira.mariadb.org/browse/MDEV-19940)) * Doublewrite buffer is unnecessarily used for newly (re)initialized pages ([MDEV-19738](https://jira.mariadb.org/browse/MDEV-19738)) * Defer change buffer merge until pages are requested ([MDEV-19514](https://jira.mariadb.org/browse/MDEV-19514)) #### InnoDB Refactoring * Remove buf\_page\_t::newest\_modification ([MDEV-21132](https://jira.mariadb.org/browse/MDEV-21132)) * Replace recv\_sys\_t::addr\_hash with a std::map ([MDEV-19586](https://jira.mariadb.org/browse/MDEV-19586)) * Obsolete internal parser for FK in InnoDB ([MDEV-20480](https://jira.mariadb.org/browse/MDEV-20480)) * InnoDB thread pool for background tasks ([MDEV-16264](https://jira.mariadb.org/browse/MDEV-16264)) ### Binary Log * Extended [binlog](/docs/server/server-management/server-monitoring-logs/binary-log.md) metadata ([MDEV-20477](https://jira.mariadb.org/browse/MDEV-20477)) ### Query Optimizer * [ANALYZE for statements](/docs/server/reference/sql-statements/administrative-sql-statements/analyze-and-explain-statements/analyze-statement.md) is improved, now it also shows the time spent checking the WHERE clause and doing other auxiliary operations ([MDEV-20854](https://jira.mariadb.org/browse/MDEV-20854)) * [Inferred IS NOT NULL predicates can be used by the range optimizer](/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/not_null_range_scan-optimization.md) ([MDEV-15777](https://jira.mariadb.org/browse/MDEV-15777)) ### Galera * Galera 4 Inconsistency voting ([MDEV-17048](https://jira.mariadb.org/browse/MDEV-17048)) ### General * The [Information Schema SYSTEM\_VARIABLES Table](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-system_variables-table.md) has a new column showing from which config file a variable derives its value ([MDEV-12684](https://jira.mariadb.org/browse/MDEV-12684)) * Switch Perl DBI scripts from DBD::mysql to DBD::MariaDB driver ([MDEV-19755](https://jira.mariadb.org/browse/MDEV-19755)) * The [Aria](/docs/server/server-usage/storage-engines/aria.md) max key length is now 2000 bytes, compared to 1000 bytes in [MyISAM](/docs/server/server-usage/storage-engines/myisam-storage-engine.md). **Do not use *****alpha***** releases in production!** ## Changelog For a complete list of changes made in [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md), with links to detailed information on each push, see the [changelog](/docs/release-notes/community-server/changelogs/changelogs-mariadb-105-series/mariadb-1050-changelog.md). ## Contributors For a full list of contributors to [MariaDB 10.5.0](/docs/release-notes/community-server/old-releases/10.5/10.5.0.md), see the [MariaDB Foundation release announcement](https://mariadb.org/mariadb-10-5-0-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" %}