The recent MySQL 8.0.40 release include the following changes that affect InnoDB source code files:
Not applicable to MariaDB Server
Bug #33398681 ibd tablespace file is moved back from innodb_directories to datadir after ALTER TABLE
This is related to the MySQL 8.0 Global Data Dictionary. MariaDB did not switch to that format.
Bug#36500268 Upgrade to clang-format 15
In MariaDB Server, source code files are not being reformatted in bulk.
Bug#36522343 std::this_thread::sleep_for(std::chrono::seconds(0)) is a noop
MariaDB Server is not invoking any 0-second sleeps. In mariadb-backup there is some unreachable code (MDEV-35165).
Bug#35531293 MySQL 8.0.33 is slower than MySQL 8.0.28 with queries using JOINS
This seems to fix a regression that was introduced by the MySQL version of MDEV-15562. In MariaDB Server, a smaller change was implemented to the index record format and a separate function added for accessing clustered index leaf page records.
Bug#36730830 Assertion failure: log0files_governor.cc:1868:it != log.m_files.end() thread 140
MariaDB Server writes just one ib_logfile0 from a single thread at a time.
Bug#36808732 Crash in restart after creating 10,000 tables
Bug#35200385 The parallel tablespace scan in 8.0 doesn't work as expected (follow-up)
These are equivalent to the 3 commits that were included in MySQL 8.0.39 and judged in MDEV-34672 as inapplicable.
Bug#35343458 Do not attempt to drop FTS tables when parent tablespace is discarded
This is fixing a regression due to an earlier change related to the MySQL 8.0 Global Data Dictionary, which is not present in MariaDB Server.
Bug#36723117 Crash using a secondary index after dropping a column with ALGORITHM=INSTANT
When Oracle copied the idea of MDEV-15562, they did it differently, associating multiple index metadata versions with the table. They had failed to access the correct index object in some place.
Bug#36824054 scope_guard's use of "commit" and "rollback" confusing and non-standard
This is merely renaming some member functions in a RAII style helper that does not exist in MariaDB Server. The commit message mentions ‘standard’, but there is no scope_guard in any version of ISO/IEC 14882 yet, as far as I can tell.
Bug#36341532 End range check not working with multi-value indexes
Bug#33334911 Multi-valued index performance is too slow (Access too many rows than required)
MariaDB Server does not support other forms of inverted index than FULLTEXT INDEX.
Bug#36210202 FTS_DOC_ID comparison incorrect for large values (follow-up)
MDEV-33383 had already fixed this in MariaDB Server.
Bug#35992036 innodb.ddl_kill test fails sporadically
This is fixing some DEBUG_SYNC injection of a test case that is specific to parallel index creation in MySQL 8.0. MariaDB is yet to implement something like that, in MDEV-16281.
Bug#35799038 difference in strict mode lead importing tablespace crash
No crash is reproducible, but MDEV-35169 was filed nevertheless.
Bug#36705034 pwrite(buf) points to uninitialized byte(s) in os_fusionio_get_sector_size()
MariaDB uses a different means of detecting FusionIO, which does not involve attempts to invoke pwrite() to a scratch file. Starting with Linux 6.11 there is a more generic interface for this, which we should try to make use of.
Bug#36496164 Correctly initialize FTS when migrating from 5.7 to 8.0
This is related to upgrading from MySQL 5.7 to MySQL 8.0 with the Global Data Dictionary. There never was a radical rewrite of the data dictionary in MariaDB Server.
Bug#36881512 Remove HAVE_CONFIG_H and the generated config.h
This is modifying a source code file that was removed in MDEV-12050.
Bug#36444172 Regression in 8.0.27+ related to Parallel DDL IO Amplification
Bug#36163502 Performance schema counter increments make parallel index create slow
These are related to parallel index creation. MariaDB does not implement MDEV-16281 yet.
Bug#36840107 mysql crash after update inplace in instant ddl redundant table
This is something specific to the MySQL 8.0 counterpart of MDEV-11369. The test case does not produce incorrect results in MariaDB Server.
Bug#37006524 InnoDB: Assertion failure: buf0flu.cc:621:block->page.in_LRU_list
This is a race condition in a debug assertion in the function buf_flush_insert_sorted_into_flush_list(), which was ultimately removed in MDEV-23399.
Bug#36302624 performance_schema.data_lock_waits is generated with O(N³) complexity (follow-up)
MariaDB Server does not contain this view.
Bug#36677952 killing DDL on partitioned tables: Assertion failure: dict0dict.cc:1887:table->get_ref_count() == 0
This is fixing a regression due to a Global Data Dictionary change specific to MySQL 8.0
Bug#36559642 FTS cleanup on DROP INDEX issue when adding a FULLTEXT index in same transaction (follow-up)
This change added a fts_drop_tables() call to fts_drop_index(), which would seem to be the source of trouble when executing a statement like the following:
ALTER TABLE t DROP only_fulltext_index, ADD FULLTEXT INDEX another_fulltext_index(c), ALGORITHM=INPLACE;
|
MDEV-35183 was filed to optimize MariaDB a little in this scenario.
Applicable to MariaDB Server
Bug#36652127 InnoDB: FTS table optimization not working correctly with collation
Filed as MDEV-35172.
Bug#36259487 InnoDB: OS_FILE_NORMAL and OS_FILE_AIO are very misleading
Filed as MDEV-35171.
{"report":{"fcp":1453.7999999523163,"ttfb":285.10000002384186,"pageVisibility":"visible","entityId":131229,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"4e1ae305-0cf2-42c4-ab40-2c1d31f3c781","navigationType":0,"readyForUser":1593.8999999761581,"redirectCount":0,"resourceLoadedEnd":1592.1999999284744,"resourceLoadedStart":293.5,"resourceTiming":[{"duration":39.39999997615814,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":293.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":293.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":332.89999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":40.10000002384186,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":293.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":293.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":334,"responseStart":0,"secureConnectionStart":0},{"duration":619.1000000238419,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":294,"connectEnd":294,"connectStart":294,"domainLookupEnd":294,"domainLookupStart":294,"fetchStart":294,"redirectEnd":0,"redirectStart":0,"requestStart":294,"responseEnd":913.1000000238419,"responseStart":913.1000000238419,"secureConnectionStart":294},{"duration":658.6000000238419,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":294.1999999284744,"connectEnd":294.1999999284744,"connectStart":294.1999999284744,"domainLookupEnd":294.1999999284744,"domainLookupStart":294.1999999284744,"fetchStart":294.1999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":294.1999999284744,"responseEnd":952.7999999523163,"responseStart":952.6999999284744,"secureConnectionStart":294.1999999284744},{"duration":576.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":294.5,"connectEnd":294.5,"connectStart":294.5,"domainLookupEnd":294.5,"domainLookupStart":294.5,"fetchStart":294.5,"redirectEnd":0,"redirectStart":0,"requestStart":294.5,"responseEnd":871,"responseStart":871,"secureConnectionStart":294.5},{"duration":602.6999999284744,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":294.60000002384186,"connectEnd":294.60000002384186,"connectStart":294.60000002384186,"domainLookupEnd":294.60000002384186,"domainLookupStart":294.60000002384186,"fetchStart":294.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":294.60000002384186,"responseEnd":897.2999999523163,"responseStart":897.2999999523163,"secureConnectionStart":294.60000002384186},{"duration":600.9000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":294.6999999284744,"connectEnd":294.6999999284744,"connectStart":294.6999999284744,"domainLookupEnd":294.6999999284744,"domainLookupStart":294.6999999284744,"fetchStart":294.6999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":294.6999999284744,"responseEnd":895.6000000238419,"responseStart":895.6000000238419,"secureConnectionStart":294.6999999284744},{"duration":41.299999952316284,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":295,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":295,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":336.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":600.9000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":295.1999999284744,"connectEnd":295.1999999284744,"connectStart":295.1999999284744,"domainLookupEnd":295.1999999284744,"domainLookupStart":295.1999999284744,"fetchStart":295.1999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":295.1999999284744,"responseEnd":896.1000000238419,"responseStart":896.1000000238419,"secureConnectionStart":295.1999999284744},{"duration":43.700000047683716,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":295.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":295.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":339,"responseStart":0,"secureConnectionStart":0},{"duration":601.1999999284744,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":295.5,"connectEnd":295.5,"connectStart":295.5,"domainLookupEnd":295.5,"domainLookupStart":295.5,"fetchStart":295.5,"redirectEnd":0,"redirectStart":0,"requestStart":295.5,"responseEnd":896.6999999284744,"responseStart":896.6999999284744,"secureConnectionStart":295.5},{"duration":619.8999999761581,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":296.89999997615814,"connectEnd":296.89999997615814,"connectStart":296.89999997615814,"domainLookupEnd":296.89999997615814,"domainLookupStart":296.89999997615814,"fetchStart":296.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":296.89999997615814,"responseEnd":916.7999999523163,"responseStart":916.7999999523163,"secureConnectionStart":296.89999997615814},{"duration":697.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":300.39999997615814,"connectEnd":300.39999997615814,"connectStart":300.39999997615814,"domainLookupEnd":300.39999997615814,"domainLookupStart":300.39999997615814,"fetchStart":300.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":300.39999997615814,"responseEnd":997.6000000238419,"responseStart":997.5,"secureConnectionStart":300.39999997615814},{"duration":189.29999995231628,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1099.5,"connectEnd":1099.5,"connectStart":1099.5,"domainLookupEnd":1099.5,"domainLookupStart":1099.5,"fetchStart":1099.5,"redirectEnd":0,"redirectStart":0,"requestStart":1099.5,"responseEnd":1288.7999999523163,"responseStart":1288.6999999284744,"secureConnectionStart":1099.5},{"duration":218.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":1373.6999999284744,"connectEnd":1373.6999999284744,"connectStart":1373.6999999284744,"domainLookupEnd":1373.6999999284744,"domainLookupStart":1373.6999999284744,"fetchStart":1373.6999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":1373.6999999284744,"responseEnd":1592.1999999284744,"responseStart":1592.1999999284744,"secureConnectionStart":1373.6999999284744},{"duration":266.8000000715256,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1419.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1419.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1686.1000000238419,"responseStart":0,"secureConnectionStart":0}],"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":1,"connectEnd":1,"requestStart":55,"responseStart":286,"responseEnd":294,"domLoading":290,"domInteractive":1719,"domContentLoadedEventStart":1719,"domContentLoadedEventEnd":1778,"domComplete":1947,"loadEventStart":1947,"loadEventEnd":1947,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1688},{"name":"bigPipe.sidebar-id.end","time":1688.8999999761581},{"name":"bigPipe.activity-panel-pipe-id.start","time":1689.1000000238419},{"name":"bigPipe.activity-panel-pipe-id.end","time":1689.8999999761581},{"name":"activityTabFullyLoaded","time":1794.6999999284744}],"measures":[],"correlationId":"1e976ee7b15b18","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":151,"dbReadsTimeInMs":40,"dbConnsTimeInMs":52,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Because none of the bugs
MDEV-35171, MDEV-35172,MDEV-35183look like security issues but mere optimization or cleanup, and because implementing them in MariaDB would require some significant effort (the changes are not directly applicable, or test cases are missing), we can close this, concluding that all must-have InnoDB changes from MySQL 8.0.40 are already included in MariaDB Server.