MariaDB Enterprise Server 11.8.5-2 is a Stable (GA) maintenance release of MariaDB Enterprise Server 11.8, released on 2025-12-11
Release date: 11 Dec 2025
MariaDB Enterprise Server 11.8.5-2 is a Stable (GA) maintenance release of MariaDB Enterprise Server 11.8.
This release incorporates MariaDB ColumnStore engine version 25.10.2
updated to 26.4.24
NOTE: Includes increasing the GCS protocol version, which prevents downgrades of individual nodes in the cluster as soon as all nodes have been updated
Due to the impending EOL of Windows 10 22H2, and Windows 11 23H2, this will be the last release supporting these releases
The PrivateDevices=false
Failure to detect corruption during backups of Aria table ()
DDL in procedure propagates no locking to tables locked by DML ()
Assertion `table_share->tmp_table != NO_TMP_TABLE || m_lock_type == 1' failed upon REBUILD PARTITION ()
SIGSEGV in replace_user_table when changing mysql db tables ()
SIGSEGV in replace_db_table on GRANT ()
LIMIT ROWS EXAMINED prematurely triggers during optimization ()
Corrected the creation of views on JSON_TABLEs to require no special privileges. ()
wsrep_store_key_val_for_row() may invoke memcpy() on nullptr ()
UPDATE/DELETE of single table queries would now show r_table_time_ms, and r_other_time_ms during ANALYZE FORMAT=JSON ()
Multiple versions of MariaDB Enterprise Server are now available in the package repositories ()
For Debian and Ubuntu, see the section of the page for details on how to install old versions from the deb repositories
For RHEL/Alma/Rocky, see the section of the page for details on how to install old versions from the rpm repositories
Workloads that are bound by innodb_log_file_size would write out unnecessarily many data pages in an attempt to advance the log checkpoint. ()
Query does not recognize advantage of using primary key index ()
The locking in the audit plugin was simplified in order to remove some scalability bottlenecks. ()
REPLACE on a precise-versioned table returns duplicate key error (ER_DUP_ENTRY) ()
Wrong result when split optimization is used for grouping with order by and limit ()
Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed after ALTER TABLE of versioned table ()
Exchange partition with virtual columns fails ()
For the complete list of changes in this release, see the .
In alignment to the enterprise lifecycle, MariaDB Enterprise Server 11.8.5-2 is provided for:
AlmaLinux 8 (x86_64, ARM64)
AlmaLinux 9 (x86_64, ARM64)
AlmaLinux 10 (x86_64, ARM64)
Debian 12 (x86_64, ARM64)
Some components of MariaDB Enterprise Server are supported on a subset of platforms. See for details.
systemdThe HashiCorp Key Management Plugin has been updated to provide robust stability against Vault communication failures:
The plugin is now configured to use cached keys for all communication errors (not just timeouts), ensuring continuous operation when the Vault server is temporarily unreachable.
The default setting for using the cache on errors is now ON.
The default key cache timeout () has been increased to its maximum practical value (e.g., one year in milliseconds), maximizing key availability in the cache during extended service interruptions. ()
Prevent MariaDB server crash when a query includes a derived table containing unnamed column. (MDEV-24588)
SIGSEGV in replace_table_table on GRANT (MDEV-24814)
Crash when calling stored function in FOR loop argument (MDEV-26115)
Spider: Assertion `inited==RND' failed in handler::ha_rnd_end on DELETE (MDEV-26540)
Several bugs in SPATIAL INDEX page splitting logic could crash InnoDB if the PRIMARY KEY or the SPATIAL data is variable-length. (MDEV-27675)
SIGSEGV in replace_routine_table on GRANT (MDEV-27842)
Setting wsrep_slave_threads causes thread hang (MDEV-30418)
InnoDB could crash if the definition of the InnoDB persistent statistics tables were incorrect. (MDEV-31740)
Correlated derived table query merges can cause crashes, especially with prepared statements. (MDEV-32294)
Server crash on cleanup of non-fully-constructed-due-to-an-error CTE (MDEV-32308)
Crash if subquery is a UNION of SELECT rand() and uncorrelated SELECT (MDEV-32403)
JSON_ARRAY_INTERSECT function crashes the server when called with empty json arrays, UBSAN runtime error: member access within null pointer of type 'struct String' in Item_func_json_array_intersect::prepare_json_and_create_hash (MDEV-33149)
Errors or assertion failure upon REPAIR on partitioned Aria table with misplaced rows (MDEV-33190)
Assertion `0' failed in void wsrep::transaction::state(wsrep::unique_lockwsrep::mutex&, wsrep::transaction::state) (MDEV-33250)
Assertion `! thd->in_sub_stmt' failed in bool trans_rollback_stmt(THD*) (MDEV-34117)
Assertion `ist_seqno >= cc_seqno' failed in galera_vote_rejoin_dml (MDEV-35964)
Mariadb server crashed during insert (MDEV-36134)
InnoDB could potentially crash if there is any lock conflict on an internal FTS_%_CONFIG table of a FULLTEXT INDEX while one of the INFORMATION_SCHEMA views INNODB_TRX, INNODB_LOCKS, or INNODB_LOCK_WAITS are being accessed. (MDEV-36545)
Assertion `bulk_insert == TRX_NO_BULK' failed in trx_t::assert_freed from innodb_shutdown (MDEV-36771)
json_array_intersect previously crashed when there was an unused table reference in the SQL query. (MDEV-36809)
Assertion `client_state.transaction().active()' failed in int wsrep_thd_append_key(THD*, const wsrep_key*, int, Wsrep_service_key_type) (MDEV-36909)
SIGSEGV in wsrep_check_sequence | mysql_alter_table (MDEV-37056)
sql/wsrep_allowlist_service.cc:40:27: runtime error: member call on null pointer of type 'Wsrep_schema' (MDEV-37136)
Fixed crashing bug when inserting into a tables with several nextval(sequence) default values. (MDEV-37172)
When the server was started in read-only mode with encryption enabled, the fix ensures that InnoDB avoids creating any encryption thread. Testing: encryption.innodb-read-only(MTR Test) contains scenario that can be used to test this change. (MDEV-37299)
Item_func_nextval::val_int() crash on INSERT...SELECT with subqueries (MDEV-37345)
Inconsistency detected - create sequence (MDEV-37366)
InnoDB: Failing assertion: node->pcur->rel_pos == BTR_PCUR_ON (MDEV-37404)
Parallel replica worker crashes during backup at retrying (MDEV-37453)
Fix crash by correctly updating SP instruction state after instruction re-parsing , preventing dangling reference. (MDEV-37489)
ASAN errors in find_type2 upon executing a procedure from sys schema (MDEV-37710)
In rare cases, shutdown might hang (MDEV-37728)
Galera replication does not preserve the character set and collation associated with views, etc. (MDEV-37857)
Assertion `0' failed in int wsrep::transaction::before_rollback() (MDEV-37935)
Item_func_hex doesn't check for max_allowed_packet (MDEV-37947)
MDL conflict between CREATE TRIGGER and INSERT (MDEV-37965)
Galera cluster crashes when granting permission to non existing user after setting max_error_count and wsrep_ignore_apply_errors to zero (MDEV-37991)
Galera nodes should operate when transaction-read-only=ON (MDEV-38073)
Assertion `level != Sql_condition::WARN_LEVEL_ERROR' failed in void push_warning(THD*, Sql_state_errno_level::enum_warning_level, uint, const char*) (MDEV-38201)
MDL conflict between XA and DDL in MariaDB Enterprise Cluster (MENT-2405)
Race of rolling back and committing transaction to binlog (MENT-2448)
For large transactions (i.e. those whose data exceeds the binlog_cache_size limit and spills into tmp files), provides a general performance improvement and fixes a bug that would lead to binlog corruption where the large transaction would have its GTID written into the binary log, without any additional transaction data, if the server's --tmp-dir was full. (MENT-2451)
With --encrypt-binlog=ON if a node fails to apply a writeset it will crash the whole cluster due to a bug in Galera library encryption handling. Fixed in Galera library. (MENT-2474)
ALTER TABLE could fail to update InnoDB persistent statistics. (MDEV-35163)
ALTER TABLE tbl_a ADD PARTITION (PARTITION pt2) MSAN uninitalized read (MDEV-36723)
Killed query with side effects without error (MDEV-37198)
InnoDB partition table disallow local GTIDs in galera (MDEV-37373)
mariadb-dump -T did not encode table names like the server did for frm files, so some tables can be created in the server, but not dumped with mariadb-dump -T, for example, a table con on Windows. (MDEV-37483)
wsrep_allowlist allows all connections during SST (MDEV-37548)
CHECK TABLE…EXTENDED could flag bogus corruption on a column prefix index. (MDEV-37659)
Table Charset Mismatch (Primary/Replica) via Event (MDEV-37744)
Under selinux, the galera SST port checking resulted in excessive AVC notices. This has been simplified under selinux. (MDEV-37899)
ALTER TABLE ... ENGINE=MRG_MyISAM is now properly logged as an DDL. This ensure that the changed MERGE table cannot be used by a slave thread until after the ALTER command has been executed. (MDEV-37903)
disable_index_merge_plans causes SELECT data loss when more than 100 ORs (MDEV-37913)
very long query cannot be killed quickly (MDEV-37938)
If the server was killed during an operation that creates a .ibd file, such as TRUNCATE TABLE, it could fail to recover. (MDEV-37994)
If the user specifies some tls-related parameters in spider table creation with odbc/mariadb backend, these parameters could be ill-formatted in the odbc connection string, causing them to be ignored by the driver. (MENT-2407)
Parameterized PS converts error to warning, causes replication problems (MDEV-34046)
View containing JSON_TABLE does not return JSON (MDEV-34081)
Wrong result json_table (MDEV-36319)
Fix COALESCE and IFNULL functions to use - (i) argument nullness, (ii) type conversion safety of fallback values to decide nullability of result. (MDEV-36851)
Correct return value of JSON_VALUE which in the previous release, incorrectly converted a valid empty string return value to a NULL. This has been reverted to correct behaviour. (MDEV-37428)
Wrong query_ids in server_audit plugin not reflecting reality (MDEV-37434)
Fix server_audit rwlock Performance Schema instrumentation (MDEV-37555)
IS TRUE incorrectly converts outer join to inner (MDEV-37653)
Spider: XA COMMIT ONE PHASE fails with "This xid does not exist" (MDEV-37829)
mysqli silently trims each json_arrayagg result to modulo 64KB (MDEV-37835)
Wrong result with Loose Scan on QUICK_GROUP_MIN_MAX_SELECT WITH TIES (MDEV-37901)
Oracle Linux 8 (x86_64, ARM64)
Oracle Linux 9 (x86_64, ARM64)
Oracle Linux 10 (x86_64, ARM64)
Red Hat Enterprise Linux 8 (x86_64, ARM64)
Red Hat Enterprise Linux 9 (x86_64, ARM64, PPC64LE)
Red Hat Enterprise Linux 10 (x86_64, ARM64)
Rocky Linux 8 (x86_64, ARM64)
Rocky Linux 9 (x86_64, ARM64)
Rocky Linux 10 (x86_64, ARM64)
SUSE Linux Enterprise Server 15 (x86_64, ARM64)
Ubuntu 22.04 (x86_64, ARM64)
Ubuntu 24.04 (x86_64, ARM64)
Microsoft Windows (x86_64) (Without MariaDB Enterprise Cluster (Galera) support)
Red Hat UBI 8 (x86_64, ARM64)
Red Hat UBI 8 is part of the Enterprise Server Docker Image. It does not support MariaDB Enterprise Cluster (Galera) or MariaDB ColumnStore.
Release notes for MariaDB Enterprise Server 11.8 series releases
Log write buffering added to the and plugins (MENT-2438)
The buffering is controlled by the added variables:
server_audit_file_buffer_size - defines the size of the buffer. The default value is 0 meaning there's no buffering at all. Setting non-zero value enables the buffering with the buffer of the specified size aligned by 8192. The maximum value is 65536.
server_audit_sync_log_file - flushes the buffer to the log file. While the log record is in the buffer, it cannot be seen in the log file. And if there are not many events to log, the time before records can be observed can be significant. So user can do SET GLOBAL server_audit_log_file=1 to this variable to force write the buffer to the file, to make sure he doesn't miss the recent records.
Two new fields are available via SHOW REPLICA STATUS ()
Connects_Tried, which provides the number of attempts the replica has made to connect to the primary, and
Master_Retry_Count, which provides the number of times the replica will attempt to connect to a primary before giving up.
The authentication plugin caching_sha2_password has been added, not loaded by default ()
An overview of changes, improvements, and what's new in MariaDB Enterprise Server 11.8
MariaDB Enterprise Server 11.8 introduces a wide range of enhancements spanning developer productivity, security, compatibility, observability, and support for modern workloads like vector search. The MariaDB Enterprise Server 11.8.2-0 Technical Preview adds the innovations from the MariaDB Community Server releases 11.5 to 11.8 to MariaDB Enterprise Server 11.4.
MariaDB Enterprise Server 11.8 continues to expand its native vector search capabilities, positioning MariaDB for AI-powered applications such as semantic search and recommendation systems. Already available in the MariaDB Enterprise Server 11.4 are:
New Data Type: VECTOR(N) to store multi-dimensional embeddings.
Vector Indexing: Efficient similarity search with VECTOR INDEX.
Distance Functions:
VEC_DISTANCE_EUCLIDEAN() for L2 distance.
VEC_DISTANCE_COSINE() for angular similarity.
Conversion Functions:
Vec_FromText(json_array) and Vec_ToText(vector_column) transform between the text and binary vector formats.
for Index Tuning:
mhnsw_max_cache_size, mhnsw_default_distance, mhnsw_default_m, mhnsw_ef_search.
Distance Functions:
VEC_DISTANCE() auto-selects the best distance function based on the index configuration.
Optimization that makes vector search 30-50% (depending on the data) faster for the same recall. Enabled automatically for applicable vectors. Vectors are applicable if they can be gradually truncated to trade some recall for speed. For example matryoshka embeddings as produced by OpenAI are applicable.
UUID Generation: New functions UUID_v4() and UUID_v7() for modern and time-ordered UUIDs.
Multi-Table DELETE Enhancements: Support for ORDER BY and LIMIT.
Single-Table DELETE Enhancements: Now it allows index hints.
Optimization that makes vector search 30-50% faster (more details in the section)
Segmented key cache for
system variable
Add option to not collect statistics for long char/varchars, see for more information
UTF-8 by Default: utf8mb4 replaces latin1 and legacy utf8, ensuring full Unicode support, including emojis.
Default Collation: utf8mb4_uca1400_ai_ci is now the standard for Unicode character sets.
Extended TIMESTAMP Range: Increased upper bound to 2106 on 64-bit systems.
System Versioned Tables is a powerful feature for auditing changes to data. Enabling System Versioned Tables is as easy as creating a table by using
Or enabling the feature for an existing table by using
In both cases, invisible fields will be created in the table to track the timestamps and period for which the data is valid. A DBA/DevOps might want these fields to be visible. It is now possible to change such implicit fields to explicit ones by the following types of statements:
New :
Based on elliptic curve cryptography.
Mitigates the replay and man-in-the-middle attacks. Example on how to create a user using the new :
This will result in:
\
Improved Replication Lag Monitoring:
now includes:\
for :\
New Option – --slave-abort-blocking-timeout
Enhancement: The file_key_management plugin can now read keys from a Unix socket, not just from files.
File Key Management Encryption Plugin: Added key rotation capability; see for details. In addition, a new Information Schema table was added, .
Temporary File Disk Space Limits:
max_tmp_session_space_usage and max_tmp_total_space_usage prevent runaway disk usage.
New Status Variables: tmp_space_used, max_tmp_space_used.
Support for Oracle-stype INDEX BY tables (associative arrays) was backported from in stored routines and anonymous blocks, with this declaration syntax:
Where:
type_name supports explicit and anchored data types (e.g t1.col1%TYPE).
The INDEX BY clause supports integer and string data types.
rec_type_name supports scalar and record data types.
The implementation supports the following associative array methods:
FIRST
LAST
NEXT
PRIOR
mariadb-dump:
The --dir=<path> dumps each database to its subdirectory.
Supports parallel dumps and restores.
New --update-history
Improved Insights:
Index usage via QUERIES in INDEX_STATISTICS.
Query operation counts: ROWS_INSERTED, ROWS_UPDATED, KEY_READ_HITS, etc.
MariaDB Enterprise Server 11.8.2-0 Tech Preview
See also:
are possible now.
DBMS_OUTPUT: Messages submitted by DBMS_OUTPUT.PUT_LINE() are not sent to the client until the sending subprogram or trigger completes.
ROW Type Enhancements:
ROW types are now usable as stored function return values.
The support for %ROWTYPE, TYPE OF, and RECORD(...) declarations for Oracle-like compatibility:
Triggers:
BEFORE UPDATE OF col1, col2 limits trigger execution to specific column updates:
Use of SIGNAL SQLSTATE '02TRG' allows skipping a row operation.
Stored Procedures: Now support default parameter values:
Associative arrays: DECLARE TYPE .. TABLE OF .. INDEX BY
Added caching_sha2_password plugin, see for more information
Unix Socket Enhancements:
Now supports explicit OS user mapping via IDENTIFIED VIA UNIX_SOCKET AS 'user'.
It is also possible to specify more than one OS user with the usual OR syntax:
Galera SST Automation: SST user is now auto-created and managed internally.
Backported MDEV-35304 : Add {{Connects_Tried}} & {{Master_Retry_Count}} from CS-12.0
New Views:
SLAVE_STATUS to view replication lag via SQL.
for password state and expiration monitoring.
to introspect auto-generated sequences:\
Enhanced ANALYZE FORMAT=JSON:
Includes r_index_rows, r_icp_filtered.
Thread Naming for Diagnostics: Thread names are now more descriptive.
Galera Information Schema: New Information Schema table.
Galera Information Schema: New and Information Schema tables.
Galera Information Schema: New Information Schema table .
Galera Information Schema: New Information Schema and tables.
COUNT
EXISTS
DELETE
row_end TIMESTAMPsmariadb-import:
--dir=<path> restores from the dumped directory structure.
Supports --database, --table, --ignore-database, --ignore-table for selective restore.
--innodb-optimize-keys: defers index creation to speed up data loads.
mariadb-test (mtr):
mtr can be started with the --enable_serveroutput option to enable DBMS_OUTPUT messages. See for details.
mariadb (command-line client)
New --enable_serveroutput option to enable DBMS_OUTPUT messages at start time. See for details.
New serveroutput and noserveroutput command to enable and disable those messages at runtime. See for details.
New stats in CLIENT_STATISTICS and USER_STATISTICS.
Table I/O metrics: PAGES_ACCESSED, PAGES_READ_FROM_DISK.
Log write buffering added to the and plugins (MENT-2438)
The buffering is controlled by the added variables:
server_audit_file_buffer_size - defines the size of the buffer. The default value is 0 meaning there's no buffering at all. Setting non-zero value enables the buffering with the buffer of the specified size aligned by 8192. The maximum value is 65536.
server_audit_sync_log_file - flushes the buffer to the log file. While the log record is in the buffer, it cannot be seen in the log file. And if there are not many events to log, the time before records can be observed can be significant. So user can do SET GLOBAL server_audit_log_file=1 to this variable to force write the buffer to the file, to make sure he doesn't miss the recent records.
Two new fields are available via SHOW REPLICA STATUS ()
Connects_Tried, which provides the number of attempts the replica has made to connect to the primary, and
Master_Retry_Count, which provides the number of times the replica will attempt to connect to a primary before giving up.
The authentication plugin caching_sha2_password has been added, not loaded by default ()
DECLARE
TYPE DeptRecTyp IS RECORD (
dept_id NUMBER(4),
dept_name VARCHAR2(30),
mgr_id NUMBER(6),
loc_id NUMBER(4)
);CREATE TRIGGER mytrigger BEFORE UPDATE OF col1, col2 ON t1 FOR EACH ROW …CREATE OR REPLACE PROCEDURE p1(param1 INT, param2 INT DEFAULT 1)CREATE USER dba IDENTIFIED VIA UNIX_SOCKET AS 'jack' OR IDENTIFIED VIA UNIX_SOCKET AS 'jill';SELECT * FROM INFORMATION_SCHEMA.SEQUENCES\G
*************************** 1. row ***************************
SEQUENCE_CATALOG: def
SEQUENCE_SCHEMA: test
SEQUENCE_NAME: s_name
DATA_TYPE: tinyint
NUMERIC_PRECISION: 8
NUMERIC_PRECISION_RADIX: 2
NUMERIC_SCALE: 0
START_VALUE: 100
MINIMUM_VALUE: -127
MAXIMUM_VALUE: 126
INCREMENT: 10
CYCLE_OPTION: 0CREATE TABLE contracts (...) WITH SYSTEM VERSIONING;ALTER TABLE contracts ADD SYSTEM VERSIONING;SET @@system_versioning_alter_history= keep;
ALTER TABLE contracts ADD COLUMN rs TIMESTAMP(6) AS ROW START, ADD COLUMN re TIMESTAMP(6) AS ROW END, ADD PERIOD FOR SYSTEM_TIME (rs,re);CREATE USER 'MariaDBUser'@'%' IDENTIFIED VIA PARSEC USING PASSWORD('MyPassword123!');SHOW GRANTS FOR MariaDBUser@'%';Grants for MariaDBUser@%
GRANT USAGE ON *.* TO `MariaDBUser`@`%` IDENTIFIED VIA parsec USING 'P0:lhXyNv1cIxpB8EnTxR7ON7S7:1l3rWRW1/jw45yrvYXB8eh02wzk7lcJcz4CMc
Ww2b+8'Master_last_event_time
Slave_last_event_time
Master_Slave_time_diffMariaDB [test]> SELECT Master_last_event_time,Slave_last_event_time,Master_Slave_time_diff FROM information_schema.slave_status\G
*************************** 1. row ***************************
Master_last_event_time: 2024-08-13 07:32:38
Slave_last_event_time: 2024-08-13 07:32:37
Master_Slave_time_diff: 1TYPE type_name TABLE OF rec_type_name INDEX BY idx_type_name;MariaDB Enterprise Server 11.8.3-1 is the first Stable (GA) maintenance release of MariaDB Enterprise Server 11.8, released on 2025-10-22
Release date: 22 Oct 2025
MariaDB Enterprise Server 11.8.3-1 is the first Stable (GA) release of MariaDB Enterprise Server 11.8.
This release incorporates MariaDB ColumnStore engine version 25.10.0.
MariaDB Enterprise Server 11.8 continues to expand its native vector search capabilities, positioning MariaDB for AI-powered applications such as semantic search and recommendation systems. Already available in the MariaDB Enterprise Server 11.4 are:
New Data Type: VECTOR(N) to store multi-dimensional embeddings.
Vector Indexing: Efficient similarity search with VECTOR INDEX.
Distance Functions:
Distance Functions:
VEC_DISTANCE() auto-selects the best distance function based on the index configuration.
Optimization that makes vector search 30-50% (depending on the data) faster for the same recall. Enabled automatically for applicable vectors. Vectors are applicable if they can be gradually truncated to trade some recall for speed. For example matryoshka embeddings as produced by OpenAI are applicable.
UUID Generation: New functions UUID_v4() and UUID_v7() for modern and time-ordered UUIDs.
Multi-Table DELETE Enhancements: Support for ORDER BY and LIMIT.
Single-Table DELETE Enhancements: Now it allows index hints.
Optimization that makes vector search 30-50% faster (more details in the section)
Segmented key cache for
system variable
Add option to not collect statistics for long char/varchars, see for more information
UTF-8 by Default: utf8mb4 replaces latin1 and legacy utf8, ensuring full Unicode support, including emojis.
Default Collation: utf8mb4_uca1400_ai_ci is now the standard for Unicode character sets.
Extended TIMESTAMP Range: Increased upper bound to 2106 on 64-bit systems.
System Versioned Tables is a powerful feature for auditing changes to data. Enabling System Versioned Tables is as easy as creating a table by using
Or enabling the feature for an existing table by using
In both cases, invisible fields will be created in the table to track the timestamps and period for which the data is valid. A DBA/DevOps might want these fields to be visible. It is now possible to change such implicit fields to explicit ones by the following types of statements:
New :
Based on elliptic curve cryptography.
Mitigates the replay and man-in-the-middle attacks. Example on how to create a user using the new :
This will result in:
\
Improved Replication Lag Monitoring:
now includes:\
for :\
New Option – --slave-abort-blocking-timeout
Enhancement: The file_key_management plugin can now read keys from a Unix socket, not just from files.
File Key Management Encryption Plugin: Added key rotation capability; see for details. In addition, a new Information Schema table was added, .
Temporary File Disk Space Limits:
max_tmp_session_space_usage and max_tmp_total_space_usage prevent runaway disk usage.
New Status Variables: tmp_space_used, max_tmp_space_used.
Support for Oracle-stype INDEX BY tables (associative arrays) was backported from in stored routines and anonymous blocks, with this declaration syntax:
Where:
type_name supports explicit and anchored data types (e.g t1.col1%TYPE).
The INDEX BY clause supports integer and string data types.
rec_type_name supports scalar and record data types.
The implementation supports the following associative array methods:
FIRST
LAST
NEXT
PRIOR
mariadb-dump:
The --dir=<path> dumps each database to its subdirectory.
Supports parallel dumps and restores.
New --update-history
Improved Insights:
Index usage via QUERIES in INDEX_STATISTICS.
Query operation counts: ROWS_INSERTED, ROWS_UPDATED, KEY_READ_HITS, etc.
For the complete list of changes in this release, see the .
In alignment to the , MariaDB Enterprise Server 11.8.3-1 is provided for:
AlmaLinux 8 (x86_64, ARM64)
AlmaLinux 9 (x86_64, ARM64)
AlmaLinux 10 (x86_64, ARM64)
Debian 11 (x86_64, ARM64)
Some components of MariaDB Enterprise Server are supported on a subset of platforms. See for details.
VEC_DISTANCE_EUCLIDEAN() for L2 distance.
VEC_DISTANCE_COSINE() for angular similarity.
Conversion Functions:
Vec_FromText(json_array) and Vec_ToText(vector_column) transform between the text and binary vector formats.
for Index Tuning:
mhnsw_max_cache_size, mhnsw_default_distance, mhnsw_default_m, mhnsw_ef_search.
are possible now.
DBMS_OUTPUT: Messages submitted by DBMS_OUTPUT.PUT_LINE() are not sent to the client until the sending subprogram or trigger completes.
ROW Type Enhancements:
ROW types are now usable as stored function return values.
The support for %ROWTYPE, TYPE OF, and RECORD(...) declarations for Oracle-like compatibility:
Triggers:
BEFORE UPDATE OF col1, col2 limits trigger execution to specific column updates:
Use of SIGNAL SQLSTATE '02TRG' allows skipping a row operation.
Stored Procedures: Now support default parameter values:
Associative arrays: DECLARE TYPE .. TABLE OF .. INDEX BY
Added caching_sha2_password plugin, see for more information
Unix Socket Enhancements:
Now supports explicit OS user mapping via IDENTIFIED VIA UNIX_SOCKET AS 'user'.
It is also possible to specify more than one OS user with the usual OR syntax:
Galera SST Automation: SST user is now auto-created and managed internally.
Backported MDEV-35304 : Add {{Connects_Tried}} & {{Master_Retry_Count}} from CS-12.0
New Views:
SLAVE_STATUS to view replication lag via SQL.
for password state and expiration monitoring.
to introspect auto-generated sequences:\
Enhanced ANALYZE FORMAT=JSON:
Includes r_index_rows, r_icp_filtered.
Thread Naming for Diagnostics: Thread names are now more descriptive.
Galera Information Schema: New Information Schema table.
Galera Information Schema: New and Information Schema tables.
Galera Information Schema: New Information Schema table .
Galera Information Schema: New Information Schema and tables.
COUNT
EXISTS
DELETE
row_end TIMESTAMPsmariadb-import:
--dir=<path> restores from the dumped directory structure.
Supports --database, --table, --ignore-database, --ignore-table for selective restore.
--innodb-optimize-keys: defers index creation to speed up data loads.
mariadb-test (mtr):
mtr can be started with the --enable_serveroutput option to enable DBMS_OUTPUT messages. See for details.
mariadb (command-line client)
New --enable_serveroutput option to enable DBMS_OUTPUT messages at start time. See for details.
New serveroutput and noserveroutput command to enable and disable those messages at runtime. See for details.
New stats in CLIENT_STATISTICS and USER_STATISTICS.
Table I/O metrics: PAGES_ACCESSED, PAGES_READ_FROM_DISK.
Debian 13 (x86_64, ARM64)
Microsoft Windows (x86_64) (MariaDB Enterprise Cluster excluded)
Oracle Linux 8 (x86_64, ARM64)
Oracle Linux 9 (x86_64, ARM64)
Oracle Linux 10 (x86_64, ARM64)
Red Hat Enterprise Linux 8 (x86_64, ARM64)
Red Hat Enterprise Linux 9 (x86_64, ARM64, PPC64LE)
Red Hat Enterprise Linux 10 (x86_64, ARM64)
Rocky Linux 8 (x86_64, ARM64)
Rocky Linux 9 (x86_64, ARM64)
Rocky Linux 10 (x86_64, ARM64)
SUSE Linux Enterprise Server 15 (x86_64, ARM64)
Ubuntu 22.04 (x86_64, ARM64)
Ubuntu 24.04 (x86_64, ARM64)
Microsoft Windows (x86_64) (Without MariaDB Enterprise Cluster (Galera) support)
Red Hat UBI 8 (x86_64, ARM64)
Red Hat UBI 8 is part of the Enterprise Server Docker Image. It does not support MariaDB Enterprise Cluster (Galera) or MariaDB ColumnStore.
DECLARE
TYPE DeptRecTyp IS RECORD (
dept_id NUMBER(4),
dept_name VARCHAR2(30),
mgr_id NUMBER(6),
loc_id NUMBER(4)
);CREATE TRIGGER mytrigger BEFORE UPDATE OF col1, col2 ON t1 FOR EACH ROW …CREATE OR REPLACE PROCEDURE p1(param1 INT, param2 INT DEFAULT 1)CREATE USER dba IDENTIFIED VIA UNIX_SOCKET AS 'jack' OR IDENTIFIED VIA UNIX_SOCKET AS 'jill';SELECT * FROM INFORMATION_SCHEMA.SEQUENCES\G
*************************** 1. row ***************************
SEQUENCE_CATALOG: def
SEQUENCE_SCHEMA: test
SEQUENCE_NAME: s_name
DATA_TYPE: tinyint
NUMERIC_PRECISION: 8
NUMERIC_PRECISION_RADIX: 2
NUMERIC_SCALE: 0
START_VALUE: 100
MINIMUM_VALUE: -127
MAXIMUM_VALUE: 126
INCREMENT: 10
CYCLE_OPTION: 0CREATE TABLE contracts (...) WITH SYSTEM VERSIONING;ALTER TABLE contracts ADD SYSTEM VERSIONING;SET @@system_versioning_alter_history= keep;
ALTER TABLE contracts ADD COLUMN rs TIMESTAMP(6) AS ROW START, ADD COLUMN re TIMESTAMP(6) AS ROW END, ADD PERIOD FOR SYSTEM_TIME (rs,re);CREATE USER 'MariaDBUser'@'%' IDENTIFIED VIA PARSEC USING PASSWORD('MyPassword123!');SHOW GRANTS FOR MariaDBUser@'%';Grants for MariaDBUser@%
GRANT USAGE ON *.* TO `MariaDBUser`@`%` IDENTIFIED VIA parsec USING 'P0:lhXyNv1cIxpB8EnTxR7ON7S7:1l3rWRW1/jw45yrvYXB8eh02wzk7lcJcz4CMc
Ww2b+8'Master_last_event_time
Slave_last_event_time
Master_Slave_time_diffMariaDB [test]> SELECT Master_last_event_time,Slave_last_event_time,Master_Slave_time_diff FROM information_schema.slave_status\G
*************************** 1. row ***************************
Master_last_event_time: 2024-08-13 07:32:38
Slave_last_event_time: 2024-08-13 07:32:37
Master_Slave_time_diff: 1TYPE type_name TABLE OF rec_type_name INDEX BY idx_type_name;This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.