MariaDB 11.5 was a rolling release, and is no longer maintained.
MariaDB 11.5 is an old rolling release and is no longer maintained. Please use a more recent release.
The most recent release of MariaDB 11.5 is:MariaDB 11.5.2 Stable (GA) Download Now
MariaDB 11.5 is a previous rolling release.
There are two system variables used for controlling this feature:
max_tmp_session_space_usage: Limits the temporary space allowance per user
max_tmp_total_space_usage: Limits the temporary space allowance for all users.
The TIMESTAMP range of values was extended. The maximal allowed value for timestamps was '2038-01-19 03:14:07 UTC', and is now '2106-02-07 06:28:15 UTC'. This does not change the storage format, and new tables can be read by old MariaDB servers as long as timestamp values are within the old timestamp range. At the moment this is only supported on 64-bit platforms (MDEV-32188).
Index condition pushdown is now supported for partitioned tables (MDEV-12404)
ANALYZE for statement should show selectivity of pushed index condition (MDEV-18478)
Permit bulk implementation to return ALL individual results (MDEV-30366)
Send initial values of system variables in first OK packet (MDEV-31609)
New USERS table in the Information Schema for storing information about users, password expiry, and the limits set by max_password_errors (MDEV-23729, MDEV-32218)
Add more columns to Information Schema TABLE_STATISTICS, CLIENT_STATISTICS and USER STATISTICS tables (MDEV-33151)
Add QUERIES column to Information Schema INDEX_STATISTICS table (MDEV-33152)
Provide InnoDB async IO statistics (MDEV-32841)
Including a number of status variables.
Extend Query Response Time plugin to be compatible with Percona server (MDEV-33501)
Additional features for Sequences (MDEV-28152)
CREATE SEQUENCE ... AS permits creating as any INT type (including BIGINT UNSIGNED), extending the range
ANALYZE TABLE on sequences no longer attempts to collect statistics (MDEV-33938)
Deprecate and ignore the alter_algorithm system variable (MDEV-33655)
Change default Unicode collation to uca1400_ai_ci, a modern Unicode collation with proper support for SMP characters (including emoji)(MDEV-25829)
Parallel dump of multiple databases via mariadb-dump with the --dir
option (MDEV-33625)
Deprecate spider_casual_read (MDEV-31789)
The following deprecated features have been removed:
... COMPRESSED...
the correct syntax is COMPRESSED... ...
integer latches in OQGraph (and the related oqgraph_allow_create_integer_latch variable).
For a list of all new variables, see System Variables Added in MariaDB 11.5 and Status Variables Added in MariaDB 11.5.
For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the Security Vulnerabilities Fixed in MariaDB page. Add listcve macro here - removed for performance reasons
This page is licensed: CC BY-SA / Gnu FDL
DownloadRelease NotesChangelogOverview of 11.5
Alternate download from mariadb.org
Release date: 14 Aug 2024
MariaDB 11.5.2 is a Stable (GA) release. It is an evolution of MariaDB 11.4 with several entirely new features.
MariaDB 11.5 is a rolling release. One is expected to upgrade to MariaDB 11.6.2, there will be no 11.5.3.
For an overview of MariaDB 11.5 see theWhat is MariaDB 11.5? page.
Thanks, and enjoy MariaDB!
ALTER TABLE...ALGORITHM=COPY now builds indexes more efficiently (MDEV-33087)
Unsetting the innodb_alter_copy_bulk system variable restores the old behavior.
Fix unexpected storage read IO for the redo log, reintroduce innodb_log_write_ahead_size (MDEV-33894)
Correctly terminate transaction early with ER_LOCK_TABLE_FULL when lock memory is growing (MDEV-34167)
Alter operation on redundant table no longer aborts the server (MDEV-34222)
Fix MariaDB crash with SIGILL because the OS does not support AVX512 (MDEV-34565)
Fix InnoDB: Failing assertion: stat_n_leaf_pages > 0
in ha_innobase::estimate_rows_upper_bound
(MDEV-34474)
wait_for_read in buf_page_get_low no longer hurts performance (MDEV-34458)
Fix InnoDB: Assertion failure in file ./storage/innobase/page/page0zip.cc line 4211 (MDEV-34357)
Fix Aria index corruption when doing a REPAIR TABLE that has a size of over 4G (MDEV-34522)
UBSAN: runtime error: applying non-zero offset in spider_free_mem
and SIGSEGV in spider_free_mem
on SELECT (MDEV-31475)
SIGSEGV in ha_resolve_storage_engine_name
, UBSAN: runtime error: index 4294967295 out of bounds for type 'st_plugin_int *[64]' (MDEV-32487)
SIGSEGV in spider_db_conn::fin_loop_check
, and ASAN: heap-use-after-free in spider_db_mbase::fin_loop_check
on SHOW TABLE STATUS (MDEV-34541)
SIGSEGV in ha_spider::lock_tables
on BEGIN after table lock (MDEV-29962)
SIGSEGV in spider_conn_first_link_idx
and others on DELETE, INSERT and SELECT (MDEV-32492)
Spider: Crashes, asserts, hangs, memory corruptions and ASAN heap-use-after-free's (MDEV-27902)
Spider: @@insert_id 128
to TINYINT: Assertion ``!is_set() || (m_status == DA_OK_BULK && is_bulk_op())'` failed. (MDEV-28105)
ASAN errors in spider_db_free_result
after partition DDL (MDEV-29027)
Server crashes when calling spider UDF after aria_encrypt_tables
is enabled (MDEV-34682)
SIGSEGV in parse_engine_part_options
on INSERT, SELECT or ALTER (MDEV-34421)
Assertion ``auto_increment_value'failed in
ha_partition::info` on INSERT into MEMORY table (MDEV-24610)
On startup: UBSAN: applying zero offset to null pointer in my_copy_fix_mb
from strings/ctype-mb.c
and other locations (MDEV-34226)
On startup: UBSAN: runtime error: applying zero offset to null pointer in skip_trailing_space
and my_hash_sort_utf8mb3_general1400_nopad_as_ci
(MDEV-34187)
SHOW CREATE DATABASE statement crashes the server when db name contains some unicode characters, ASAN stack-buffer-overflow (MDEV-32376)
Wrong result set with utf8mb4_danish_ci
and BNLH join (MDEV-34417)
On startup: UBSAN: runtime error: applying non-zero offset in JOIN::make_aggr_tables_info
in sql/sql_select.cc (MDEV-34227)
Crash after killing query while it is processed by test_quick_select
(MDEV-30651)
Extend condition normalization to include 'NOT a'
(MDEV-19520)
Constant subquery causing a crash in pushdown optimization (MDEV-29363)
Crash when pushing condition with CHARSET()/COERCIBILITY() into derived table (MDEV-33010)
2nd execution name resolution problem with pushdown into unions (MDEV-34506)
Assertion ``(key_part->key_part_flag & 4) == 0'` failed key_hashnr (MDEV-34580)
Crash caused by query containing constant having clause (MDEV-23983)
Using NAME_CONST() (or executing query from the stored procedure and referring to a local variable) changes the plan and may make execution slower (MDEV-33971)
ORDER BY DESC
causes ROWID Filter optimization performance degradation (MDEV-33875)
Auto-generated DELETE from HEAP table no longer breaks replication (MDEV-25607)
Fix replication failure when XA transactions are used where the replica has replicate_do_db set and the client has touched a different database when running DML such as inserts. (MDEV-33921)
Fix replication error when CHANGE MASTER TO is used in conjunction with a password longer than 41 ascii characters (MDEV-23857)
The --init-rpl-role option is utilized to avoid a possible error state in semisync recovery (MDEV-33465)
Hide password passed on commandline from xtrabackup_info
(MDEV-34434)
Galera updated to 26.4.19
galera_gtid_2_cluster
: Assertion ``thd->wsrep_next_trx_id() != (0x7fffffffffffffffLL * 2ULL + 1)'` (MDEV-32633)
table gtid_slave_pos
entries never been deleted with wsrep_gtid_mode = 0
(MDEV-34170)
Deadlock found when trying to get lock during applying (MDEV-31658)
Change error code for Galera unkillable threads (MDEV-12008)
10.11.8 cluster becomes inconsistent when using composite primary key and partitioning (MDEV-34269)
wsrep_sst_mariadb-backup
use /tmp
dir during SST rather then user defined tmpdir
(MDEV-32158)
server_uid system variable added, and value added to the error log at startup (MDEV-34494)
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 11.5 for Debian 10 "Buster", RHEL/CentOS 7, Ubuntu 23.10 "Mantic", and Fedora 38
Repositories for Ubuntu 24.04 "Noble" have been added
IMPORT TABLESPACE no longer unnecessarily traverses tablespaces list (MDEV-34670)
Fix unknown variable defaults-group-suffix=
with mariadb-secure-installation (MDEV-33265)
mariadb-install-db no longer hangs on macOS (MDEV-34129)
Fix transaction termination with ER_LOCK_TABLE_FULL when lock memory is growing (MDEV-34167)
Disable new connections in case of fatal signal (MDEV-34475)
Control over memory allocated for SP/PS (MDEV-14959)
Triggers now work correctly with bulk insert (MDEV-24411)
Fix assertion ``table->field[0]->ptr >= table->record[0] && table->field[0]->ptr <= table->record[0] + table->s->reclength'failed in
void handler::assert_icp_limitations(uchar*)` (MDEV-34632)
sandbox mode - now compatible with --binary-mode (MDEV-34203)
Fixes for the following security vulnerabilities:
CVE-`-```
For a complete list of changes made in MariaDB 11.5.2, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 11.5.2, see the MariaDB Foundation release announcement.
This page is licensed: CC BY-SA / Gnu FDL
The most recent release of MariaDB 11.5 is:MariaDB 11.5.2 Stable (GA) Download Now
Download 11.5.1Release NotesChangelogOverview of 11.5
Release date: 30 May 2024
Do not use non-stable (non-GA) releases in production!
MariaDB 11.5 is a development version of the MariaDB rolling release. It is an evolution of MariaDB 11.4 with several entirely new features.
MariaDB 11.5.1 is a Release Candidate (RC) release.
For an overview of MariaDB 11.5 see theWhat is MariaDB 11.5? page.
Thanks, and enjoy MariaDB!
There are two system variables used for controlling this feature:
max_tmp_session_space_usage: Limits the temporary space allowance per user.
max_tmp_total_space_usage: Limits the temporary space allowance for all users.
The TIMESTAMP range of values was extended. The maximal allowed value for timestamps was '2038-01-19 03:14:07 UTC', and is now '2106-02-07 06:28:15 UTC'. This does not change the storage format, and new tables can be read by old MariaDB servers as long as timestamp values are within the old timestamp range. At the moment this is only supported on 64-bit platforms (MDEV-32188).
Index condition pushdown is now supported for partitioned tables (MDEV-12404)
ANALYZE FORMAT=JSON now shows selectivity of pushed index condition (MDEV-18478)
Permit bulk implementation to return ALL individual results (MDEV-30366)
Send initial values of system variables in first OK packet (MDEV-31609)
New USERS table in the Information Schema for storing information about users, password expiry, and the limits set by max_password_errors (MDEV-23729, MDEV-32218)
Add more columns to Information Schema TABLE_STATISTICS, CLIENT_STATISTICS and USER STATISTICS tables (MDEV-33151)
Add QUERIES column to Information Schema INDEX_STATISTICS table (MDEV-33152)
Provide InnoDB async IO statistics (MDEV-32841)
Extend Query Response Time plugin to be compatible with Percona server (MDEV-33501)
Additional features for Sequences (MDEV-28152)
CREATE SEQUENCE ... AS permits creating as any INT type (including BIGINT UNSIGNED), extending the range
ANALYZE TABLE on sequences no longer attempts to collect statistics (MDEV-33938)
Introduce the innodb_log_spin_wait_delay system variable to address excessive context switching caused by log_sys.lsn_lock (observed on write-intensive workloads on NUMA systems) (MDEV-33515)
Deprecate and ignore the alter_algorithm system variable (MDEV-33655)
Change default Unicode collation to uca1400_ai_ci (MDEV-25829)
Parallel dump of multiple databases via mariadb-dump with the --dir
option (MDEV-33625)
Deprecate spider_casual_read (MDEV-31789)
Fixes for the following security vulnerabilities:
CVE-`-```
For a complete list of changes made in MariaDB 11.5.1, with links to detailed information on each push, see the changelog.
For a full list of contributors to MariaDB 11.5.1, see the MariaDB Foundation release announcement.
This page is licensed: CC BY-SA / Gnu FDL
The most recent release of MariaDB 11.5 is:MariaDB 11.5.2 Stable (GA) Download Now
Download 11.5.0Release NotesChangelogOverview of 11.5
Release date: 18 March 2024
Do not use alpha releases in production!
MariaDB 11.5 is an upcoming development series of MariaDB. It is an evolution of MariaDB 11.4 with several entirely new features.
MariaDB 11.5.0 is a single preview release. Features are to be considered preview, and none are guaranteed to make it into MariaDB 11.5.
The preview is available as a container quay.io/mariadb-foundation/mariadb-devel:11.5-preview.
For an overview of MariaDB 11.5 see theWhat is MariaDB 11.5? page.
Thanks, and enjoy MariaDB!
There are two system variables used for controlling this feature:
max_tmp_space_usage: Limits the temporary space allowance per user
max_total_tmp_space_usage: Limits the temporary space allowance for all users.
The TIMESTAMP range of values was extended. The maximal allowed value for timestamps was '2038-01-19 03:14:07 UTC', and is now '2106-02-07 06:28:15 UTC'. This does not change the storage format, and new tables can be read by old MariaDB servers as long as timestamp values are within the old timestamp range. At the moment this is only supported on 64-bit platforms (MDEV-32188).
Index condition pushdown is now supported for partitioned tables (MDEV-12404)
ANALYZE FORMAT=JSON now shows selectivity of pushed index condition (MDEV-18478)
Permit bulk implementation to return ALL individual results (MDEV-30366)
Send initial values of system variables in first OK packet (MDEV-31609)
New USERS table in the Information Schema for storing information about users, password expiry, and the limits set by max_password_errors (MDEV-23729, MDEV-32218)
Add more columns to Information Schema TABLE_STATISTICS, CLIENT_STATISTICS and USER STATISTICS tables (MDEV-33151)
Add QUERIES column to Information Schema INDEX_STATISTICS table (MDEV-33152)
Provide InnoDB async IO statistics (MDEV-32841)
Including a number of status variables.
Show variable deprecation for mariadbd --help output (MDEV-28671)
Extend Query Response Time plugin to be compatible with Percona server (MDEV-33501)
New variable, log_slow_always_query_time for additional control over what is logged to the slow query log. This setting did not make it into MariaDB 11.5, but was added in MariaDB 11.7 (MDEV-33144)
Additional features for Sequences (MDEV-28152)
CREATE SEQUENCE ... AS permits creating as any INT type (including BIGINT UNSIGNED), extending the range
Deprecate and ignore the alter_algorithm system variable (MDEV-33655)
Change default Unicode collation to uca1400_ai_ci, a modern Unicode collation with proper support for SMP characters (including emoji)(MDEV-25829)
Parallel dump of multiple databases via mariadb-dump with the --dir
option (MDEV-33625)
Deprecate spider_casual_read (MDEV-31789)
This page is licensed: CC BY-SA / Gnu FDL