---
title: "MariaDB Server 10.5 Alpha Now Available"
publish_date: 2019-12-03
updated_date: 2021-08-30
author: "Ralf Gebhardt"
channel:
  - name: "Product"
    url: "/ja/resources/blog/channel/product.md"
---

# MariaDB Server 10.5 Alpha Now Available

The first alpha release of MariaDB Server 10.5 is now available!

Ever since the [GA release of MariaDB Server 10.4](https://staging-mdb.com/resources/blog/now-ga-mariadb-community-server-10-4/) this summer, we have been working hard to release the first alpha version of MariaDB Server 10.5. With this new version, we are delivering a number of new features, including:

- Improvements to partitioning for System Versioned Tables
- New plugin type for a user defined function
- New plugin type for a user defined type
    - INET6 data type plugin
- Enhancements to SQL Syntax
    - INSERT with support of RETURNING
    - EXCEPT ALL and INTERSECT ALL
    - REFERENCES clause in the column definitions in CREATE TABLE
- For InnoDB
    - New InnoDB internal thread handling
    - More detailed SHOW ENGINE INNODB STATUS
    - Optimized doublewrite buffer usage
- Enhancements to the Information Schema
    - Show config file a configuration parameter comes from
    - New tables for the thread pool
- Session user variable tracker
- Aria supports longer keys (up to 2000 bytes, was 1000 bytes)
- Optimizer enhancements for searches on columns with NULL values
- Inconsistency voting for MariaDB Cluster
- Per-database comments
- Optimizations for ARMv8
- JSON\_ARRAYAGG and JSON\_OBJECTAGG functions
- and lots of internal refactoring

MariaDB Server 10.5 will also include changes for defaults and system variables.

- New defaults:
    - Innodb\_checksum\_algorithm is full\_crc32 by default
    - Innodb\_adaptive\_hash\_index is OFF by default
    - Innodb\_log\_files\_in\_group is 1 by default
- System variables added: thread\_pool\_exact\_stats and thread\_pool\_dedicated\_listener
- System variables deprecated: big\_tables, innodb\_log\_checksums, and innodb\_undo\_logs
- System variables removed: max\_long\_data\_size, innodb\_locks\_unsafe\_for\_binlog, innodb\_rollback\_segments, and innodb\_stats\_sample\_pages

And we have more enhancements in store that we’ll be releasing with future versions of MariaDB Server 10.5. Stay tuned!

This is an alpha release and it should not be used in production. We encourage you to [download MariaDB Community Server 10.5,](https://staging-mdb.com/downloads/) test it and share your feedback with us.