Release Notes for MariaDB Enterprise Server 10.6.4-1

MariaDB Enterprise Server 11.6.4-1 is the first Stable (GA) release of MariaDB Enterprise Server 10.6, released on 2021-08-26

The most recent release of MariaDB Enterprise Server 10.6 is:

MariaDB Enterprise Server 10.6.23-19 Download Now

MariaDB Enterprise Server 10.6.4-1 is the first Stable, General Availability (GA) release of MariaDB Enterprise Server 10.6. This release contains a variety of new features.

MariaDB Enterprise Server 10.6.4-1 was released on 2021-08-26.

Fixed Security Vulnerabilities

CVE (with cve.org link)	CVSS base score
CVE-2021-46658	5.5

Notable Changes

• Extensive internal optimizations, including a refactoring of InnoDB storage engine code.

• Atomic DDL

  • DDL (Data Definition Language) statements are now atomic operations. If the DDL statement is not fully successful, the operation will be rolled back. When the server crashes or is killed in the middle of a DDL statement, the operation is rolled back during crash recovery when the server is restarted. (MDEV-17567)

  • During crash recovery, the server uses the DDL log to determine if an operation needs to be rolled back. When the binary log is enabled, the crash recovery process ensures that the successful operations are written to the binary log and that the unsuccessful operations are not.

  • By default, the DDL log is at ddl-recovery.log in the datadir. When DDL statements are being executed, the DDL log is synchronized to disk very frequently. If you want to configure a custom path for the DDL log, the log-ddl-recovery option can be used.

  • As of this release, the following storage engines fully support atomic DDL:

    • Aria

    • InnoDB

    • MyISAM

    • MyRocks

• Default InnoDB flush method

  • The default innodb_flush_method is now O_DIRECT (MDEV-24854)

  • Prior to this release, the default innodb_flush_method was fsync

• UTF-8 (utf8) character set alias

  • The utf8 character set has been renamed to utf8mb3, which used to be an alias for the utf8 character set

  • The character set utf8 is now an alias that defaults to utf8mb3 but can be turned into an alias for utf8mb4 with a config change

  • The new default of old_mode=UTF8_IS_UTF8MB3 is what makes utf8mb3 default to utf8, and anything that removes this new value from old_mode changes utf8 to mean utf8mb4 (MDEV-8334)

  • In a future release series (after 10.6) the default value of old_mode will drop this new value, making utf8 default to utf8mb4

• IPv6 by Default (MDEV-6536)

  • When --bind-address=HOSTNAME is configured, MariaDB Enterprise Server now listens on both IPv6 and IPv4 addresses.

Changes in Storage Engines

ColumnStore

• This release incorporates MariaDB Enterprise ColumnStore version 6.1.1. Benefits include:

  • Disk-based aggregation allows larger aggregated result sets than can fit in memory

  • Increased DECIMAL precision

  • Transactional tables can be updated with data from ColumnStore tables

  • LZ4 compression

InnoDB

• Default InnoDB flush method

  • (This item is also mentioned above in Notable Changes .)

  • The default innodb_flush_method is now O_DIRECT (MDEV-24854)

  • Prior to this release, the default innodb_flush_method was fsync

• SELECT .. SKIP LOCKED

  • SELECT [ FOR UPDATE | LOCK IN SHARED MODE ] .. SKIP LOCKED ignores already-locked rows. (MDEV-13115)

  • One use case for this feature is within applications that sell a limited resource, such as ticketing, rentals, or seat-based sales. In these applications, you need a way to display only the available inventory. This can be accomplished by querying available inventory and skipping locked rows.

SELECT *
FROM ticketing
WHERE claimed = 0 AND section = 'B'
ORDER BY row DESC
LIMIT 10
FOR UPDATE SKIP LOCKED;

• Compressed rows read-only by default

  • COMPRESSED row format is read-only by default. (MDEV-23497)

  • System variable innodb_read_only_compressed=ON by default.

  • System variable innodb_read_only_compressed=OFF enables write support.

  • This is a preparatory change. Additional change will occur in a future release series (after 10.6), when COMPRESSED row format will no longer accept writes. It is recommended to alter tables using the COMPRESSED row format to use the DYNAMIC row format with InnoDB page compression:

ALTER TABLE tab
 ROW_FORMAT=DYNAMIC
 PAGE_COMPRESSED=1;

• For additional information, see "Convert InnoDB Tables to the Dynamic Row Format" and "Configure InnoDB Page Compression".

• Information Schema changes for InnoDB

  • Information Schema INNODB_SYS_TABLESPACES directly reflects the filesystem. (MDEV-22343)

  • INNODB_SYS_TABLESPACES.PAGE_SIZE contains the physical page size of a page.

  • INNODB_SYS_TABLESPACES.FILENAME added as a replacement for SYS_DATAFILES.PATH

  • Information Schema INNODB_SYS_DATAFILES removed. (MDEV-22343)

• Reduced global lock duration in InnoDB transaction deadlock checks (MDEV-24738)

• InnoDB no longer acquires advisory file locks by default (MDEV-24393)

• When using data-at-rest encryption with the file_key_management encryption plugin, InnoDB will automatically disable key rotation checks. (MDEV-14180)*

  • The file_key_management encryption plugin does not support key rotation, so key rotation checks are not required.*

  • In previous releases, unnecessary key rotation checks with the file_key_management encryption plugin could reduce performance, unless they were explicitly disabled by setting innodb_encryption_rotate_key_age=0.

• • Optimization added to speed up inserts into an empty InnoDB table. (MDEV-515)

• Maximum value of the innodb_lock_wait_timeout system variable is now 100000000, which means infinite timeout.

• Change in checksum algorithm options

  • innodb_checksum_algorithm options have changed: (MDEV-25105)

    • Supported: crc32, strict_crc32, full_crc32, strict_full_crc32

    • Eliminated: none, strict_none, innodb, strict_innodb

  • When InnoDB reads a page using an eliminated checksum algorithm after performing a physical upgrade, InnoDB will continue to accept the checksum.

  • When a query changes a page using an eliminated checksum algorithm, InnoDB will automatically switch to a supported checksum algorithm when InnoDB writes the changed page to disk.

Compatibility Enhancements

• Expanded compatibility with Oracle through new functions:

  • Added function ADD_MONTHS() (MDEV-20025)

  • Added function ROWNUM() (MDEV-24285)

  • Added function SYS_GUID() (MDEV-24285)

  • Added function TO_CHAR() (MDEV-20017)

• Expanded compatibility with Oracle through sql_mode=ORACLE enhancements:

  • With sql_mode=ORACLE added MINUS as an alias to EXCEPT (MDEV-20021)

  • With sql_mode=ORACLE improved SYSDATEto allow use without parenthesis. (MDEV-19682)

  • With sql_mode=ORACLE supports a rownum pseudo-column name as an alias for the ROWNUM() function (MDEV-24089)

  • With sql_mode=ORACLE subqueries in a FROM clause do not require the AS clause.

• Enhanced compatibility with Sybase SQL Anywhere through sql_mode=EXTENDED_ALIASES: (MENT-1062)

  • With sql_mode=EXTENDED_ALIASES, alias resolution and use of column aliases in the SQL SELECT list and WHERE clause.

  • With sql_mode=EXTENDED_ALIASES, support use of an alias in the SELECT list before the alias is defined.

  • With sql_mode=EXTENDED_ALIASES, if the same label is used for an alias and a column, the alias is used.

Operational Enhancements

• sys Schema

  • sys schema provides a set of views, functions, and stored procedures to aid DBA analysis of the Performance Schema. (MDEV-9077)

• Increase in host name length

  • Host names in CREATE USER, GRANT and replication CHANGE MASTER can be up to 255 bytes long. (MDEV-24312)

• UTF8

• (This item is also mentioned above in Notable Changes .)

• The utf8 character set has been renamed to utf8mb3, which was formerly an alias for the utf8 character set

• The character set utf8 is now an alias that defaults to utf8mb3 but can be turned into an alias for utf8mb4 with a config change

• The new default of old_mode=UTF8_IS_UTF8MB3 is what makes utf8mb3 default to utf8, and anything that removes this new value from old_mode changes utf8 to mean utf8mb4 (MDEV-8334)

• In a future release series (after 10.6) the default value of old_mode will drop this new value, making utf8 default to utf8mb4

• Ignored indexes

  • An index can be marked with the IGNORED option, which forbids the optimizer from using the index in queries. The IGNORED option can be used to evaluate whether an index is actually helpful for performance without dropping the index. (MDEV-7317)

  • Example syntax for CREATE TABLE:

CREATE TABLE table_name (
 id INT PRIMARY KEY,
 col_name INT,
 INDEX key_name (col_name) IGNORED
);

• Example syntax for CREATE INDEX:

CREATE INDEX key_name
 ON table_name
 (col_name) IGNORED;

• Example syntax for ALTER TABLE:

ALTER TABLE table_name
 ALTER INDEX key_name IGNORED;

• An ignored index cannot be referenced in index hints, such as FORCE INDEX, IGNORE INDEX, or USE INDEX. When you try to reference an ignored index in an index hint, the server raises an error with the ER_KEY_DOES_NOT_EXISTS error code:

SELECT *
FROM table_name
 FORCE INDEX (key_name)
WHERE col_name > 1;

ERROR 1176 (42000): Key 'key_name' doesn't exist in table 'table_name'

• Thread Pool enhancements

  • The thread pool can be configured to reshuffle connections into random thread groups periodically, which can help prevent many connections from becoming concentrated in just a few thread groups. (MENT-622)

  • The thread_pool_reshuffle_group_period system variable defines how frequently the connections are reshuffled. By default, the value is 0 which means that connections are not reshuffled.

  • The THREAD_POOL_CONNECTIONS information schema table can be used to view which connections are assigned to each thread group.

• Systemd

  • Systemd socket activation is now supported. (MDEV-5536)

SQL Level Enhancements

• JSON_TABLE()

  • JSON_TABLE() returns a table from JSON data. (MDEV-17399)

  • Queryable rows and columns are produced based on the JSON input, but are not stored in a table on disk. Column mappings are defined in a JSON path expression.

  • Prior to this release, the JSON_VALUE() and JSON_QUERY() functions could be used to retrieve values from JSON data on a per-column basis.

  • With JSON_TABLE():

    • JSON data can JOIN with existing tables.``

    • A table can be created from JSON data using CREATE TABLE .. AS SELECT against a JSON_TABLE().

    • NESTED PATH enables extraction of nested data from JSON arrays and objects.

• OFFSET syntax

  • Additional syntax is supported for SELECT .. OFFSET (MDEV-23908)

  • OFFSET start { ROW | ROWS } FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } { ONLY | WITH TIES } is an alternative to LIMIT .. OFFSET

  • The WITH TIES option requires the use of ORDER BY and allows the number of rows to exceed the FETCH count to ensure that the final row in the chunk includes any additional rows that have the same values in the ORDER BY fields (eliminating the need to fetch the next chunk to check for spill-over).

    • For example, the following query can return more than 10 rows if there are more username rows that match the username in the 10th row (the order of the purchase values within the complete set of each username's records is non-deterministic):

SELECT username, purchase
FROM user_purchases
ORDER BY username
OFFSET 305 ROWS
FETCH NEXT 10 ROWS WITH TIES;

• For example, the following query specifies ONLY instead of WITH TIES, so the query can't return more than 10 rows:

SELECT username, purchase
FROM user_purchases
ORDER BY username, purchase
OFFSET 0 ROWS
FETCH NEXT 10 ROWS ONLY;

• Views supported with FLUSH TABLES tbl_name [, tbl_name] .. WITH READ LOCK (MDEV-15888)

• All SQL statements can be prepared except PREPARE, EXECUTE, [DEALLOCATE / DROP PREPARE(MDEV-16708)

Security Features

• MariaDB Enterprise Audit allows database-specific and table-specific filters. (MENT-65) For example:

{
 "connect_event" : "ALL",
 "table_event" : ["READ","WRITE",{"ignore_tables" : "mysql.*"}],
 "query_event" : ["DDL",{"tables" : "test.t2"}]
}

• The gssapi authentication plugin can now authenticate a user account by checking if the user belongs to an Active Directory group. (MDEV-23959)

  • The group is specified in the authentication string using the CREATE USER statement. The group can be specified using the group name or the SID.

  • Example syntax using a group name without specifying the domain:

CREATE USER root
 IDENTIFIED VIA gssapi AS 'GROUP:Administrators';

• Example syntax using a group name that specifies the domain:

CREATE USER root
 IDENTIFIED VIA gssapi AS 'GROUP:Administrators';

• Example syntax using a SID in the usual format:

CREATE USER root
 IDENTIFIED VIA gssapi AS 'SID:S-1-5-32-544';

• Example syntax using a well-known SID:

CREATE USER everyone
 IDENTIFIED VIA gssapi AS 'SID:WD';

• When using data-at-rest encryption with the file_key_management encryption plugin, InnoDB will automatically disable key rotation checks. (MDEV-14180)*

  • The file_key_management encryption plugin does not support key rotation, so key rotation checks are not required.*

  • In previous releases, unnecessary key rotation checks with the file_key_management encryption plugin could hurt performance, unless they were explicitly disabled by setting innodb_encryption_rotate_key_age=0.

• With MariaDB Enterprise Cluster, TLS is required for MariaDB Enterprise Cluster by default. (MENT-1192)

  • Since TLS is required for Enterprise Cluster by default, database administrators should create TLS certificates for each node during the deployment process.

  • Database administrators can revert Enterprise Cluster to the mode used in previous releases by setting the wsrep_ssl_mode system variable to PROVIDER.

  • For additional information, see "WSREP TLS Modes".

• TLS functionality for State Snapshot Transfers (SSTs) is enhanced when MariaDB Enterprise Backup or Rsync is the SST method. (MDEV-25359)

  • For additional information, see "SST TLS Modes".

• Cluster name verification is performed for Joiner nodes prior to State Snapshot Transfers (SSTs) and Incremental State Transfers (ISTs). (MDEV-25359) For additional information, see "Cluster Name Verification".

• With MariaDB Enterprise Cluster, system variable wsrep_certificate_expiration_hours_warning enables logging of a warning prior to expiration of the TLS certificate used for wsrep (Enterprise Cluster) communications. (MENT-1090)

  • For additional information, see "Certificate Expiration Warnings".

• • With MariaDB Enterprise Cluster, communication between nodes can be changed from unencrypted to TLS without cluster downtime. (MDEV-22131)

  • Enabling TLS without downtime relies on two new options implemented for the wsrep_provider_options system variable: socket.dynamic and socket.ssl_reload.

  • For additional information, see "Enable TLS without Downtime".

MariaDB Replication

• Performance Schema replication_applier_status_by_worker table provides information on replica worker threads. (MDEV-20220)

• Fine-grained binlog expiration

  • binlog_expire_logs_seconds system variable defines the frequency in seconds of automated removal of binary logs. (MDEV-19371)

  • Prior to this release, expiration time was defined in days using binlog_expire_logs_days.

• Enhanced consistency for Semi-Sync Replication

  • When rpl_semi_sync_slave_enabled=ON, consistency is guaranteed for a Primary server in an HA (Primary/Replica) topology when using semi-synchronous replication. (MDEV-21117)

  • rior to this release, when using semi-synchronous replication, if a Primary crashed before sending a transaction to the Replica, on restart the Primary could recover incomplete InnoDB transactions when rejoining as a Replica.

  • With this release, when using semi-synchronous replication and with rpl_semi_sync_slave_enabled=ON, incomplete transactions will be rolled-back on the Replica, ensuring the new Primary (former Replica) and new Replica (former Primary) remain in sync.

MariaDB Enterprise Cluster

MariaDB Enterprise Cluster is powered by Galera. New in this release:

• XA Transactions are supported (MENT-690)

• With MariaDB Enterprise Cluster, TLS is required for MariaDB Enterprise Cluster by default. (MENT-1192)

  • Since TLS is required for Enterprise Cluster by default, database administrators should create TLS certificates for each node during the deployment process.

  • Database administrators can revert Enterprise Cluster to the mode used in previous releases by setting the wsrep_ssl_mode system variable to PROVIDER.

  • For additional information, see "WSREP TLS Modes".

• TLS functionality for State Snapshot Transfers (SSTs) is enhanced when MariaDB Enterprise Backup or Rsync is the SST method. (MDEV-25359)

  • For additional information, see "SST TLS Modes".

• Cluster name verification is performed for Joiner nodes prior to State Snapshot Transfers (SSTs) and Incremental State Transfers (ISTs). (MDEV-25359)

  • For additional information, see "Cluster Name Verification".

• wsrep_certificate_expiration_hours_warning system variable enables logging of a warning prior to expiration of the TLS certificate used for wsrep (Enterprise Cluster) communications. (MENT-1090)

  • For additional information, see "Certificate Expiration Warnings".

• • Communication between nodes can be changed from unencrypted to TLS without cluster downtime. (MDEV-22131)

  • Enabling TLS without downtime relies on two new options implemented for the wsrep_provider_options system variable: socket.dynamic and socket.ssl_reload.

  • For additional information, see "Enable TLS without Downtime".

• Galera Cluster nodes can be configured to refuse statements that would generate local GTIDs. (MDEV-20715)

  • When Galera Cluster is used with MariaDB Replication, local GTIDs can cause replication errors when the primary or replica has to failover to a different cluster node. By configuring Galera Cluster nodes to refuse statements that would generate local GTIDs, replication is more likely to succeed against any available cluster node.

  • To configure a node to refuse statements that would generate local GTIDs, set wsrep_mode=DISALLOW_LOCAL_GTID.

• wsrep_mode=STRICT_REPLICATION replaces deprecated system variable wsrep_strict_ddl (MDEV-20008)

• wsrep_mode=REPLICATE_MYISAM replaces deprecated system variable wsrep_replicate_myisam (MDEV-24946)

• When wsrep_debug=SERVER and wsrep_OSU_method=TOI, information about DDL queries from remote hosts is logged in the local error log, not just locally-initiated DDL queries. (MDEV-9609)

  • The default of wsrep_debug=NONE disables debug logging.

• The script wsrep_sst_mariadb-backup checks all server-related configuration groups when processing a configuration file. (MDEV-25669)

  • Prior to this release, only the [mysqld] configuration group was checked when processing a configuration file.

• Performance Schema for Enterprise Cluster

  • Performance Schema table galera_group_members logs information about the configuration of the cluster. (MDEV-286)

  • Performance Schema table galera_group_member_stats logs information about the performance characteristics of nodes in the cluster. (MDEV-286)

Interface Changes

The following changes are as compared to MariaDB Enterprise Server 10.5.10-7, the latest GA release on the prior release series.

• For clients such as mariadb (mysql), the connection property specified via the command-line (such as --port=3306) will force the connection type (such as TCP/IP). (MDEV-14974)

• Unchanged metadata is not sent in the result set for prepared statements. (MDEV-19237)

• ADD_MONTHS() function added

• binlog_expire_logs_seconds system variable added

• columnstore_cache_use_import system variable added

• columnstore_decimal_overflow_check system variable added

• Com_multi status variable removed

• ER_BINLOG_UNSAFE_SKIP_LOCKED error code added

• ER_BLACKBOX_ERROR error code error number changed from 4174 to 6000

• ER_JSON_TABLE_ALIAS_REQUIRED error code added

• ER_JSON_TABLE_ERROR_ON_FIELD error code added

• ER_JSON_TABLE_MULTIPLE_MATCHES error code added

• ER_JSON_TABLE_SCALAR_EXPECTED error code added

• ER_PK_INDEX_CANT_BE_IGNORED error code added

• ER_REMOVED_ORPHAN_TRIGGER error code added

• ER_STORAGE_ENGINE_DISABLED error code added

• ER_UNSUPPORTED_COMPRESSED_TABLE error code replaces ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE

• ER_UNUSED_26 error code replaces ER_COMMULTI_BADCONTEXT

• ER_UNUSED_27 error code replaces ER_BAD_COMMAND_IN_MULTI

• ER_UNUSED_28 error code replaces ER_TABLE_IN_FK_CHECK

• ER_WITH_TIES_NEEDS_ORDER error code added

• expire_logs_days system variable default value changed from 0 to 0.000000

• galera_group_member_stats performance schema table added

• galera_group_members performance schema table added

• host_summary sys table added

• host_summary_by_file_io sys table added

• host_summary_by_file_io_type sys table added

• host_summary_by_stages sys table added

• host_summary_by_statement_latency sys table added

• host_summary_by_statement_type sys table added

• innochecksum --strict-check (-C) command-line option removed

• innochecksum --write (-w) command-line option removed

• innodb_adaptive_max_sleep_delay system variable removed

• innodb_background_scrub_data_check_interval system variable removed

• innodb_background_scrub_data_compressed system variable removed

• innodb_background_scrub_data_interval system variable removed

• innodb_background_scrub_data_uncompressed system variable removed

• innodb_buffer_pool_instances system variable removed

• Innodb_buffer_pool_pages_lru_freed status variable added

• innodb_buffer_stats_by_schema sys table added

• innodb_buffer_stats_by_table sys table added

• innodb_commit_concurrency system variable removed

• innodb_concurrency_tickets system variable removed

• innodb_deadlock_report system variable added

• innodb_file_format system variable removed

• innodb_flush_method system variable default value changed from fsync to O_DIRECT

• innodb_large_prefix system variable removed

• innodb_lock_schedule_algorithm system variable removed

• innodb_lock_wait_timeout system variable maximum value changed from 1073741824 to 100000000

• innodb_lock_waits sys table added

• innodb_log_checksums system variable removed

• innodb_log_compressed_pages system variable removed

• innodb_log_files_in_group system variable removed

• innodb_log_optimize_ddl system variable removed

• INNODB_MUTEXES information schema table removed

• INNODB_MUTEXES plugin removed

• innodb_page_cleaners system variable removed

• innodb_read_only_compressed system variable added

• innodb_replication_delay system variable removed

• innodb_scrub_log System Variable system variable removed

• innodb_scrub_log_speed system variable removed

• innodb_sync_array_size system variable removed

• INNODB_SYS_DATAFILES information schema table removed

• INNODB_SYS_DATAFILES plugin removed

• INNODB_SYS_SEMAPHORE_WAITS information schema table removed

• INNODB_SYS_SEMAPHORE_WAITS plugin removed

• innodb_thread_concurrency system variable removed

• innodb_thread_sleep_delay system variable removed

• innodb_undo_logs system variable removed

• io_by_thread_by_latency sys table added

• io_global_by_file_by_bytes sys table added

• io_global_by_file_by_latency sys table added

• io_global_by_wait_by_bytes sys table added

• io_global_by_wait_by_latency sys table added

• JSON_TABLE() function added

• KEYWORDS information schema table added

• latest_file_io sys table added

• mariadb-backup --debug-sleep-before-unlock command-line option removed

• mariadb-backup --debug-sync command-line option removed

• mariadb-backup --innodb-log-files-in-group command-line option removed

• mariadbd --binlog-expire-logs-seconds command-line option added

• mariadbd --columnstore-cache-use-import command-line option added

• mariadbd --columnstore-decimal-overflow-check command-line option added

• mariadbd --innodb-adaptive-max-sleep-delay command-line option removed

• mariadbd --innodb-background-scrub-data-check-interval command-line option removed

• mariadbd --innodb-background-scrub-data-compressed command-line option removed

• mariadbd --innodb-background-scrub-data-interval command-line option removed

• mariadbd --innodb-background-scrub-data-uncompressed command-line option removed

• mariadbd --innodb-buffer-pool-instances command-line option removed

• mariadbd --innodb-commit-concurrency command-line option removed

• mariadbd --innodb-concurrency-tickets command-line option removed

• mariadbd --innodb-deadlock-report command-line option added

• mariadbd --innodb-file-format command-line option removed

• mariadbd --innodb-large-prefix command-line option removed

• mariadbd --innodb-lock-schedule-algorithm command-line option removed

• mariadbd --innodb-log-checksums command-line option removed

• mariadbd --innodb-log-compressed-pages command-line option removed

• mariadbd --innodb-log-files-in-group command-line option removed

• mariadbd --innodb-log-optimize-ddl command-line option removed

• mariadbd --innodb-mutexes command-line option removed

• mariadbd --innodb-page-cleaners command-line option removed

• mariadbd --innodb-read-only-compressed command-line option added

• mariadbd --innodb-replication-delay command-line option removed

• mariadbd --innodb-scrub-log command-line option removed

• mariadbd --innodb-scrub-log-speed command-line option removed

• mariadbd --innodb-sync-array-size command-line option removed

• mariadbd --innodb-sys-datafiles command-line option removed

• mariadbd --innodb-sys-semaphore-waits command-line option removed

• mariadbd --innodb-thread-concurrency command-line option removed

• mariadbd --innodb-thread-sleep-delay command-line option removed

• mariadbd --innodb-undo-logs command-line option removed

• mariadbd --log-ddl-recovery command-line option added

• mariadbd --server-audit-load-on-error command-line option added

• mariadbd --thread-pool-connections command-line option added

• mariadbd --thread-pool-reshuffle-group-period command-line option added

• mariadbd --wsrep-certificate-expiration-hours-warning command-line option added

• mariadbd --wsrep-mode command-line option added

• mariadbd wsrep-ssl-mode command-line option added

• max_recursive_iterations system variable default value changed from 4294967295 to 1000 (MDEV-17239)

• memory_by_host_by_current_bytes sys table added

• memory_by_thread_by_current_bytes sys table added

• memory_by_user_by_current_bytes sys table added

• memory_global_by_current_bytes sys table added

• memory_global_total sys table added

• metrics sys table added

• MINUS reserved word added

• OFFSET reserved word added

• old_mode system variable default value changed from "" (empty) to UTF8_IS_UTF8MB3

• processlist sys table added

• ps_check_lost_instrumentation sys table added

• Resultset_metadata_skipped status variable added

• ROWNUM() function added

• ROWNUM reserved word added

• schema_auto_increment_columns sys table added

• schema_index_statistics sys table added

• schema_object_overview sys table added

• schema_redundant_indexes-sys-schema-view sys table added

• schema_table_lock_waits sys table added

• schema_table_statistics-sys-schema-view sys table added

• schema_table_statistics_with_buffer-sys-schema-viewsys table added

• schema_schema_tables_with_full_table_scansobject_overview-sys-schema-view sys table added

• schema_unused_indexes-sys-schema-view sys table added

• server_audit_load_on_error system variable added

• session sys table added

• session_ssl_status sys table added

• SQL_FUNCTIONS information schema table added

• sql_mode value EXTENDED_ALIASES added

• statement_analysis sys table added

• statements_with_errors_or_warnings sys table added

• statements_with_full_table_scans sys table added

• statements_with_runtimes_in_95th_percentile sys table added

• statements_with_sorting sys table added

• statements_with_temp_tables sys table added

• [SYS_GUID|[SYS_GUID()]] function added

• SYSDATE reserved word added

• system_versioning_asof system variable default value changed from DEFAULT to "" (empty)

• THREAD_POOL_CONNECTIONS information schema table added

• THREAD_POOL_CONNECTIONS plugin added

• thread_pool_reshuffle_group_period system variable added

• TO_CHAR() function added

• user_summary sys table added

• user_summary_by_file_io sys table added

• user_summary_by_file_io_type sys table added

• user_summary_by_stages sys table added

• user_summary_by_statement_latency sys table added

• user_summary_by_statement_type sys table added

• version sys table added

• wait_classes_global_by_avg_latency sys table added

• wait_classes_global_by_latency sys table added

• waits_by_host_by_latency sys table added

• waits_by_user_by_latency sys table added

• waits_global_by_latency sys table added

• wsrep_certificate_expiration_hours_warning system variable added

• wsrep_mode system variable added

• wsrep_ssl_mode system variable added

• x$host_summary sys table added

• x$host_summary_by_file_io sys table added

• x$host_summary_by_file_io_type sys table added

• x$host_summary_by_stages sys table added

• x$host_summary_by_statement_latency sys table added

• x$host_summary_by_statement_type sys table added

• hinnodb_buffer_stats_by_schema-and-xinnodb_buffer_stats_by_schema-sys-schema-views sys table added

• x$innodb_buffer_stats_by_table sys table added

• x$innodb_lock_waits sys table added

• x$io_by_thread_by_latency sys table added

• x$io_global_by_file_by_bytes sys table added

• io_global_by_file_by_latency-and-xio_global_by_file_by_latency-sys-schema-views sys table added

• x$io_global_by_wait_by_bytes sys table added

• io_global_by_wait_by_latency-and-xio_global_by_wait_by_latency-sys-schema-views sys table added

• x$latest_file_io sys table added

• memory_by_host_by_current_bytes-and-xmemory_by_host_by_current_bytes-sys-schema-views sys table added

• memory_by_thread_by_current_bytes-and-xmemory_by_thread_by_current_bytes-sys-schema-views sys table added

• memory_by_user_by_current_bytes-and-xmemory_by_user_by_current_bytes-sys-schema-views sys table added

• memory_global_by_current_bytes-and-xmemory_global_by_current_bytes-sys-schema-views sys table added

• memory_global_total-and-xmemory_global_total-sys-schema-views sys table added

• processlist-and-xprocesslist-sys-schema-views sys table added

• ps_digest_95th_percentile_by_avg_usy-and-xps_digest_95th_percentile_by_avg_us-sys-schema-views sys table added

• hps_digest_avg_latency_distribution-and-xps_digest_avg_latency_distribution-sys-schema-views sys table added

• ps_schema_table_statistics_io-and-xps_schema_table_statistics_io-sys-schema-views sys table added

• schema_flattened_keys-and-xschema_flattened_keys-sys-schema-views sys table added

• schema_index_statistics-and-xschema_index_statistics-sys-schema-views sys table added

• schema_table_lock_waits-and-xschema_table_lock_waits-sys-schema-views sys table added

• schema_table_statistics-and-xschema_table_statistics-sys-schema-views sys table added

• schema_table_statistics_with_buffer-and-xschema_table_statistics_with_buffer-sys-schema-views sys table added

• schema_tables_with_full_table_scans-and-xschema_tables_with_full_table_scans-sys-schema-views sys table added

• session-and-xsession-sys-schema-views sys table added

• statement_analysis-and-xstatement_analysis-sys-schema-views sys table added

• statements_with_errors_or_warnings-and-xstatements_with_errors_or_warnings-sys-schema-views sys table added

• statements_with_full_table_scans-and-xstatements_with_full_table_scans-sys-schema-views sys table added

• statements_with_runtimes_in_95th_percentile-and-xstatements_with_runtimes_in_95th_percentile-sys-schema-view sys table added

• statements_with_sorting-and-xstatements_with_sorting-sys-schema-views sys table added

• statements_with_temp_tables-and-xstatements_with_temp_tables-sys-schema-views sys table added

• user_summary-and-xuser_summary-sys-schema-views sys table added

• user_summary_by_file_io-and-xuser_summary_by_file_io-sys-schema-views sys table added

• user_summary_by_file_io_type-and-xuser_summary_by_file_io_type-sys-schema-views sys table added

• user_summary_by_stages-and-xuser_summary_by_stages-sys-schema-views sys table added

• user_summary_by_statement_latency-and-xuser_summary_by_statement_latency-sys-schema-views sys table added

• user_summary_by_statement_type-and-xuser_summary_by_statement_type-sys-schema-views sys table added

• wait_classes_global_by_avg_latency-and-xwait_classes_global_by_avg_latency-sys-schema-views) sys table added

• wait_classes_global_by_latency-and-xwait_classes_global_by_latency-sys-schema-views sys table added

• waits_by_host_by_latency-and-xwaits_by_host_by_latency-sys-schema-views sys table added

• waits_by_user_by_latency-and-xwaits_by_user_by_latency-sys-schema-views sys table added

• waits_global_by_latency-and-xwaits_global_by_latency-sys-schema-views sys table added

Platforms

In alignment to the enterprise lifecycle, MariaDB Enterprise Server 10.6.4-1 is provided for:

• CentOS 7

• Debian 9

• Debian 10

• Microsoft Windows

• Red Hat Enterprise Linux 7

• Red Hat Enterprise Linux 8

• SUSE Linux Enterprise Server 12

• SUSE Linux Enterprise Server 15

• Ubuntu 18.04

• Ubuntu 20.04

Some components of MariaDB Enterprise Server might not support all platforms. For additional information, see "MariaDB Corporation Engineering Policies".

Installation Instructions

• Deploy MariaDB Enterprise with Repositories

• Deploy MariaDB Enterprise with Package Tarballs

• Deploy MariaDB Enterprise with Docker

Upgrade Instructions

• Upgrade to MariaDB Enterprise Server 10.6

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}