Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-37371

Merge applicable changes from InnoDB 8.0.43

    XMLWordPrintable

Details

    • Not for Release Notes

    Description

      InnoDB changes between mysql-8.0.42 and mysql-8.0.43

      Not applicable to MariaDB Server

      Bug#37233273 DDL buffer increase has out of control memory usage
      This reduces peak memory usage in some functionality that has not been implemented in MariaDB yet (MDEV-16281).
      Bug#37882398 Assertion failure: ddl0file-reader.cc:193: m_ptr + data_size < m_bounds.second
      This fixes a regression that was observed after the Bug#37233273 fix.
      BUG#32288105 MYSQL CRASHES IMMEDIATELY AFTER SELECTING FROM INFORMATION_SCHEMA test case fixup
      This adjusts some upgrade tests that were last modified in MySQL 8.0.42. As noted in MDEV-36614, this bug is specific to the Global Data Dictionary in MySQL 8.0 and not applicable to MariaDB.
      Revert Bug#37510755 Performance regression in join for tables with many columns
      This change had been added in MySQL 8.0.42. As noted in MDEV-36614, this is specific to the MySQL implementation of instant ADD COLUMN (MDEV-11369) and DROP COLUMN (MDEV-15562). Thanks to the simpler file format in MariaDB, no drastic performance regression was ever observed.
      Bug#37721464 Compile MySQL with GCC 15
      This fixes a compiler warning in some code that had been removed from MariaDB in MDEV-13935.
      Bug#37478594 Virtual column value may be incorrectly set to NULL on cascade update (fixup)
      thiru pointed out that nikitamalyavin fixed this in MDEV-26866 back in 2021, when we were applying some changes from MySQL 5.7.36. This change is following up Bug#33053297.
      Bug#37489167 Update Rollback on BLOB with INSTANT
      This is specific to the MySQL 8.0 implementation of instant ADD COLUMN. In MariaDB MDEV-11369, ROLLBACK will actually roll back any updates of an instantly added column that would change the default value to something else. This scenario is covered in the test innodb.instant_alter_debug from the very beginning.
      Bug#36330455 long semaphore wait crash after failed MEB incremental backup couldn't unregister redo consumer
      This is related to the multi-file WAL implementation in MySQL 8.0 as well as log archiving. In MariaDB, there is only a single ib_logfile0, and no log archiving has been implemented.
      Bug#36682518 Adding index on a temporary table to spatial datatype induces corruption
      This had been fixed more comprehensively in MDEV-27417.
      Bug#37822992 Duplicates may stop the server when rebuilding PK
      This is fixing a crash in some functionality that has not been implemented in MariaDB yet (MDEV-16281).
      Bug#37621360 Importing Table with Instant Drop Column fails
      This is specific to the MySQL 8.0 implementation of instant DROP COLUMN. In MDEV-15562, the format of secondary indexes was not changed. Conceptually, the bug resembles MDEV-18543.

      Applicable to MariaDB Server

      Bug #37682648 InnoDB FTS slow in phrase search due to inefficient matching of doc_id
      This performance bug was filed as MDEV-37370.

      Attachments

        Issue Links

          Activity

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.