---
title: "New Backported Features Available in MariaDB Enterprise Server Releases 10.3-10.6"
publish_date: 2022-12-22
author: "Ralf Gebhardt"
channel:
  - name: "Product"
    url: "/resources/blog/channel/product.md"
tags:
  - name: "Enterprise Server"
    url: "/resources/blog/tag/enterprise-server.md"
  - name: "Partitions"
    url: "/resources/blog/tag/partitions.md"
  - name: "Replication"
    url: "/resources/blog/tag/replication.md"
---

# New Backported Features Available in MariaDB Enterprise Server Releases 10.3-10.6

New maintenance releases for MariaDB Enterprise Server 10.6.11-6, 10.5.18-13, 10.4.27-18 and 10.3.37-18 are now available. These releases include new backported features and other notable upgrades to the InnoDB storage engine.

[Download Now](https://staging-mdb.com/downloads/enterprise/enterprise-server/)

### Backported Features

We identified several features that we released in MariaDB Community Server over the last few months that have now reached maturity and are ready for enterprise use.

**Now available in MariaDB Enterprise Server 10.6:**

- To simplify maintenance, the `ALTER TABLE` statement supports new clauses to convert tables to partitions and partitions to tables. 
    - To convert a partition to a table, use the `CONVERT PARTITION .. TO TABLE ..` clause: ```
        ALTER TABLE partitioned_table
             CONVERT PARTITION part1
             TO TABLE normal_table;
        ```
    - To convert a table to a partition, use the `CONVERT TABLE .. TO PARTITION ..` clause: ```
        ALTER TABLE partitioned_table
             CONVERT TABLE normal_table
             TO PARTITION part1 VALUES LESS THAN (12345);
        ```
    - The new `CONVERT PARTITION` and `CONVERT TABLE` clauses are crash-safe operations.

**Now available in MariaDB Enterprise Server 10.5 and 10.6:**

- The new `slave_max_statement_time` system variable is available to set the maximum execution time for queries on replica nodes. 
    - When a query takes more than `slave_max_statement_time` seconds to run on the replica (slave) node, the query is aborted, and replication stops with an error.
    - The system variable can be set to a decimal value, where the decimal component has microsecond precision.

### Other Release Updates

We have several other maintenance items included in these releases.

###### MariaDB Enterprise Server 10.6.11-6

- [MariaDB Enterprise Server 10.6.11-6 Release Notes](https://staging-mdb.com/docs/release-notes/mariadb-enterprise-server-10-6/10-6-11-6/)
- Notable Changes: 
    - The `information_schema.INNODB_SYS_TABLESPACES` view shows details about the InnoDB temporary tablespace, which is the tablespace where InnoDB temporary tables are stored. 
        - Starting with this release, the details details about the InnoDB temporary tablespace can be shown by querying for the name innodb\_temporary: ```
            SELECT * FROM 
            information_schema.INNODB_SYS_TABLESPACES
            WHERE name LIKE 'innodb_temporary';
            ```
    - When a table’s default collation is set to the default collation for the table’s character set, `SHOW CREATE TABLE` shows the `COLLATE` clause.
    - Implemented `CHECK TABLE .. EXTENDED` for InnoDB. 
        - When `CHECK TABLE .. EXTENDED` is executed, InnoDB confirms that no index contains orphan records.

###### MariaDB Enterprise Server 10.5.8-13

- [MariaDB Enterprise Server 10.5.18-13 Release Notes](https://staging-mdb.com/docs/release-notes/mariadb-enterprise-server-10-5/10-5-18-13/)
- Notable Changes: 
    - The `information_schema.INNODB_SYS_TABLESPACES` view shows details about the InnoDB temporary tablespace, which is the tablespace where InnoDB temporary tables are stored. 
        - Starting with this release, the details details about the InnoDB temporary tablespace can be shown by querying for the name innodb\_temporary: ```
            SELECT * FROM 
            information_schema.INNODB_SYS_TABLESPACES
            WHERE name LIKE 'innodb_temporary';
            ```
    - When a table’s default collation is set to the default collation for the table’s character set, `SHOW CREATE TABLE` shows the `COLLATE` clause.

###### MariaDB Enterprise Server 10.4.27-18

- [MariaDB Enterprise Server 10.4.27-18 Release Notes](https://staging-mdb.com/docs/release-notes/mariadb-enterprise-server-10-4/10-4-27-18/)
- Notable Changes: 
    - The `information_schema.INNODB_SYS_TABLESPACES` view shows details about the InnoDB temporary tablespace, which is the tablespace where InnoDB temporary tables are stored. 
        - Starting with this release, the details details about the InnoDB temporary tablespace can be shown by querying for the name innodb\_temporary: ```
            SELECT * FROM 
            information_schema.INNODB_SYS_TABLESPACES
            WHERE name LIKE 'innodb_temporary';
            ```
    - When a table’s default collation is set to the default collation for the table’s character set, `SHOW CREATE TABLE` shows the `COLLATE` clause.

###### MariaDB Enterprise Server 10.3.37-18

- [MariaDB Enterprise Server 10.3.37-18 Release Notes](https://staging-mdb.com/docs/release-notes/mariadb-enterprise-server-10-3/10-3-37-18/)
- Notable Changes: 
    - The `information_schema.INNODB_SYS_TABLESPACES` view shows details about the InnoDB temporary tablespace, which is the tablespace where InnoDB temporary tables are stored. 
        - Starting with this release, the details details about the InnoDB temporary tablespace can be shown by querying for the name innodb\_temporary: ```
            SELECT * FROM 
            information_schema.INNODB_SYS_TABLESPACES
            WHERE name LIKE 'innodb_temporary';
            ```
    - When a table’s default collation is set to the default collation for the table’s character set, `SHOW CREATE TABLE` shows the `COLLATE` clause.

### Why MariaDB Enterprise Server

[MariaDB Enterprise Server](https://staging-mdb.com/products/enterprise/components/) is an enhanced, hardened and secured version of [MariaDB Community Server](https://staging-mdb.com/products/community-server/) that delivers enterprise reliability, stability and long-term support as well as greater operational efficiency when it comes to managing large database deployments for business and mission critical applications. MariaDB Enterprise Server offers additional features needed for production workloads that are not available in the community edition, such as [enterprise audit](https://staging-mdb.com/docs/security/mariadb-enterprise-audit/) and [enterprise backup](https://staging-mdb.com/docs/recovery/mariadb-enterprise-backup/), and also backports certain enterprise features to older versions so customers can take advantage of critical fixes and features immediately instead of having to upgrade to the newest version.

Being able to backport features from newer release series to older versions is a key advantage of MariaDB Enterprise Server. Quality assurance and internal processes do not always allow customers to upgrade production environments to the newest and greatest release series, although some of the new features would be of value. MariaDB Enterprise Server can help in this case, as we can backport highly requested features to existing versions in cases where we can assure that a backported feature does not decrease the stability of that release series of MariaDB Enterprise Server.

### Download MariaDB Enterprise Server

MariaDB customers can download MariaDB Enterprise Server versions at [mariadb.com/downloads/enterprise](https://staging-mdb.com/downloads/enterprise/) or [try it in the cloud using MariaDB SkySQL](https://staging-mdb.com/products/skysql/get-started/) – the only DBaaS that leverages the entire suite of MariaDB enterprise database products.