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.
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
andCONVERT TABLE
clauses are crash-safe operations.
- To convert a partition to a table, use the
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.
- When a query takes more than
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
- 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';
- Starting with this release, the details details about the InnoDB temporary tablespace can be shown by querying for the name innodb_temporary:
- When a table’s default collation is set to the default collation for the table’s character set,
SHOW CREATE TABLE
shows theCOLLATE
clause. - Implemented
CHECK TABLE .. EXTENDED
for InnoDB.- When
CHECK TABLE .. EXTENDED
is executed, InnoDB confirms that no index contains orphan records.
- When
- The
MariaDB Enterprise Server 10.5.8-13
- MariaDB Enterprise Server 10.5.18-13 Release Notes
- 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';
- Starting with this release, the details details about the InnoDB temporary tablespace can be shown by querying for the name innodb_temporary:
- When a table’s default collation is set to the default collation for the table’s character set,
SHOW CREATE TABLE
shows theCOLLATE
clause.
- The
MariaDB Enterprise Server 10.4.27-18
- MariaDB Enterprise Server 10.4.27-18 Release Notes
- 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';
- Starting with this release, the details details about the InnoDB temporary tablespace can be shown by querying for the name innodb_temporary:
- When a table’s default collation is set to the default collation for the table’s character set,
SHOW CREATE TABLE
shows theCOLLATE
clause.
- The
MariaDB Enterprise Server 10.3.37-18
- MariaDB Enterprise Server 10.3.37-18 Release Notes
- 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';
- Starting with this release, the details details about the InnoDB temporary tablespace can be shown by querying for the name innodb_temporary:
- When a table’s default collation is set to the default collation for the table’s character set,
SHOW CREATE TABLE
shows theCOLLATE
clause.
- The
Why MariaDB Enterprise Server
MariaDB Enterprise Server is an enhanced, hardened and secured version of MariaDB 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 and 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 or try it in the cloud using MariaDB SkySQL – the only DBaaS that leverages the entire suite of MariaDB enterprise database products.