All pages
Powered by GitBook
1 of 11

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Release Notes - MariaDB 10.8 Series

MariaDB 10.8 was a short-term maintenance stable series of MariaDB maintained until May 2023

MariaDB 10.8.7 Release Notes

Download | Release Notes | Changelog | Overview of 10.8

Release date: 6 Feb 2023

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.

MariaDB 10.8.7 is a Stable (GA) release.

For an overview of MariaDB 10.8 see theWhat is MariaDB 10.8? page.

Thanks, and enjoy MariaDB!

Notable Items

  • 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.

InnoDB

  • corruption with ()

  • recovery and backup fixes (, , )

  • Upgrade after a crash is not supported ()

  • Remove load throttling ()

Galera

  • updated to 26.4.14

  • Fixes for cluster wide write conflict resolving ()

Replication

  • 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 ()

JSON

  • added as an alias for ()

General

  • Infinite sequence of recursive calls when processing embedded CTE ()

  • Crash with a query containing nested WINDOW clauses ()

  • Major performance regression with 10.6.11 ()

  • As per the , this will be the last release of for Fedora 35.

Security

  • Fixes for the following :

    • CVE--``#

Changelog

For a complete list of changes made in , with links to detailed information on each push, see the .

Contributors

For a full list of contributors to , see the .

MariaDB 10.8.2 Release notes

The most recent release of MariaDB 10.8 is:MariaDB 10.8.8 Stable (GA) Download Now

Download 10.8.2 | Release Notes | Changelog | Overview of 10.8

Release date: 12 Feb 2022

Do not use non-stable (non-GA) releases in production!

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.2 is a Release Candidate (RC) release.

For an overview of MariaDB 10.8 see theWhat is MariaDB 10.8? page.

Thanks, and enjoy MariaDB!

Notable Items

  • This release fixes a blocking problem with the release when manually running . ()

  • See for other changes since the previous release.

InnoDB

  • Set by default ()

General

  • Fix mismatched braces for non-Linux targets (fails to build) ()

Security

  • Fixes for the following :

    • CVE-`-```

Changelog

For a complete list of changes made in , with links to detailed information on each push, see the .

Contributors

For a full list of contributors to , see the .

Do not use non-stable (non-GA) releases in production!

MariaDB 10.8.5 Release Notes

The most recent release of MariaDB 10.8 is:MariaDB 10.8.8 Stable (GA) Download Now

Download 10.8.5 | Release Notes | Changelog | Overview of 10.8

Release date: 19 Sep 2022

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.

MariaDB 10.8.5 is a Stable (GA) release.

For an overview of MariaDB 10.8 see theWhat is MariaDB 10.8? page.

Thanks, and enjoy MariaDB!

Notable Items

Issues Fixed

  • Assertion mysql_mutex_assert_owner(&log_sys.flush_order_mutex) failed in mtr_t::commit() ()

  • Frequent "Data structure corruption" in InnoDB after OOM ()

  • Recovery or backup of instant ALTER TABLE is incorrect ()

  • InnoDB Temporary Tablespace (ibtmp1) is continuously growing ()

Security

  • Fixes for the following :

    • CVE--``#

Changelog

For a complete list of changes made in , with links to detailed information on each push, see the .

Contributors

For a full list of contributors to , see the .

InnoDB shutdown hangs when the change buffer is corrupted (MDEV-30009)

  • innodb_fast_shutdown=0 fails to report change buffer merge progress (MDEV-29984)

  • mariadb-backup --backup --incremental --throttle=... hangs (MDEV-29896)

  • Crash after recovery, with InnoDB: Tried to read (MDEV-30132)

  • Trying to write ... bytes at ... outside the bounds (MDEV-30069)

  • TRUNCATE breaks FOREIGN KEY locking (MDEV-29504, MDEV-29849)

  • INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION.NAME is NULL for undo tablespaces (MDEV-30119)

  • Fixed hangs and error handling in B-tree operations (MDEV-29603, MDEV-30400)

  • InnoDB bulk insert fixes (MDEV-30047, MDEV-30321)

  • Deadlock is resolved on replica involving BACKUP STAGE BLOCK_COMMIT and a committing user XA (MDEV-30423)

    In this release repositories for Fedora 37 and Ubuntu 22.10 Kinetic have been added.

    10.8.6 release notes
    this blog post
    MDEV-25004
    MDEV-29999
    MDEV-30179
    MDEV-30438
    MDEV-24412
    MDEV-25417
    Galera
    MDEV-29684
    MDEV-30323
    MDEV-29639
    MDEV-25277
    MDEV-19160
    MDEV-30248
    MDEV-30052
    MDEV-29988
    MariaDB Deprecation Policy
    MariaDB 10.8
    MariaDB 10.8.7
    changelog
    MariaDB 10.8.7
    MariaDB Foundation release announcement

    Full text index corruption if shutdown before changes are fully flushed (MDEV-29342)

  • does not parse NULL properties properly (MDEV-27151)

  • InnoDB hangs on multiple concurrent requests of a cold ROW_FORMAT=COMPRESSED page (MDEV-27983)

  • MDEV-29383
    MDEV-29374
    MDEV-29438
    MDEV-28240
    MariaDB 10.8.5
    changelog
    MariaDB 10.8.5
    MariaDB Foundation release announcement
    MariaDB 10.8.1
    MDEV-27789
    MariaDB 10.8.1
    MDEV-27734
    MDEV-27790
    MariaDB 10.8.2
    changelog
    MariaDB 10.8.2
    MariaDB Foundation release announcement

    MariaDB 10.8.8 Release Notes

    Download | Release Notes | Changelog | Overview of 10.8

    Release date: 10 May 2023

    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.

    MariaDB 10.8.8 is a Stable (GA) release.

    MariaDB 10.8.8 is the last release of the MariaDB 10.8 release series.

    For an overview of MariaDB 10.8 see theWhat is MariaDB 10.8? page.

    Thanks, and enjoy MariaDB!

    Notable Items

    • As per the , this will be the final release of

    InnoDB

    • Crash on in a table ()

    • UNIQUE USING HASH accepts duplicate entries for tricky collations ()

    • rec_get_offsets() is not optimal ()

    • Performance regression in fil_space_t::try_to_close() introduced in ()

    Backup

    • 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 ()

    • Race condition between buffer pool flush and log file deletion in mariadb-backup --prepare ()

    Replication

    • 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 ()

    • Mended encrypted binlog master to error out to gtid-mode slave when master could not decrypt a binlog file ()

    Optimizer

    • 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. ()

    Docker Official Image

    • Add replication setup to containers contributed by Md Sahil ()

    Security

    • Fixes for the following :

    Changelog

    For a complete list of changes made in , with links to detailed information on each push, see the .

    Contributors

    For a full list of contributors to , see the .

    InnoDB recovery hangs when buffer pool ran out of memory (MDEV-30551)

  • InnoDB undo log truncation fails to wait for purge of history (MDEV-30671

  • MariaDB crash due to DB_FAIL reported for a corrupted page (MDEV-30397)

  • Deadlock between INSERT and InnoDB non-persistent statistics update (MDEV-30638)

  • InnoDB hang on B-tree split or merge (MDEV-29835)

  • Performance regression in locking reads from secondary indexes (MDEV-30357)

  • Improve adaptive flushing (MDEV-26055)

  • Make page flushing even faster (MDEV-26827)

  • Purge misses a chance to free not-yet-reused undo pages (MDEV-29593)

  • InnoDB temporary tablespace: reclaiming of free space does not work (MDEV-26782)

  • Deadlock between CHECK TABLE and bulk insert (MDEV-30798)

  • Fix miscount of doublewrites by (MDEV-31124)

  • Refined optimistic parallel slave to error-exit without any hang (MDEV-30780)

  • Ensured SHOW-SLAVE-STATUS is processed on the parallel slave having a necessary mutex always intialized (MDEV-30620)

  • Fixed the slave applier to report a correct error when gtid_slave_pos insert fails for some (engine) reasons (MDEV-31038)

  • Made parallel slave reports in performance schema consistent with that of show-slave-status (MDEV-26071)

  • now prints more information about Block Nested Loop joins: block-nl-join element now has r_loops, r_effective_rows and r_other_time_ms fields (MDEV-30806, MDEV-30972).

  • 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).

  • MariaDB Maintenance Policy
    MariaDB 10.8
    MDEV-30882
    MDEV-30034
    MDEV-30567
    MDEV-23855
    MDEV-30775
    MDEV-28187
    MDEV-29050
    MDEV-30968
    MDEV-30860
    MDEV-29621
    MDEV-31077
    MDEV-30430
    MDEV-28798
    MDEV-26301
    MDEV-30812
    MDEV-20057
    MDEV-29762
    CVE-2022-47015
    MariaDB 10.8.8
    changelog
    MariaDB 10.8.8
    MariaDB Foundation release announcement

    MariaDB 10.8.1 Release Notes

    Download | Release Notes | Changelog | Overview of 10.8

    Alternate download from mariadb.org

    Release date: 9 Feb 2022

    This release is no longer available for download after a problem was noticed when manually running mariadb-upgrade. See MDEV-27789 for more details.Please use a later release.

    Do not use non-stable (non-GA) releases in production!

    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.1 is a Release Candidate (RC) release.

    For an overview of MariaDB 10.8 see theWhat is MariaDB 10.8? page.

    Thanks, and enjoy MariaDB!

    Notable Items

    InnoDB

    • does not disallow .isl file creation ()

    • Indexed columns are broken with NO_PAD ()

    • insert-intention lock conflicts with waiting ORDINARY lock ()

    Optimizer

    • Support descending indexes in the range optimizer ()

    Galera

    • updated to 26.4.11

    • Galera SST scripts should use ssl_capath (not ssl_ca) for CA directory ()

    • Alter Sequence do not replicate to another nodes with in Galera Cluster ()

    • Galera crash - Assertion. Possible parallel writeset problem ()

    Replication

    • Seconds behind master corrected from artificial spikes at relay-log rotation ()

    • Statement rollback in binlog when transaction creates or drop temporary table is set right ()

    • CREATE-or-REPLACE SEQUENCE is made to binlog with the DDL flag to stabilize its parallel execution on slave ()

    • ALTER is optionally made to binlog in two parts to decrease its replication latency ()

    Packaging & Misc

    • prohibition running two upgrades in parallel (, , )

    • script updated to version 2022-02-08, with the following fixes and enhancements:

      • Default location of the script has been moved to: (old location is deprecated, but still works)

    Docker Library

    • Faster initialization by disabling binary logging during initialization ()

    • mysql_upgrade can be run if needed using the environment variable MARIADB_AUTO_UPGRADE=1 ()

    • A healthcheck script /usr/local/bin/healthcheck.sh is installed in the container with various checking options ()

    • 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} (

    Changelog

    For a complete list of changes made in , with links to detailed information on each push, see the .

    Contributors

    For a full list of contributors to , see the .

    Do not use non-stable (non-GA) releases in production!

    MariaDB 10.8.0 Release Notes

    The most recent release of is: Stable (GA)

    | | |

    Release date: 21 Dec 2021

    Do not use alpha releases in production!

    is the current development series of MariaDB. It is an evolution of with several entirely new features.

    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 release. Read more about feature preview releases .

    Thanks, and enjoy MariaDB!

    Remember, these features are in separate preview packages

    Crash recovery improvements (
    ,
    ,
    ,
    )
  • MariaDB Backup skips valid .ibd file (MDEV-26326)

  • Allow seamless upgrade despite (MDEV-27736)

  • Change the format to reduce write amplification (MDEV-14425)

  • Remove FIL_PAGE_FILE_FLUSH_LSN from the (MDEV-27199).

  • Support descending indexes internally in InnoDB (MDEV-26938)

  • CREATE TABLE with FOREIGN KEY constraint fails to apply in parallel (MDEV-27276)

  • Galera cluster node consider old server_id value even after modification of server_id [wsrep_gtid_mode=ON] (MDEV-26223)

  • mysqlbinlog --start-position and --stop-position accept gtid values to allow specifying the replication event range in terms of gtid (MDEV-4989)

    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

  • )
  • 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 (issue #401)

  • log note about note on Securing system users, mysql_secure_installation not required (reddit suggestion)

  • speed up Docker Library initialization of timezones (MDEV-27608, MDEV-23326)

  • MariaDB names of executable programs and scripts used instead of historical mysql ones

  • MDEV-26870
    MDEV-25440
    MDEV-27025
    MDEV-26996
    Galera
    MDEV-27181
    MDEV-19353
    MDEV-26803
    MDEV-16091
    MDEV-26833
    MDEV-27365
    MDEV-11675
    MDEV-27068
    MDEV-27107
    MDEV-27279
    mariadb_repo_setup
    MDEV-27074
    MDEV-25670
    MDEV-25434
    MariaDB 10.8.1
    changelog
    MariaDB 10.8.1
    MariaDB Foundation release announcement
    MDEV-26784
    MDEV-27022
    MDEV-27183
    MDEV-27610
    mariadb-keyring-2019.gpg
    mariadb-keyring-2019.gpg.sha256
    MDEV-27732

    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.

    . The subsection header text corresponds to the preview package name.

    Stored Procedures INOUT Parameters

    • Stored procedures already have support for the parameter qualifiers. Added as well for and (IN only) (MDEV-10654). This was a contribution by ManoharKB.

    Lag free ALTER TABLE in replication

    • 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 (MDEV-11675).

    Descending indexes

    • Individual columns in the can now be explicitly sorted in the ascending or descending order. This can be useful for optimizing certain cases (MDEV-13756, MDEV-26938, MDEV-26939, MDEV-26996).

    InnoDB redo log improvements

    • autosize (MDEV-25342).

    • Improve the for concurrency (MDEV-14425).

    Auto create partition

    • 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 (MDEV-17554).

    • Note that this feature was not included in MariaDB 10.8.1.

    JSON Histograms

    • Histograms in the statistics tables are more precise and stored as JSON, not binary (MDEV-21130, MDEV-26519, blog post).

    Spider Storage Engine Improvements

    • 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 (MDEV-5271, MDEV-27106).

    Misc. features

    • Add an optional argument to the function, as well as the function, which uses the Castagnoli polynomial. (MDEV-27208). Note: The order of the 2-ary arguments was swapped after the preview release: crc32('MariaDB')=crc32(crc32('Maria'),'DB')

    • Deprecate the variable (MDEV-23570).

    • now handles --default-* options in exactly the same way as other MariaDB tools (MDEV-26238).

    • UCA are now notably faster (, ).

    mysqlbinlog GTID support

    • (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 (MDEV-4989).

    Windows - Improved i18n support

    • 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 MariaDB 10.8.0, with links to detailed information on each push, see the changelog.

    Do not use alpha releases in production!

    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.

    MariaDB 10.8
    MariaDB 10.8.8
    Download Now
    Download 10.8.0
    Release Notes
    Changelog
    Overview of 10.8
    MariaDB 10.8
    MariaDB 10.7
    MariaDB 10.8.0
    Alpha
    here

    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 Changes & Improvements

    MariaDB 10.8 is no longer maintained. Please use a more recent release.

    The most recent release of MariaDB 10.8 is:MariaDB 10.8.8 Stable (GA) Download Now

    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 .

    Lag free ALTER TABLE in replication

    • 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 ().

    Descending indexes

    • Individual columns in the can now be explicitly sorted in the ascending or descending order. This can be useful for optimizing certain cases (, , , ).

    InnoDB redo log improvements

    • autosize ().

    • Improve the for concurrency ().

    • Remove FIL_PAGE_FILE_FLUSH_LSN ().

    JSON Histograms

    • Histograms in the statistics tables are more precise and stored as JSON, not binary (, , ).

    Spider Storage Engine Improvements

    • 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 (, ).

    Misc. features

    • 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-* options in exactly the same way as other MariaDB tools ().

    mysqlbinlog GTID support

    • (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 ().

    Windows - Improved i18n support

    • 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).

    Variables

    • For a list of all new variables, see .

    Security Vulnerabilities Fixed in

    For a complete list of security vulnerabilities (CVEs) fixed across all versions of MariaDB, see the page.

    • :

    • :

    • :

    • :

    List of All Releases

    Date
    Release
    Status
    Release Notes
    Changelog

    MariaDB 10.8.6 Release Notes

    The most recent release of MariaDB 10.8 is:MariaDB 10.8.8 Stable (GA) Download Now

    Download 10.8.6 | Release Notes | Changelog | Overview of 10.8

    Release date: 7 Nov 2022

    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.

    MariaDB 10.8.6 is a Stable (GA) release.

    For an overview of MariaDB 10.8 see theWhat is MariaDB 10.8? page.

    Thanks, and enjoy MariaDB!

    Notable Items

    SSL

    • 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.

    Backup

    • Assertion on info.page_size failed in xb_delta_open_matching_space ()

    • locks database for minutes ()

    InnoDB

    • Adaptive hash index ,

    • MVCC and locking (, , , )

    • Virtual columns (, )

    • InnoDB crash recovery fixes ()

    Galera

    • 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 ()

    Replication

    • XA COMMIT is not binlogged when the has not updated any transaction engine ()

    • Concurrent statements made to binlog without any mixup ()

    Repositories

    • 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

    Docker Official Image

    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 ).

    • Adds OCI labels to image (fixes and )

    Security

    • Fixes for the following :

      • CVE--``#

    Changelog

    For a complete list of changes made in , with links to detailed information on each push, see the .

    Contributors

    For a full list of contributors to , see the .

    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.

    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.

    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.

    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.4 Release Notes

    The most recent release of is: Stable (GA)

    | | |

    Release date: 15 Aug 2022

    is the current short-term maintenance stable series of MariaDB. It is an evolution of with several entirely new features.

    is a release.

    For an overview of see the page.

    Thanks, and enjoy MariaDB!

    UCA are now notably faster (MDEV-27266, MDEV-27265).

    CVE-2022-32089: MariaDB 10.8.4

  • CVE-2022-32084: MariaDB 10.8.4

  • CVE-2022-32082: MariaDB 10.8.4

  • CVE-2022-32081: MariaDB 10.8.4

  • CVE-2022-24052: MariaDB 10.8.1

  • CVE-2022-24051: MariaDB 10.8.1

  • CVE-2022-24050: MariaDB 10.8.1

  • CVE-2022-24048: MariaDB 10.8.1

  • CVE-2021-46659: MariaDB 10.8.1

  • CVE-2018-25032: MariaDB 10.8.4

  • Stable (GA)

    19 Sep 2022

    Stable (GA)

    15 Aug 2022

    Stable (GA)

    20 May 2022

    Stable (GA)

    12 Feb 2022

    RC

    09 Feb 2022

    RC

    21 Dec 2021

    Alpha

    10 May 2023

    MariaDB 10.8.8

    Stable (GA)

    Release Notes

    Changelog

    6 Feb 2023

    MariaDB 10.8.7

    Stable (GA)

    Release Notes

    Changelog

    MDEV-10654
    contribution
    ManoharKB
    MDEV-11675
    MDEV-13756
    MDEV-26938
    MDEV-26939
    MDEV-26996
    MDEV-25342
    MDEV-14425
    MDEV-27199
    MDEV-21130
    MDEV-26519
    blog post
    MDEV-5271
    MDEV-27106
    MDEV-27208
    MDEV-23570
    MDEV-26238
    MDEV-4989
    MariaDB 10.8
    CVE-2023-5157
    MariaDB 10.8.4
    CVE-2022-47015
    MariaDB 10.8.8
    CVE-2022-38791
    MariaDB 10.8.4
    CVE-2022-32091
    MariaDB 10.8.4
    MariaDB 10.8

    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.

    7 Nov 2022

    Race condition between KILL and transaction commit (MDEV-29368)

  • Implement for InnoDB (MDEV-24402)

  • fail to update after bulk insert (MDEV-28327)

  • InnoDB bulk insert bug fixes (MDEV-29570, MDEV-29761)

  • The full fingerprint of the key is: 177F 4010 FE56 CA33 3630 0305 F165 6F24 C74C D1D8

  • The key can be imported now in preparation for this change using the following command:

  • MariaDB config: skip-host-cache and skip-name-resolve moved to /etc/mysql/mariadb.conf.d/05-skipcache.cnf

    MDEV-29811
    MDEV-18589
    mariadb-backup
    MDEV-28772
    MDEV-27700
    MDEV-29384
    MDEV-29666
    MDEV-27927
    MDEV-28709
    MDEV-29635
    MDEV-29299
    MDEV-29753
    MDEV-29559
    Galera
    MDEV-29375
    MDEV-28868
    MDEV-25616
    MDEV-25606
    issue #469
    issue #468
    issue 436
    users need for version
    MariaDB 10.8.6
    changelog
    MariaDB 10.8.6
    MariaDB Foundation release announcement

    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.

    Notable Items

    InnoDB

    • InnoDB corruption due to lack of file locking (MDEV-28495)

    • FULLTEXT search with apostrophe, and mandatory words (MDEV-20797)

    • ALTER TABLE IMPORT TABLESPACE corrupts an encrypted table (MDEV-28779)

    • ALTER TABLE wrong-result fix (MDEV-26294)

    • Crash recovery fixes (, )

    • DDL crash recovery fixes (, , , , , )

    • Avoid crashes on corrupted data (, , , , , )

    • Bulk load bug fixes (, )

    • Performance fixes (, )

    Replication

    • is stored in binlog, so that CREATE TABLE on slave would always have the same effect as on master. (MDEV-29078)

    • ER_SLAVE_INCIDENT error is specified now on slave to be seen with SHOW-SLAVE-STATUS (MDEV-21087)

    • INCIDENT_EVENT is no longer binlogged when a being logged transaction can be safely rolledback (MDEV-21443)

    • sequences related row-format events are made to correspond to binlog_row_image (MDEV-28487)

    • Possible reason of FLUSH BINARY LOGS hang is eliminated ()

    • Fix out-of-order gtid error in the circular semisync setup ()

    Galera

    • Galera updated to 26.4.12

    • Possible to write/update with read_only=ON and not a SUPER privilege (MDEV-28546)

    • Node crashes with Transport endpoint is not connected mysqld got signal 6 (MDEV-25068)

    • Galera4 not able to report proper wsrep_incoming_addresses (MDEV-20627)

    • 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 ()

    Optimizer

    • Server crash in JOIN_CACHE::free or in copy_fields (MDEV-23809)

      • 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 (MDEV-29139)

      • A query with a subuquery in this form could cause a crash:

    • MariaDB Server SEGV on INSERT .. SELECT (MDEV-26427)

      • Certain queries in form "INSERT ... SELECT with_aggregate_or_window_func" could cause a crash.

    • restore_prev_nj_state() doesn't update cur_sj_inner_tables correctly (MDEV-28749)

      • 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.:

    • Wrong result with table elimination combined with not_null_range_scan (MDEV-28858)

      • 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 (MDEV-28882)

      • 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.

    Spider

    • spider_init_sql_alloc_size and spider_buffer_size have been deprecated (MDEV-27926, MDEV-28560)

    • Spider's high-availability feature has been deprecated (MDEV-28479)

    JSON

    • : extract document fragment into JSON column (MDEV-25875)

    CONNECT

    • CONNECT Engine now supports with Mysql Table type (MDEV-27766)

    General

    • now also has a session scope, not only global (MDEV-29225)

    • New option, -enable-cleartext-plugin. Option does not do anything, and is for MySQL-compatibility purposes only.

    • Crash in (MDEV-29188)

    • 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

    Security

    • Fixes for the following :

      • CVE-2023-5157

      • CVE-2022-32082

      • CVE-2022-32089

    Changelog

    For a complete list of changes made in MariaDB 10.8.4, with links to detailed information on each push, see the changelog.

    Contributors

    For a full list of contributors to MariaDB 10.8.4, see the MariaDB Foundation release announcement.

    MariaDB 10.8
    MariaDB 10.8.8
    Download Now
    Download 10.8.4
    Release Notes
    Changelog
    Overview of 10.8
    MariaDB 10.8
    MariaDB 10.7
    MariaDB 10.8.4
    Stable (GA)
    MariaDB 10.8
    What is MariaDB 10.8?

    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.

    MDEV-27266
    MDEV-27265
    subscribing
    subscribing
    subscribing
    subscribing
    subscribing
    subscribing

    MariaDB 10.8.3 Release Notes

    The most recent release of MariaDB 10.8 is:MariaDB 10.8.8 Stable (GA) Download Now

    Download 10.8.3 | Release Notes | Changelog | Overview of 10.8

    Release date: 20 May 2022

    MariaDB 10.8 is a short-term maintenance stable series of MariaDB. It is an evolution of MariaDB 10.7 with several entirely new features.

    MariaDB 10.8.3 will be a Release Candidate (RC) release.

    For an overview of MariaDB 10.8 see theWhat is MariaDB 10.8? page.

    Thanks, and enjoy MariaDB!

    Notable Items

    InnoDB

    • Reduced scalability bottlenecks. Minimum size of increased from 1MB to 4MB to cater for rare error message. ()

    • removed ()

    • InnoDB gap locking fixes (, )

    • InnoDB performance improvements (, , ,

    Replication

    • 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 ()

    • Server initialization time gtid_slave_pos purge related reason of crashing in binlog background thread is removed ()

    Backup

    • 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 ()

    • prepare fails for incrementals if a new schema is created after full backup is taken ()

    Optimizer

    • 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 ()

    • Subquery in an UPDATE query uses full scan instead of range ()

    Spider

    The following variables have been deprecated:

    • and ()

    • and ()

    • ()

    • ()

    General

    • 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

    • As per the , this will be the last release of for Debian 9 "Stretch", Ubuntu 21.10 "Impish", and Fedora 34

    Security

    • Fixes for the following :

      • CVE-`-```

    Changelog

    For a complete list of changes made in , with links to detailed information on each push, see the .

    Contributors

    For a full list of contributors to , see the .

    sudo rpm --import https://supplychain.mariadb.com/MariaDB-Server-GPG-KEY
    ... ANY (SELECT ... GROUP BY (SELECT redundant_subselect_here)) ...
    table.keyXpartY [NOT] IN ( ... )
    ,
    ,
    ,
    )
  • Backup regression fixes (MDEV-27919)

  • InnoDB portability: FreeBSD futexes (MDEV-26476), POWER and s390x transactional memory (MDEV-27956)

  • ALTER TABLE: Fixed bogus duplicate key errors (MDEV-15250)

  • DDL and crash recovery fixes (MDEV-27274, MDEV-27234, MDEV-27817)

  • Requests to recalculate were sometimes lost (MDEV-27805)

  • Shutdown of the semisync master can't produce inconsistent state anymore (MDEV-11853)

  • Binlogs disappear after rsync IST (MDEV-28583)

  • master crash is eliminated in compressed semisync replication protocol with packet counting amendment (MDEV-25580)

  • OPTIMIZE on a sequence does not cause counterfactual ER_BINLOG_UNSAFE_STATEMENT anymore (MDEV-24617)

  • Automatically generated Gtid_log_list_event is made to recognize within replication event group as a formal member (MDEV-28550)

  • using two or more unique key values at a time with is corrected (MDEV-28310)

  • stops issuing unnecessary "Unsafe statement" with (MDEV-21810)

  • Incomplete replication event groups are detected to error out by the slave IO thread (MDEV-27697)

  • now flushes the result file to disk after each processed event so the file can be listed with the actual bytes (MDEV-14608)

  • Assertion `item1->type() == Item::FIELD_ITEM ... (MDEV-19398)

  • Server crashes in Expression_cache_tracker::fetch_current_stats (MDEV-28268)

  • MariaDB server crash at Item_subselect::init_expr_cache_tracker (MDEV-26164, MDEV-26047)

  • Crash with union of my_decimal type in ORDER BY clause (MDEV-25994)

  • SIGSEGV in st_join_table::cleanup (MDEV-24560)

  • Assertion `!eliminated' failed in Item_subselect::exec (MDEV-28437)

  • , , and (MDEV-28007)

  • , , , , (MDEV-28005)

  • (MDEV-27923)

  • (MDEV-28244)

  • MDEV-27774
    MDEV-25975
    MDEV-20605
    MDEV-28422
    MDEV-27557
    MDEV-28185
    MDEV-27767
    MDEV-28313
    MDEV-28461
    MDEV-27760
    MDEV-27342
    MDEV-26473
    MariaDB Backup
    MDEV-27524
    MariaDB Backup
    MDEV-21037
    MDEV-27343
    MariaDB Backup
    MDEV-28446
    MDEV-28073
    MDEV-26402
    MDEV-27699
    MDEV-22377
    MDEV-28010
    MDEV-28008
    MDEV-27981
    MDEV-28297
    error messages
    MDEV-28227
    MariaDB Deprecation Policy
    MariaDB 10.8
    MariaDB 10.8.3
    changelog
    MariaDB 10.8.3
    MariaDB Foundation release announcement

    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.

    MDEV-28137
    MDEV-28465
    MDEV-26789
    MDEV-28668
    MDEV-28731
    MDEV-28752
    MDEV-28802
    MDEV-28864
    MDEV-28870
    MDEV-28923
    MDEV-28977
    MDEV-13542
    MDEV-18519
    MDEV-21098
    MDEV-22388
    MDEV-28457
    MDEV-28950
    MDEV-28242
    MDEV-28679
    MDEV-28708
    MDEV-28766
    MDEV-28948
    MDEV-28609
    MDEV-27862
    MDEV-25949
    MDEV-28246
    MDEV-25020
    MariaDB 10.5.9
    MDEV-9750
    MDEV-28727
    MDEV-29088
    MDEV-28838
    MariaDB Deprecation Policy
    MariaDB 10.8
    CVE-2022-32081
    CVE-2018-25032
    CVE-2022-32091
    CVE-2022-38791
    CVE-2022-32084
    subscribing
    MariaDB 10.8.6
    Release Notes
    Changelog
    MariaDB 10.8.5
    Release Notes
    Changelog
    MariaDB 10.8.4
    Release Notes
    Changelog
    MariaDB 10.8.3
    Release Notes
    Changelog
    MariaDB 10.8.2
    Release Notes
    Changelog
    MariaDB 10.8.1
    Release Notes
    Changelog
    MariaDB 10.8.0
    Release Notes
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    Distributions which Include MariaDB
    wsrep_incoming_addresses
    wsrep_node_incoming_address
    GPG
    Full-text index
    system versioning
    innodb_undo_log_truncate=ON
    InnoDB buffer pool
    Seconds_Behind_Master
    JSON_PRETTY
    JSON_DETAILED
    security vulnerabilities
    mariadb-upgrade
    innodb_change_buffering=none
    security vulnerabilities
    security vulnerabilities
    JSON_VALUE()
    ROLLBACK
    ROW_FORMAT=COMPRESSED
    Split Materialized
    hash_join_cardinality
    security vulnerabilities
    Innodb_data_written
    ANALYZE FORMAT=JSON
    Rowid Filter optimization
    --skip-symbolic-links
    CHAR
    collations
    mariadb_repo_setup
    ROW_FORMAT=COMPRESSED
    InnoDB redo log
    InnoDB redo log
    IN, OUT and INOUT
    stored functions
    cursors
    ALTER TABLE
    replicated
    index
    ORDER BY
    innodb_buffer_pool_chunk_size
    redo log
    system versioned tables
    Spider
    CRC32()
    CRC32C()
    keep_files_on_create
    my_print_defaults
    mariadb-binlog
    collations
    Upgrading Between Major MariaDB Versions
    Upgrading from MariaDB 10.7 to MariaDB 10.8
    IN, OUT and INOUT
    stored functions
    cursors
    ALTER TABLE
    replicated
    index
    ORDER BY
    innodb_buffer_pool_chunk_size
    redo log
    Spider
    CRC32()
    CRC32C()
    keep_files_on_create
    my_print_defaults
    mariadb-binlog
    System Variables Added in MariaDB 10.8
    Security Vulnerabilities Fixed in MariaDB
    collations
    XA transaction
    CREATE TRIGGER
    GPG key
    security vulnerabilities
    CHECK TABLE…EXTENDED
    InnoDB persistent statistics
    explicit_defaults_for_timestamp
    JSON_TABLE
    INSERT IGNORE
    explicit_defaults_for_timestamp
    mariadb client
    JSON_EXTRACT
    security vulnerabilities
    innodb_log_file_size
    innodb_disallow_writes
    spider_crd_type
    spider_crd_weight
    spider_crd_mode
    spider_sts_mode
    spider_internal_limit
    spider_internal_offset
    now available in Chinese
    security vulnerabilities
    persistent statistics
    Replication unsafe
    INSERT .. ON DUPLICATE KEY UPDATE
    MIXED format binlogging
    Replication unsafe
    INSERT .. ON DUPLICATE KEY UPDATE
    MIXED binlog format
    mysqlbinlog --stop-never --raw
    spider_store_last_crd
    spider_store_last_sts
    spider_load_crd_at_startup
    spider_load_sts_at_startup
    spider_udf_ct_bulk_insert_interval
    spider_udf_ct_bulk_insert_rows
    spider_udf_ds_bulk_insert_rows
    spider_udf_ds_table_loop_mode
    spider_udf_ds_use_real_table
    spider_use_handler
    spider_xa_register_mode

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL

    This page is licensed: CC BY-SA / Gnu FDL