MariaDB 10.8 is a previous short-term maintenance stable series of MariaDB, maintained until May 2023. It is an evolution of MariaDB 10.7 with several entirely new features.
The server no longer tolerates incorrectly configured SSL (). If you have enabled SSL in my.cnf but have not configured it properly (for example, a certificate file is missing), MariaDB used to silently disable SSL, leaving you under impression that everything was fine and connections were secure. Since this release, MariaDB will fail to start if SSL is enabled, but cannot be switched on.
Assertion on info.page_size failed in xb_delta_open_matching_space ()
locks database for minutes ()
Adaptive hash index ,
MVCC and locking (, , , )
Virtual columns (, )
updated to 26.4.13
Galera server crashes after 10.3 > 10.4 upgrade ()
status variable prints 0 as port number if the port is not mentioned in system variable ()
XA COMMIT is not binlogged when the has not updated any transaction engine ()
Concurrent statements made to binlog without any mixup ()
Beginning with the next release (Q1 2023), our Yum, DNF, and Zypper repositories for Red Hat, Fedora, and SUSE will be migrated to being signed with a new . The key we are migrating to is the same one we already use for our Debian and Ubuntu Repositories.
The short Key ID is: 0xC74CD1D8
The long Key ID is: 0xF1656F24C74CD1D8
The following changes have been made to the docker.io/library/mariadb container image.
The number of gpg packages has been removed, leaving enough to apt-get update, but dirmngr that would fetch keys has been removed. (inspired by )
The environment variable LANG=C.UTF-8 has been added for those that exec into containers and copy paste UTF8 characters (fixes ).
Fixes for the following :
CVE--``#
For a complete list of changes made in , with links to detailed
information on each push, see the .
MariaDB 10.8 is a previous short-term maintenance stable series of MariaDB, maintained until May 2023. It is an evolution of MariaDB 10.7 with several entirely new features.
UNIQUE USING HASH accepts duplicate entries for tricky collations ()
rec_get_offsets() is not optimal ()
mariadb-backup doesn't utilise innodb-undo-log-directory (if specified as a relative path) during copy-back operation ()
mariadb-backup issues error messages during InnoDB tablespaces export on partial backup preparing ()
mariadb-backup does not copy Aria logs if aria_log_dir_path is used ()
Fixed a deadlock on parallel slave involving full image Write event on the sequence engine ()
Fixed an attempted out-of-order binlogging error on slave involving ALTER on the sequence engine ()
Corrected non-versioned master to versioned slave replication on no-unique attribute table ()
optimization is improved to re-fill the materialized table only if necessary. The fewer number of table refills is taken into account when choosing query plan, too ().
New optimizer_switch option, , is added. It is off by default. When set to ON, the optimizer will produce tighter bounds for hash join output cardinality. ()
Queries using SELECT DISTINCT some_expression(aggregate_function()) could produce wrong query result. ()
Add replication setup to containers contributed by Md Sahil ()
Fixes for the following :
For a complete list of changes made in , with links to detailed
information on each push, see the .
For a full list of contributors to , see the .
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 10.8.5 Release Notes
The most recent release of is: Stable (GA)
| | |
Release date: 19 Sep 2022
is a previous short-term maintenance stable series of MariaDB, maintained until May 2023. It is an evolution of with several entirely new features.
is a release.
For an overview ofsee thepage.
MariaDB 10.8.2 Release notes
The most recent release of is: Stable (GA)
| | |
Release date: 12 Feb 2022
Do not use non-stable (non-GA) releases in production!
is the current development series of MariaDB. It is an evolution
of with several entirely new features.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
A GROUP BY query with MIN(primary_key) in select list and primary_key<>const in the WHERE could produce wrong result when executed with "Using index for group-by" strategy (MDEV-30605)
EXPLAIN could erroneously report that is used for partitioned tables. Partitioned tables do not support it. (MDEV-30596)
A bug in selectivity computations for SINGLE/DOUBLE_PREC_HB histograms could cause wrong estimates to be produced. This could cause the optimizer to pick sub-optimal query plans (MDEV-31067).
Notable Items
InnoDB
Backup
Replication
Optimizer
Docker Official Image
Security
Changelog
Contributors
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
see the
page.
Thanks, and enjoy MariaDB!
This release fixes a blocking problem with the MariaDB 10.8.1 release when manually running . (MDEV-27789)
See MariaDB 10.8.1 for other changes since the previous release.
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.8 is a previous short-term maintenance stable series of MariaDB, maintained until May 2023. It is an evolution of MariaDB 10.7 with several entirely new features.
As mentioned in the , our Yum/DNF/Zypper repositories for Red Hat Enterprise Linux, CentOS, Fedora, openSUSE, and SUSE are changing with this release to being signed with a new GPG key with SHA2 digest algorithms instead of SHA1. See and the page for more details.
corruption with ()
recovery and backup fixes (, , )
Upgrade after a crash is not supported ()
updated to 26.4.14
Fixes for cluster wide write conflict resolving ()
Parallel slave applying in binlog order is corrected for admin class of commands including ANALYZE ()
is now shown now more precisely at the slave applier start, including in the delayed mode ()
mysqlbinlog --verbose is made to show the type of compressed columns ()
added as an alias for ()
Infinite sequence of recursive calls when processing embedded CTE ()
Crash with a query containing nested WINDOW clauses ()
Major performance regression with 10.6.11 ()
Fixes for the following :
CVE--``#
For a complete list of changes made in , with links to detailed
information on each push, see the .
For a full list of contributors to , see the .
This page is licensed: CC BY-SA / Gnu FDL
Remove load throttling ()
InnoDB shutdown hangs when the change buffer is corrupted ()
innodb_fast_shutdown=0 fails to report change buffer merge progress ()
Crash after recovery, with InnoDB: Tried to read ()
Trying to write ... bytes at ... outside the bounds ()
TRUNCATE breaks FOREIGN KEY locking (, )
INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION.NAME is NULL for undo tablespaces ()
Fixed hangs and error handling in B-tree operations (, )
InnoDB bulk insert fixes (, )
Deadlock is resolved on replica involving BACKUP STAGE BLOCK_COMMIT and a committing user XA ()
As per the , this will be the last release of for Fedora 35.
In this release repositories for Fedora 37 and Ubuntu 22.10 Kinetic have been added.
InnoDB
Galera
Replication
JSON
General
Security
Changelog
Contributors
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
MariaDB 10.8 is the current development series of MariaDB. It is an evolution
of MariaDB 10.7 with several entirely new features.
MariaDB 10.8.0 is not a single release, but is instead a number of feature preview releases based on feature branches. Each should be considered as having a maturity of an Alpha release.
Read more about feature preview releases here.
Thanks, and enjoy MariaDB!
Remember, these features are in separate preview packages. The subsection header text corresponds to the preview package name.
Stored procedures already have support for the parameter qualifiers. Added as well for and (IN only) (). This was a by .
Normally, gets fully executed on the primary first and only then it is and starts executing on replicas. With this feature ALTER TABLE gets replicated and starts executing on replicas when it starts executing on the primary, not when it finishes. This way the replication lag caused by a heavy ALTER TABLE can be completely eliminated ().
Individual columns in the can now be explicitly sorted in the ascending or descending order. This can be useful for optimizing certain cases (, , , ).
autosize ().
Improve the for concurrency ().
For that are partitioned BY SYSTEM_TIME with the LIMIT or INTERVAL clause, that is, when the server automatically switches to the new history partition when the previous one becomes full, one can now use an AUTO keyword to tell the server to create more history partitions automatically as needed ().
Note that this feature was not included in .
Histograms in the statistics tables are more precise and stored as JSON, not binary (, , ).
This was mostly internal refactoring work. As a result one can now declare connections using the REMOTE_SERVER, REMOTE_DATABASE, and REMOTE_TABLE attributes and not abuse the COMMENT field for that. This works both for the whole table and per partition (, ).
Add an optional argument to the function, as well as the function, which uses the Castagnoli polynomial. (). Note: The order of the 2-ary arguments was swapped after the preview release: crc32('MariaDB')=crc32(crc32('Maria'),'DB')
Deprecate the variable ().
now handles --default-*
(or mysqlbinlog as it was called back when the task was created) now supports both filtering events by GTID ranges through --start-position and --stop-position, and validating a binary log's ordering of GTIDs through --gtid-strict-mode ().
On newer versions of Windows (Windows 10 1903 or later), the mariadb client defaults to the utf8mb4 character set. Several problems with Unicode input and output in client were fixed. Command line utilities now accept all Unicode characters in user names, database names, file names etc (in the past, characters were restricted to the current ANSI codepage).
Do not use alpha releases on production systems!
For a complete list of changes made in , with links to detailed
information on each push, see the .
Do not use alpha releases in production!
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More
information can be found on the
page.
MariaDB 10.8 is a previous short-term maintenance series. The first stable release was in May 2022, and it was maintained for one year.
Upgrading
See and .
New Features & Improvements
Stored Procedures INOUT Parameters
Stored procedures already have support for the parameter qualifiers. Added as well for and (IN only) (). This was a by .
Normally, gets fully executed on the primary first and only then it is and starts executing on replicas. With this feature ALTER TABLE gets replicated and starts executing on replicas when it starts executing on the primary, not when it finishes. This way the replication lag caused by a heavy ALTER TABLE can be completely eliminated ().
Individual columns in the can now be explicitly sorted in the ascending or descending order. This can be useful for optimizing certain cases (, , , ).
autosize ().
Improve the for concurrency ().
Remove FIL_PAGE_FILE_FLUSH_LSN ().
Histograms in the statistics tables are more precise and stored as JSON, not binary (, , ).
This was mostly internal refactoring work. As a result one can now declare connections using the REMOTE_SERVER, REMOTE_DATABASE, and REMOTE_TABLE attributes and not abuse the COMMENT field for that. This works both for the whole table and per partition (, ).
Add an optional argument to the function, as well as the function, which uses the Castagnoli polynomial. (). Note: The order of the 2-ary arguments was swapped after the preview release: crc32('MariaDB')=crc32(crc32('Maria'),'DB')
Deprecate the variable ().
now handles --default-*
(or mysqlbinlog as it was called back when the task was created) now supports both filtering events by GTID ranges through --start-position and --stop-position, and validating a binary log's ordering of GTIDs through --gtid-strict-mode ().
On newer versions of Windows (Windows 10 1903 or later), the mariadb client defaults to the utf8mb4 character set. Several problems with Unicode input and output in client were fixed. Command line utilities now accept all Unicode characters in user names, database names, file names etc (in the past, characters were restricted to the current ANSI codepage).
For a list of all new variables, see .
For a complete list of security vulnerabilities (CVEs) fixed across all
versions of MariaDB, see the
page.
:
:
:
Date
Release
Status
Release Notes
Changelog
This page is licensed: CC BY-SA / Gnu FDL
MariaDB 10.8.1 Release Notes
| | |
Release date: 9 Feb 2022
This release is no longer available for download after a problem was noticed when manually running mariadb-upgrade. See for more details.Please use a later release.
Do not use non-stable (non-GA) releases in production!
is the current development series of MariaDB. It is an evolution
of with several entirely new features.
options in exactly the same way as other MariaDB tools (
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
Be notified of new MariaDB Server releases automatically by subscribing to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
script updated to version 2022-02-08, with the following fixes and enhancements:
Default location of the script has been moved to: mariadb_repo_setup (old location is deprecated, but still works)
The GPG keyring file, used with Debian and Ubuntu repositories, has moved to: and the checksum for the file can be found at:
Support for RHEL and SLES aarch64 repositories added
New function added to verify that the MariaDB Server version, if specified on the command line, follows the correct naming and that a corresponding repository actually exists.
Fixed repository pinning for Ubuntu and Debian repositories
MariaDB Server 10.7 is now the default server version
Faster initialization by disabling binary logging during initialization (MDEV-27074)
mysql_upgrade can be run if needed using the environment variable MARIADB_AUTO_UPGRADE=1 (MDEV-25670)
A healthcheck script /usr/local/bin/healthcheck.sh is installed in the container with various checking options (MDEV-25434)
mysql@localhost user is created with the environment variable MARIADB_MYSQL_LOCALHOST_USER=1 and additional grants (beyond USAGE) with MARIADB_MYSQL_LOCALHOST_GRANTS={global grant list} ()
skip innodb buffer pool loads/dumps on temporary startup/shutdown for faster startup/initialization, and accurate "healthcheck.sh --innodb_buffer_pool_loaded"
change group ownership on datadir/socket dir ()
log note about note on Securing system users, mysql_secure_installation not required ()
speed up Docker Library initialization of timezones (, )
MariaDB names of executable programs and scripts used instead of historical mysql ones
For a complete list of changes made in MariaDB 10.8.1, with links to detailed
information on each push, see the changelog.
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
FULLTEXT search with apostrophe, and mandatory words ()
ALTER TABLE IMPORT TABLESPACE corrupts an encrypted table ()
is stored in binlog, so that CREATE TABLE on slave would always have the same effect as on master. ()
ER_SLAVE_INCIDENT error is specified now on slave to be seen with SHOW-SLAVE-STATUS ()
INCIDENT_EVENT is no longer binlogged when a being logged transaction can be safely rolledback ()
updated to 26.4.12
Possible to write/update with read_only=ON and not a SUPER privilege ()
Node crashes with Transport endpoint is not connected mysqld got signal 6 ()
Server crash in JOIN_CACHE::free or in copy_fields ()
Queries that use DISTINCT and an always-constant function like COLLATION(aggegate_func(...)) could cause a server crash. Note that COLLATION() is a special function - its value is constant even if its argument is not costant.
Crash when using ANY predicand with redundant subquery in GROUP BY clause ()
MariaDB Server SEGV on INSERT .. SELECT ()
Certain queries in form "INSERT ... SELECT with_aggregate_or_window_func" could cause a crash.
Wrong result with table elimination combined with not_null_range_scan ()
If one runs with optimizer_switch='not_null_range_scan=on' (which is not enabled by default), a query that does a join and has const tables could produce a wrong result.
Assertion `tmp >= 0' failed in best_access_path ()
and have been deprecated (, )
Spider's high-availability feature has been deprecated ()
: extract document fragment into JSON column ()
now supports with ()
now also has a session scope, not only global ()
New option, -enable-cleartext-plugin. Option does not do anything, and is for MySQL-compatibility purposes only.
Crash in ()
Fixes for the following :
For a complete list of changes made in , with links to detailed
information on each push, see the .
Reduced scalability bottlenecks. Minimum size of increased from 1MB to 4MB to cater for rare error message. ()
removed ()
InnoDB gap locking fixes (, )
Semisync-slave server recovery is refined to correctly rollback prepared transaction ()
Circular semisync setup endless event circulation is handled ()
Semisync-slave server recovery is extended to work on new server_id server ()
Incorrect binlogs after Galera SST using rsync and ()
does not detect multi-source replication slave ()
Useless warning "InnoDB: Allocated tablespace ID for , old maximum was 0" during backup stage ()
Query performance degradation in newer MariaDB versions when using many tables ()
A SEGV in Item_field::used_tables/update_depend_map_for_order... ()
ANALYZE FORMAT=JSON fields are incorrect for UNION ALL queries ()
The following variables have been deprecated:
and ()
and ()
()
Server are ()
For RHEL/CentOS 7, non x86_64 architectures are no longer supported upstream and so our support will also be dropped with this release
Packages for Ubuntu 22.04 LTS "Jammy" and Fedora 36 are now available in this release
Fixes for the following :
CVE-`-```
For a complete list of changes made in , with links to detailed
information on each push, see the .
For a full list of contributors to , see the .
This page is licensed: CC BY-SA / Gnu FDL
ALTER TABLE wrong-result fix ()
Crash recovery fixes (, )
DDL crash recovery fixes (, , , , , )
Avoid crashes on corrupted data (, , , , , )
Bulk load bug fixes (, )
Performance fixes (, )
sequences related row-format events are made to correspond to binlog_row_image ()
Possible reason of FLUSH BINARY LOGS hang is eliminated ()
Fix out-of-order gtid error in the circular semisync setup ()
Galera4 not able to report proper wsrep_incoming_addresses ()
Galera should replicate nextval()-related changes in sequences with INCREMENT <> 0, at least NOCACHE ones with engine=InnoDB ()
Add support for OpenSSL 3.0 in Galera ()
A query with a subuquery in this form could cause a crash:
Subquery semi-join optimization could miss LooseScan or FirstMatch strategies for certain queries.
Optimizer uses all partitions after upgrade to 10.3 ()
For multi-table UPDATE or DELETE queries, the optimizer failed to apply Partition Pruning optimization for the table that is updated or deleted from.
Range optimizer regression for key IN (const, ....) ()
The issue can be observed on and later versions which have the fix for . That fix introduceds optimizer_max_sel_arg_weight.
If one sets optimizer_max_sel_arg_weight to a very high value or zero (which means "unlimited") and runs queries that produce heavy-weight graphs, they can observe a performance slowdown, e.g.:
If one uses histogram_type=JSON_HB, has collected a histogram of that type and runs a query that selects a very narrow range near histogram end, they can hit an assertion in the optimizer due to rounding errors in the histogram causing negative selectivity.
ALTER TABLE ALGORITHM=NOCOPY does not work after upgrade ()
Server crash upon CREATE VIEW with unknown column in ON condition ()
password_reuse_check plugin mixes username and password ()
As per the , this will be the last release of for Debian 10 "Buster" for ppc64el
Repositories for Ubuntu 22.04 and RHEL/Rocky 9 have been added in this release
... ANY (SELECT ... GROUP BY (SELECT redundant_subselect_here)) ...
table.keyXpartY [NOT] IN ( ... )
Notable Items
InnoDB
Replication
Galera
Optimizer
Spider
JSON
CONNECT
General
Security
Changelog
Contributors
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.
Server crashes in Expression_cache_tracker::fetch_current_stats ()
MariaDB server crash at Item_subselect::init_expr_cache_tracker (, )
Crash with union of my_decimal type in ORDER BY clause ()
SIGSEGV in st_join_table::cleanup ()
Assertion `!eliminated' failed in Item_subselect::exec ()
()
, , and ()
, , , , ()
()
()
As per the , this will be the last release of for Debian 9 "Stretch", Ubuntu 21.10 "Impish", and Fedora 34
Notable Items
InnoDB
Replication
Backup
Optimizer
Spider
General
Security
Changelog
Contributors
Be notified of new MariaDB Server releases automatically by to the MariaDB Foundation community announce 'at' lists.mariadb.org announcement list (this is a low traffic, announce-only list). MariaDB plc customers will be notified for all new releases, security issues and critical bug fixes for all MariaDB plc products thanks to the Notification Services.
MariaDB may already be included in your favorite OS distribution. More information can be found on the page.