All pages
Powered by GitBook
1 of 11

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Release Notes - MariaDB 10.7 Series

MariaDB 10.7 was a short-term series of MariaDB maintained until February 2023

MariaDB 10.7.8 Release Notes

Download | Release Notes | Changelog | Overview of 10.7

Release date: 6 Feb 2023

MariaDB 10.7 is a previous short-term maintenance stable series of MariaDB, supported until February 2023. It is an evolution of MariaDB 10.6 with several entirely new features.

MariaDB 10.7.8 is a Stable (GA) release.

MariaDB 10.7.8 is the last release of the MariaDB 10.7 release series.

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

Thanks, and enjoy MariaDB!

Notable Items

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

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

  • Seconds_Behind_Master is showed 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 .

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.

    MariaDB Maintenance Policy
    MariaDB 10.7
    10.7.7 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.7
    MariaDB 10.7.8
    changelog
    MariaDB 10.7.8
    MariaDB Foundation release announcement

    MariaDB 10.7 Changes & Improvements

    is no longer maintained. Please use a .

    The most recent release of is: Stable (GA)

    is a previous short-term maintenance stable series. The first stable release was in February 2022, and it was maintained for one year.

    Upgrading

    See and .

    New Features & Improvements

    UUID

    • New (MDEV-4958)

    JSON

    • function to check for equality between JSON objects (MDEV-23143).

    • function, which recursively sorts keys and removes spaces (MDEV-16375)

    Natural Sort

    • function (MDEV-4742).

    Optimization

    • Improve simple multibyte collation performance on the ASCII range (MDEV-26572).

    Provider Plugins

    • Five provider plugins (bzip2, lzma, lz4, lzo, snappy) provide to the server and storage engines (MDEV-12933, blog post).

    SFORMAT

    • function for arbitrary text formatting (MDEV-25015)

    mariadb-dump

    • Add option to as of specified timestamp (MDEV-16355).

    Convert Partitions

    • ALTER TABLE ... CONVERT PARTITION .. TO TABLE (MDEV-22166), and

    • ALTER TABLE ... CONVERT TABLE ... TO PARTITION ... (MDEV-22165) as an easy way to convert tables to partitions and back in one command, instead of a sequence of CREATE/EXCHANGE/DROP

    Password Reuse

    • password_reuse_check plugin is a new password validation plugin that prevents the new password from being the same as the one being used during the configurable retention period. (MDEV-9245)

    Replication

    • Multi-source replication supports MySQL-style CHANNEL syntax (MDEV-26307)

    InnoDB Bulk Insert

    • In bulk insert, pre-sort and build indexes one page at a time (MDEV-24621)

    Diagnostics

    • supports a new condition property name ROW_NUMBER. In multi-row inserts it allows one to retrieve a number of a row that has caused the error (MDEV-10075, MDEV-26611)

    Variables

    • For a list of all new variables, see and Status Variables Added in MariaDB 10.7.

    The following deprecated variables have been removed :

    • (MDEV-24947)

    • (MDEV-24843)

    Security Vulnerabilities Fixed in MariaDB 10.7

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

    • CVE-2023-5157: MariaDB 10.7.5

    • CVE-2022-38791: MariaDB 10.7.5

    • CVE-2022-32091: MariaDB 10.7.5

    • CVE-2022-32089: MariaDB 10.7.5

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    • :

    List of All MariaDB 10.7 Releases

    Date
    Release
    Status
    Release Notes
    Changelog

    6 Feb 2023

    Stable (GA)

    7 Nov 2022

    Stable (GA)

    MariaDB 10.7
    more recent release
    MariaDB 10.7
    MariaDB 10.7.8
    Download Now
    MariaDB 10.7

    19 Sep 2022

    MariaDB 10.7.6

    Stable (GA)

    Release Notes

    Changelog

    15 Aug 2022

    MariaDB 10.7.5

    Stable (GA)

    Release Notes

    Changelog

    20 May 2022

    MariaDB 10.7.4

    Stable (GA)

    Release Notes

    Changelog

    12 Feb 2022

    MariaDB 10.7.3

    Stable (GA)

    Release Notes

    Changelog

    9 Feb 2022

    MariaDB 10.7.2

    Stable (GA)

    Release Notes

    Changelog

    8 Nov 2021

    MariaDB 10.7.1

    RC

    Release Notes

    Changelog

    17 Sep 2021

    MariaDB 10.7.0

    Alpha

    Release Notes

    CVE-2022-32088
    MariaDB 10.7.4
    CVE-2022-32087
    MariaDB 10.7.4
    CVE-2022-32086
    MariaDB 10.7.4
    CVE-2022-32085
    MariaDB 10.7.4
    CVE-2022-32084
    MariaDB 10.7.5
    CVE-2022-32083
    MariaDB 10.7.4
    CVE-2022-32082
    MariaDB 10.7.5
    CVE-2022-32081
    MariaDB 10.7.5
    CVE-2022-27458
    MariaDB 10.7.4
    CVE-2022-27457
    MariaDB 10.7.4
    CVE-2022-27456
    MariaDB 10.7.4
    CVE-2022-27455
    MariaDB 10.7.4
    CVE-2022-27452
    MariaDB 10.7.4
    CVE-2022-27451
    MariaDB 10.7.4
    CVE-2022-27449
    MariaDB 10.7.4
    CVE-2022-27448
    MariaDB 10.7.4
    CVE-2022-27447
    MariaDB 10.7.4
    CVE-2022-27446
    MariaDB 10.7.4
    CVE-2022-27445
    MariaDB 10.7.4
    CVE-2022-27444
    MariaDB 10.7.4
    CVE-2022-27387
    MariaDB 10.7.4
    CVE-2022-27386
    MariaDB 10.7.4
    CVE-2022-27384
    MariaDB 10.7.4
    CVE-2022-27383
    MariaDB 10.7.4
    CVE-2022-27382
    MariaDB 10.7.4
    CVE-2022-27381
    MariaDB 10.7.4
    CVE-2022-27380
    MariaDB 10.7.4
    CVE-2022-27379
    MariaDB 10.7.4
    CVE-2022-27378
    MariaDB 10.7.4
    CVE-2022-27377
    MariaDB 10.7.4
    CVE-2022-27376
    MariaDB 10.7.4
    CVE-2022-24052
    MariaDB 10.7.2
    CVE-2022-24051
    MariaDB 10.7.2
    CVE-2022-24050
    MariaDB 10.7.2
    CVE-2022-24048
    MariaDB 10.7.2
    CVE-2022-21595
    MariaDB 10.7.2
    CVE-2022-0778
    MariaDB 10.7.2
    CVE-2021-46669
    MariaDB 10.7.4
    CVE-2021-46668
    MariaDB 10.7.3
    CVE-2021-46665
    MariaDB 10.7.3
    CVE-2021-46664
    MariaDB 10.7.3
    CVE-2021-46663
    MariaDB 10.7.3
    CVE-2021-46661
    MariaDB 10.7.3
    CVE-2021-46659
    MariaDB 10.7.2
    CVE-2018-25032
    MariaDB 10.7.5
    MariaDB 10.7.8
    Release Notes
    Changelog
    MariaDB 10.7.7
    Release Notes
    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.

    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.

    subscribing
    subscribing

    MariaDB 10.7.6 Release Notes

    The most recent release of MariaDB 10.7 is:MariaDB 10.7.8 Stable (GA) Download Now

    Download 10.7.6 | Release Notes | Changelog | Overview of 10.7

    Release date: 19 Sep 2022

    MariaDB 10.7 is a previous short-term maintenance stable series of MariaDB, supported until February 2023. It is an evolution of MariaDB 10.6 with several entirely new features.

    MariaDB 10.7.6 is a Stable (GA) release.

    For an overview of MariaDB 10.7 see theWhat is MariaDB 10.7? 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 .

    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.7.6
    changelog
    MariaDB 10.7.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.

    MariaDB 10.7.3 Release Notes

    The most recent release of MariaDB 10.7 is:MariaDB 10.7.8 Stable (GA) Download Now

    Download 10.7.3 | Release Notes | Changelog | Overview of 10.7

    Release date: 12 Feb 2022

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

    MariaDB 10.7.3 is a Stable (GA) release.

    For an overview of MariaDB 10.7 see theWhat is MariaDB 10.7? 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 ()

    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 .

    CVE-2021-46668

  • CVE-2021-46663

  • MariaDB 10.7.2
    MDEV-27789
    MariaDB 10.7.2
    MDEV-27734
    CVE-2021-46665
    CVE-2021-46664
    CVE-2021-46661
    MariaDB 10.7.3
    changelog
    MariaDB 10.7.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.

    MariaDB 10.7.0 Release Notes

    The most recent release of is: Stable (GA)

    | | |

    Release date: 17 Sep 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. The subsection header text corresponds to the preview package name.

    Notable changes of this series of releases include:

    Provider Plugins

    • Five provider plugins (bzip2, lzma, lz4, lzo, snappy) provide to the server and storage engines (MDEV-12933, blog post).

    SFORMAT

    • function for arbitrary text formatting (MDEV-25015, blog post).

    UUID

    • New (MDEV-4958, blog post)

    Natural Sort

    • function (MDEV-4742, blog post).

    JSON Histograms

    • Histograms in the statistics tables are more precise and stored as JSON, not binary (MDEV-21130, MDEV-26519, blog post). Note that this feature was not included in MariaDB 10.7.1.

    Convert Partitions

    • ALTER TABLE ... CONVERT PARTITION .. TO TABLE (MDEV-22166, blog post), and

    • ALTER TABLE ... CONVERT TABLE ... TO PARTITION ... (MDEV-22165) as an easy way to convert tables to partitions and back in one command, instead of a sequence of CREATE/EXCHANGE/DROP

    • ALTER TABLE .. ADD PARTITION allows to omit the redundant PARTITION keyword (MDEV-26471)

    Password Reuse

    • The is a new password validation plugin that prevents the new password from being the same as the one being used during the configurable retention period. (MDEV-9245, blog post).

    InnoDB Bulk Insert

    • In bulk insert, pre-sort and build indexes one page at a time (MDEV-24621)

    Misc. Features

    • function to check for equality between JSON objects (MDEV-23143).

    • function, which recursively sorts keys and removes spaces (MDEV-16375)

    • Improve simple multibyte collation performance on the ASCII range (MDEV-26572).

    • Add option to as of specified timestamp (MDEV-16355).

    • Multi-source replication supports MySQL-style CHANNEL syntax ()

    • supports a new condition property name ERROR_INDEX. In multi-row inserts it allows to retrieve a number of a row that has caused the error ()

    • and deprecated system variables were removed (, )

    Do not use alpha releases on production systems! For a complete list of changes made in MariaDB 10.7.0, with links to detailed information on each push, see the changelog.

    Do not use alpha releases in production!

    MariaDB 10.7
    MariaDB 10.7.8
    Download Now
    Download 10.7.0
    Release Notes
    Changelog
    Overview of 10.7
    MariaDB 10.7
    MariaDB 10.6
    MariaDB 10.7.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.7.2 Release Notes

    The most recent release of is: Stable (GA)

    | | |

    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.

    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!

    MariaDB 10.7.7 Release Notes

    The most recent release of is: Stable (GA)

    | | |

    Release date: 7 Nov 2022

    is a previous short-term maintenance stable series of MariaDB, maintained until February 2023. It is an evolution of with several entirely new features.

    is a release.

    For an overview of see the page.

    Thanks, and enjoy MariaDB!

    Notable Items

    InnoDB

    • does not disallow .isl file creation (MDEV-26870)

    • Indexed columns are broken with NO_PAD (MDEV-25440)

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

    • Crash recovery improvements (, , , )

    • skips valid .ibd file ()

    • Allow seamless upgrade despite ()

    Galera

    • Galera updated to 26.4.11

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

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

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

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

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

    Replication

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

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

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

    Packaging & Misc

    • prohibition running two upgrades in parallel (MDEV-27068, MDEV-27107, MDEV-27279)

    • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.4 for Ubuntu 21.04 Hirsute, CentOS 8, and Fedora 33

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

      • 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

    Docker Library

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

    • 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

    Security

    • Fixes for the following :

      • CVE-2022-24052

      • CVE-2022-24051

      • CVE-2022-24050

    Changelog

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

    Contributors

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

    MariaDB 10.7
    MariaDB 10.7.8
    Download Now
    Download 10.7.2
    Release Notes
    Changelog
    Overview of 10.7
    MDEV-27789
    MariaDB 10.7
    MariaDB 10.6
    MariaDB 10.7.2
    Stable (GA)
    MariaDB 10.7
    What is MariaDB 10.7?

    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.

    Notable Items

    SSL

    • The server no longer tolerates incorrectly configured SSL (MDEV-29811). 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 (MDEV-18589)

    InnoDB

    • Adaptive hash index MDEV-27700, MDEV-29384

    • MVCC and locking (MDEV-29666, MDEV-27927, MDEV-28709, MDEV-29635)

    • Virtual columns (MDEV-29299, MDEV-29753)

    • InnoDB crash recovery fixes (MDEV-29559)

    • Race condition between KILL and transaction commit ()

    • Implement for InnoDB ()

    • fail to update after bulk insert ()

    • InnoDB bulk insert bug fixes (, )

    Galera

    • Galera updated to 26.4.13

    • Galera server crashes after 10.3 > 10.4 upgrade (MDEV-29375)

    • status variable prints 0 as port number if the port is not mentioned in system variable (MDEV-28868)

    Replication

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

    • Concurrent statements made to binlog without any mixup (MDEV-25606)

    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

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

    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 issue #469)

    • The environment variable LANG=C.UTF-8 has been added for those that exec into containers and copy paste UTF8 characters (fixes issue #468).

    • Adds OCI labels to image (fixes issue 436 and users need for version)

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

    Security

    • Fixes for the following :

      • CVE--``#

    Changelog

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

    Contributors

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

    MariaDB 10.7
    MariaDB 10.7.8
    Download Now
    Download 10.7.7
    Release Notes
    Changelog
    Overview of 10.7
    MariaDB 10.7
    MariaDB 10.6
    MariaDB 10.7.7
    Stable (GA)
    MariaDB 10.7
    What is MariaDB 10.7?

    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-26307
    MDEV-10075
    MDEV-24947
    MDEV-24843
    subscribing

    MariaDB 10.7.5 Release Notes

    The most recent release of MariaDB 10.7 is:MariaDB 10.7.8 Stable (GA) Download Now

    Download 10.7.5 | Release Notes | Changelog | Overview of 10.7

    Release date: 15 Aug 2022

    MariaDB 10.7 is a previous short-term maintenance stable series of MariaDB, supported until February 2023. It is an evolution of MariaDB 10.6 with several entirely new features.

    MariaDB 10.7.5 is a Stable (GA) release.

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

    Thanks, and enjoy MariaDB!

    Notable Items

    InnoDB

    • InnoDB corruption due to lack of file locking ()

    • FULLTEXT search with apostrophe, and mandatory words ()

    • ALTER TABLE IMPORT TABLESPACE corrupts an encrypted table ()

    • ALTER TABLE wrong-result fix ()

    Replication

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

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

    Galera

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

    • Galera4 not able to report proper wsrep_incoming_addresses ()

    Optimizer

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

    • restore_prev_nj_state() doesn't update cur_sj_inner_tables correctly ()

      • Subquery semi-join optimization could miss LooseScan or FirstMatch strategies for certain queries.

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

    Spider

    • and have been deprecated (, )

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

    JSON

    • : extract document fragment into JSON column ()

    CONNECT

    • now supports with ()

    General

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

    • ALTER TABLE ALGORITHM=NOCOPY does not work after upgrade (

    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 .

    sudo rpm --import https://supplychain.mariadb.com/MariaDB-Server-GPG-KEY

    Crash recovery fixes (MDEV-28668, MDEV-28731)

  • DDL crash recovery fixes (MDEV-28752, MDEV-28802, MDEV-28864, MDEV-28870, MDEV-28923, MDEV-28977)

  • Avoid crashes on corrupted data (MDEV-13542, MDEV-18519, MDEV-21098, MDEV-22388, MDEV-28457, MDEV-28950)

  • Bulk load bug fixes (MDEV-28242, MDEV-28679)

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

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

  • Galera should replicate nextval()-related changes in sequences with INCREMENT <> 0, at least NOCACHE ones with engine=InnoDB (MDEV-27862)

  • Add support for OpenSSL 3.0 in Galera (MDEV-25949)

  • A query with a subuquery in this form could cause a crash:
  • Optimizer uses all partitions after upgrade to 10.3 (MDEV-28246)

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

    • The issue can be observed on MariaDB 10.5.9 and later versions which have the fix for MDEV-9750. 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.:

  • )
  • Server crash upon CREATE VIEW with unknown column in ON condition (MDEV-29088)

  • password_reuse_check plugin mixes username and password (MDEV-28838)

  • As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.7 for Debian 10 "Buster" for ppc64el

  • Repositories for Ubuntu 22.04 and RHEL/Rocky 9 have been added in this release

  • CVE-2022-32081

  • CVE-2018-25032

  • CVE-2022-32091

  • CVE-2022-38791

  • CVE-2022-32084

  • MDEV-28495
    MDEV-20797
    MDEV-28779
    MDEV-26294
    MDEV-29078
    MDEV-21087
    MDEV-21443
    MDEV-28487
    Galera
    MDEV-28546
    MDEV-25068
    MDEV-20627
    MDEV-23809
    MDEV-29139
    MDEV-26427
    MDEV-28749
    MDEV-28858
    spider_init_sql_alloc_size
    spider_buffer_size
    MDEV-27926
    MDEV-28560
    MDEV-28479
    MDEV-25875
    CONNECT Engine
    Mysql Table type
    MDEV-27766
    MDEV-29225
    MDEV-29188
    CVE-2023-5157
    CVE-2022-32082
    CVE-2022-32089
    MariaDB 10.7.5
    changelog
    MariaDB 10.7.5
    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-28727
    MDEV-26784
    MDEV-27022
    MDEV-27183
    MDEV-27610
    MariaDB Backup
    MDEV-26326
    MDEV-27736
    MDEV-27276
    MDEV-26223
    mariadb_repo_setup
    mariadb-keyring-2019.gpg
    mariadb-keyring-2019.gpg.sha256
    issue #401
    reddit suggestion
    MDEV-27608
    MDEV-23326
    CVE-2022-24048
    CVE-2021-46659
    CVE-2022-0778
    CVE-2022-21595
    subscribing
    MDEV-29368
    MDEV-24402
    MDEV-28327
    MDEV-29570
    MDEV-29761
    subscribing

    MariaDB 10.7.4 Release Notes

    The most recent release of is: Stable (GA)

    | | |

    Release date: 20 May 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!

    ... ANY (SELECT ... GROUP BY (SELECT redundant_subselect_here)) ...
    table.keyXpartY [NOT] IN ( ... )
    Notable Items

    InnoDB

    • removed (MDEV-25975)

    • InnoDB gap locking fixes (MDEV-20605, MDEV-28422)

    • InnoDB performance improvements (MDEV-27557, MDEV-28185, MDEV-27767, MDEV-28313, MDEV-28137, MDEV-28465, MDEV-26789)

    • Backup regression fixes (MDEV-27919)

    • InnoDB portability: FreeBSD futexes (), POWER and s390x transactional memory ()

    • ALTER TABLE: Fixed bogus duplicate key errors ()

    • DDL and crash recovery fixes (, , )

    • Requests to recalculate were sometimes lost ()

    Replication

    • Semisync-slave server recovery is refined to correctly rollback prepared transaction (MDEV-28461)

    • Circular semisync setup endless event circulation is handled (MDEV-27760)

    • Semisync-slave server recovery is extended to work on new server_id server (MDEV-27342)

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

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

    • Binlogs disappear after rsync IST ()

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

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

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

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

    • stops issuing unnecessary "Unsafe statement" with ()

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

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

    Backup

    • Incorrect binlogs after Galera SST using rsync and MariaDB Backup (MDEV-27524)

    • MariaDB Backup does not detect multi-source replication slave (MDEV-21037)

    • Useless warning "InnoDB: Allocated tablespace ID for , old maximum was 0" during backup stage (MDEV-27343)

    • MariaDB Backup prepare fails for incrementals if a new schema is created after full backup is taken (MDEV-28446)

    Optimizer

    • Query performance degradation in newer MariaDB versions when using many tables (MDEV-28073)

    • A SEGV in Item_field::used_tables/update_depend_map_for_order... (MDEV-26402)

    • ANALYZE FORMAT=JSON fields are incorrect for UNION ALL queries (MDEV-27699)

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

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

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

    Spider

    The following variables have been deprecated:

    • and (MDEV-28010)

    • and (MDEV-28008)

    • (MDEV-27981)

    • (MDEV-28297)

    • , , and ()

    • , , , , ()

    • ()

    • ()

    General

    • Server error messages are (MDEV-28227)

    • 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 not yet available pending the resolution of MDEV-28133: Backport OpenSSL-3.0 compatibility to 10.6 branch

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

    Security

    • Fixes for the following :

      • CVE-2021-46669

      • CVE-2022-27376

      • CVE-2022-27377

    Changelog

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

    Contributors

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

    MariaDB 10.7
    MariaDB 10.7.8
    Download Now
    Download 10.7.4
    Release Notes
    Changelog
    Overview of 10.7
    MariaDB 10.7
    MariaDB 10.6
    MariaDB 10.7.4
    Stable (GA)
    MariaDB 10.7
    What is MariaDB 10.7?

    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-26476
    MDEV-27956
    MDEV-15250
    MDEV-27274
    MDEV-27234
    MDEV-27817
    MDEV-27805
    MDEV-11853
    MDEV-28583
    MDEV-25580
    MDEV-24617
    MDEV-28550
    MDEV-28310
    MDEV-21810
    MDEV-27697
    MDEV-14608
    MDEV-19398
    MDEV-28268
    MDEV-26164
    MDEV-26047
    MDEV-25994
    MDEV-24560
    MDEV-28437
    MDEV-28007
    MDEV-28005
    MDEV-27923
    MDEV-28244
    CVE-2022-27378
    CVE-2022-27379
    CVE-2022-27380
    CVE-2022-27381
    CVE-2022-27382
    CVE-2022-27383
    CVE-2022-27384
    CVE-2022-27386
    CVE-2022-27387
    CVE-2022-27444
    CVE-2022-27445
    CVE-2022-27446
    CVE-2022-27447
    CVE-2022-27448
    CVE-2022-27449
    CVE-2022-27451
    CVE-2022-27452
    CVE-2022-27455
    CVE-2022-27456
    CVE-2022-27457
    CVE-2022-27458
    CVE-2022-32087
    CVE-2022-32086
    CVE-2022-32085
    CVE-2022-32083
    CVE-2022-32088
    subscribing
    wsrep_replicate_myisam
    wsrep_strict_ddl
    wsrep_replicate_myisam
    wsrep_strict_ddl
    wsrep_incoming_addresses
    wsrep_node_incoming_address

    MariaDB 10.7.1 Release Notes

    The most recent release of MariaDB 10.7 is:MariaDB 10.7.8 Stable (GA) Download Now

    Download 10.7.1 | Release Notes | Changelog | Overview of 10.7

    Release date: 8 Nov 2021

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

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

    MariaDB 10.7.1 is a Release Candidate (RC) release.

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

    Thanks, and enjoy MariaDB!

    Notable Items

    This release includes all features from the preview releases except for the JSON histogram preview feature, which was not ready in time to be included.

    Performance Schema

    • Comments have been added for each table column in the to improve documentation (). For example:

    Diagnostics

    • The property introduced in to identify the affected row has been renamed to the more intuitive ROW_NUMBER (, )

    Provider Plugins

    • Five provider plugins (bzip2, lzma, lz4, lzo, snappy) provide to the server and storage engines (, ).

    SFORMAT

    • function for arbitrary text formatting (, ).

    UUID

    • New (, )

    Natural Sort

    • function (, ).

    Convert Partitions

    • (, ), and

    • () as an easy way to convert tables to partitions and back in one command, instead of a sequence of CREATE/EXCHANGE/DROP

    • The redundant PARTITION keyword is now optional in the ()

    Password Reuse

    • The is a new password validation plugin that prevents the new password from being the same as the one being used during the configurable retention period. (, ).

    InnoDB

    • In bulk insert, pre-sort and build indexes one page at a time ()

    • Linux after kernel version 5.10 has a io-uring regression causing a write to storage to be lost, or not acknowledged. As such will default to 0 (off) until 5.16. If is enabled in your configuration, a warning will be logged, however it will continue with the io-uring enabled, potentially resulting in a hang, or an assertion later. The long term support kernel 5.14.14 we haven't observed failures, and 5.15.0-rc7 failures have been observed, though less frequently. If you have explicitly enabled, and are using watch out for a lack of InnoDB updates followed by a 10 minute timeout. See for details.

    • ALTER TABLE…IMPORT TABLESPACE fixes (, , ,

    Replication

    • Memory hogging on slave by ROW event applier is eliminated ()

    • mysql --binary-mode now properly handles \\0 in data ()

    • Fixes race condition between SHOW BINARY LOGS and RESET MASTER ()

    Packaging & Misc

    • Session tracking flag in OK_PACKET ()

    • Some views force server (and mysqldump) to generate invalid SQL for their definitions ()

    • function to check for equality between JSON objects ().

    • function, which recursively sorts keys and removes spaces ()

    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!

    )
  • innodb_undo_log_truncate fixes (MDEV-26445, MDEV-26450, MDEV-26672, MDEV-26864)

  • Page I/O performance fixes (MDEV-25215, MDEV-26547, MDEV-26626, MDEV-26819)

  • Replication timeouts with XA PREPARE (MDEV-26682)

  • Improved DDL and data dictionary (MDEV-25919)

  • Performance fixes (MDEV-26356, MDEV-26467, MDEV-26826)

  • Improve simple multibyte collation performance on the ASCII range (MDEV-26572).

  • Add option to as of specified timestamp (MDEV-16355).

  • Multi-source replication supports MySQL-style CHANNEL syntax (MDEV-26307)

  • wsrep_replicate_myisam and wsrep_strict_ddl deprecated system variables were removed (MDEV-24947, MDEV-24843)

  • MariaDB 10.7.0
    MDEV-25325
    GET DIAGNOSTICS
    MariaDB 10.7.0
    MDEV-26611
    MDEV-10075
    MDEV-12933
    blog post
    MDEV-25015
    blog post
    MDEV-4958
    blog post
    MDEV-4742
    blog post
    MDEV-22166
    blog post
    MDEV-22165
    MDEV-26471
    MDEV-9245
    blog post
    MDEV-24621
    innodb_use_native_aio
    innodb_use_native_aio
    innodb_use_native_aio
    MDEV-26674
    MDEV-18543
    MDEV-20931
    MDEV-26131
    MDEV-26712
    MDEV-25444
    MDEV-20215
    MDEV-26868
    MDEV-26299
    MDEV-23143
    MDEV-16375
    MariaDB 10.7.1
    changelog
    MariaDB 10.7.1
    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-26621
    SELECT column_name, column_comment FROM information_schema.columns 
      WHERE table_schema='performance_schema' AND table_name='file_instances';
    ...
    *************************** 2. row ***************************
       column_name: EVENT_NAME
    column_comment: Instrument name associated with the file.
    *************************** 3. row ***************************
       column_name: OPEN_COUNT
    column_comment: Open handles on the file. A value of greater than zero means 
                    that the file is currently open.
    ...
    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
    GPG
    Full-text index
    system versioning
    innodb_undo_log_truncate=ON
    InnoDB buffer pool
    JSON_PRETTY
    JSON_DETAILED
    security vulnerabilities
    Upgrading Between Major MariaDB Versions
    Upgrading from MariaDB 10.6 to MariaDB 10.7
    UUID data type
    JSON_EQUALS
    JSON_NORMALIZE
    NATURAL_SORT_KEY
    compression capabilities
    SFORMAT
    dump
    system versioned table
    GET DIAGNOSTICS
    System Variables Added in MariaDB 10.7
    Security Vulnerabilities Fixed in MariaDB
    security vulnerabilities
    JSON_VALUE()
    mariadb-upgrade
    innodb_change_buffering=none
    security vulnerabilities
    compression capabilities
    SFORMAT
    UUID data type
    NATURAL_SORT_KEY
    password_reuse_check plugin
    JSON_EQUALS
    JSON_NORMALIZE
    dump
    system versioned table
    GET DIAGNOSTICS
    --skip-symbolic-links
    CHAR
    collations
    mariadb_repo_setup
    security vulnerabilities
    ROW_FORMAT=COMPRESSED
    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_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
    Performance Schema
    compression capabilities
    SFORMAT
    UUID data type
    NATURAL_SORT_KEY
    ALTER TABLE ... CONVERT PARTITION .. TO TABLE
    ALTER TABLE ... CONVERT TABLE ... TO PARTITION ...
    partition definition
    password_reuse_check plugin
    JSON_EQUALS
    JSON_NORMALIZE
    security vulnerabilities
    dump
    system versioned table

    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