Oracle introduced a Memcached plugin interface to the InnoDB storage engine in MySQL 5.6. That interface is essentially a fork of what seems like an abandoned development branch of Memcached. To my knowledge, there have not been any updates to the Memcached code between MySQL 5.6 and 5.7; only bug fixes and extensions related to the Oracle modifications.
The Memcached plugin is not part of the MariaDB Server. Therefore it does not make sense to include the InnoDB interfaces for the Memcached plugin, or to have any related configuration parameters:
innodb_api_bk_commit_interval
innodb_api_disable_rowlock
innodb_api_enable_binlog
innodb_api_enable_mdl
innodb_api_trx_level
While there is a request to implement Memcached in MariaDB (MDEV-4674), it cannot possibly be completed before the MariaDB Server 10.2 reaches Generally Available status. Removing this code in one commit makes it possible to easily restore it later, in case it turns out to be needed.
Attachments
Issue Links
causes
MDEV-4674[PATCH] NoSQL - Implement Memcached protocol and map it to one table / port
Jan Lindström (Inactive)
added a comment - Let's discuss this, we have PR https://github.com/MariaDB/server/pull/126 to implement our own memcached plugin but it has not progressed after GSoC2015 much.
The patch missed the removal of the error codes DB_DATA_MISMATCH, DB_SCHEMA_NOT_LOCKED.
Also DB_NOT_FOUND was introduced with Memcached, but that code is now being used for ‘file not found’.
The now-unused function mach_write_int_type() should be removed too. Possibly also mach_write_ulonglong().
Marko Mäkelä
added a comment - - edited The patch missed the removal of the error codes DB_DATA_MISMATCH, DB_SCHEMA_NOT_LOCKED.
Also DB_NOT_FOUND was introduced with Memcached, but that code is now being used for ‘file not found’.
The now-unused function mach_write_int_type() should be removed too. Possibly also mach_write_ulonglong().
For the record, I tracked down the exact Memcached revision that is bundled in Oracle MySQL 5.6 and later.
The initial version was somewhat older, but the final updated version was in this commit:
Initial beta of 1.6.0. Apologies for the brief annotation :)
commit 6debef043b7da953c6a427ed687cd0b1d1185dec
Author: Piotr Sikora <piotr.sikora@frickle.com>
Date: Mon Apr 11 15:20:43 2011 -0700
Add missing header (fixes build on OpenBSD).
After this, there have not been any tags starting with 1.6, nor any imports of the Memcached code base. Memcached development seems to continue on the 1.4 stable branch.
Marko Mäkelä
added a comment - For the record, I tracked down the exact Memcached revision that is bundled in Oracle MySQL 5.6 and later.
The initial version was somewhat older, but the final updated version was in this commit :
commit 4b6aeb3065cd7dfe4541a0242f3d3066bf37d625
Author: Jimmy Yang <jimmy.yang@oracle.com>
Date: Fri Sep 23 02:39:00 2011 -0700
Update Memcached to the latest 1.6.0(beta 1).
This appears to correspond to the Memcached engine-pu branch , tag 1.6.0-beta1 . Actually the very last commit is not included:
tag 1.6.0-beta1
Tagger: dormando <dormando@rydia.net>
Date: Mon Apr 11 20:42:46 2011 -0700
Initial beta of 1.6.0. Apologies for the brief annotation :)
commit 6debef043b7da953c6a427ed687cd0b1d1185dec
Author: Piotr Sikora <piotr.sikora@frickle.com>
Date: Mon Apr 11 15:20:43 2011 -0700
Add missing header (fixes build on OpenBSD).
After this, there have not been any tags starting with 1.6, nor any imports of the Memcached code base. Memcached development seems to continue on the 1.4 stable branch.
Marko Mäkelä
added a comment - For the record, the Memcached interface was finally removed in MySQL 8.3.0 . Not completely, maybe because the original authors are gone, and the current MySQL InnoDB maintainers joined Oracle much later.
People
Marko Mäkelä
Marko Mäkelä
Votes:
0Vote for this issue
Watchers:
2Start 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.
{"report":{"fcp":1062,"ttfb":223.89999961853027,"pageVisibility":"visible","entityId":60218,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"94cf9947-51ee-4f28-9324-6eecb20d1d84","navigationType":0,"readyForUser":1149.5999999046326,"redirectCount":0,"resourceLoadedEnd":732.5999999046326,"resourceLoadedStart":236.7999997138977,"resourceTiming":[{"duration":14.300000190734863,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":236.7999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":236.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":251.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":14.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":237.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":237.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":251.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":346.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":237.2999997138977,"connectEnd":255.19999980926514,"connectStart":255.19999980926514,"domainLookupEnd":255.19999980926514,"domainLookupStart":255.19999980926514,"fetchStart":237.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":256.09999990463257,"responseEnd":584.0999999046326,"responseStart":271.7999997138977,"secureConnectionStart":255.19999980926514},{"duration":494.7000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":237.89999961853027,"connectEnd":237.89999961853027,"connectStart":237.89999961853027,"domainLookupEnd":237.89999961853027,"domainLookupStart":237.89999961853027,"fetchStart":237.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":256.5,"responseEnd":732.5999999046326,"responseStart":275.09999990463257,"secureConnectionStart":237.89999961853027},{"duration":36,"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":238.09999990463257,"connectEnd":238.09999990463257,"connectStart":238.09999990463257,"domainLookupEnd":238.09999990463257,"domainLookupStart":238.09999990463257,"fetchStart":238.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":256.69999980926514,"responseEnd":274.09999990463257,"responseStart":269.7999997138977,"secureConnectionStart":238.09999990463257},{"duration":37.90000009536743,"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":238.2999997138977,"connectEnd":238.2999997138977,"connectStart":238.2999997138977,"domainLookupEnd":238.2999997138977,"domainLookupStart":238.2999997138977,"fetchStart":238.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":258.69999980926514,"responseEnd":276.19999980926514,"responseStart":274.19999980926514,"secureConnectionStart":238.2999997138977},{"duration":57.19999980926514,"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":238.5,"connectEnd":238.5,"connectStart":238.5,"domainLookupEnd":238.5,"domainLookupStart":238.5,"fetchStart":238.5,"redirectEnd":0,"redirectStart":0,"requestStart":262.2999997138977,"responseEnd":295.69999980926514,"responseStart":290.59999990463257,"secureConnectionStart":238.5},{"duration":22,"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":238.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":238.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":260.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":57.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":238.7999997138977,"connectEnd":238.7999997138977,"connectStart":238.7999997138977,"domainLookupEnd":238.7999997138977,"domainLookupStart":238.7999997138977,"fetchStart":238.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":264.8999996185303,"responseEnd":296.09999990463257,"responseStart":292.8999996185303,"secureConnectionStart":238.7999997138977},{"duration":27.200000286102295,"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":238.89999961853027,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":238.89999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":266.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":56.799999713897705,"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":239.09999990463257,"connectEnd":239.09999990463257,"connectStart":239.09999990463257,"domainLookupEnd":239.09999990463257,"domainLookupStart":239.09999990463257,"fetchStart":239.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":265.2999997138977,"responseEnd":295.8999996185303,"responseStart":291.2999997138977,"secureConnectionStart":239.09999990463257},{"duration":471.2000002861023,"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":254.39999961853027,"connectEnd":254.39999961853027,"connectStart":254.39999961853027,"domainLookupEnd":254.39999961853027,"domainLookupStart":254.39999961853027,"fetchStart":254.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":334.2999997138977,"responseEnd":725.5999999046326,"responseStart":718.2999997138977,"secureConnectionStart":254.39999961853027},{"duration":471.90000009536743,"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":254.39999961853027,"connectEnd":254.39999961853027,"connectStart":254.39999961853027,"domainLookupEnd":254.39999961853027,"domainLookupStart":254.39999961853027,"fetchStart":254.39999961853027,"redirectEnd":0,"redirectStart":0,"requestStart":335.8999996185303,"responseEnd":726.2999997138977,"responseStart":720,"secureConnectionStart":254.39999961853027},{"duration":58,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":732.3999996185303,"connectEnd":732.3999996185303,"connectStart":732.3999996185303,"domainLookupEnd":732.3999996185303,"domainLookupStart":732.3999996185303,"fetchStart":732.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":753,"responseEnd":790.3999996185303,"responseStart":788.8999996185303,"secureConnectionStart":732.3999996185303},{"duration":156.59999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":969.6999998092651,"connectEnd":969.6999998092651,"connectStart":969.6999998092651,"domainLookupEnd":969.6999998092651,"domainLookupStart":969.6999998092651,"fetchStart":969.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1089.5,"responseEnd":1126.2999997138977,"responseStart":1124.1999998092651,"secureConnectionStart":969.6999998092651}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":56,"responseStart":224,"responseEnd":255,"domLoading":229,"domInteractive":1223,"domContentLoadedEventStart":1223,"domContentLoadedEventEnd":1294,"domComplete":1391,"loadEventStart":1391,"loadEventEnd":1391,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1187.7999997138977},{"name":"bigPipe.sidebar-id.end","time":1188.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1188.7999997138977},{"name":"bigPipe.activity-panel-pipe-id.end","time":1191.3999996185303},{"name":"activityTabFullyLoaded","time":1313}],"measures":[],"correlationId":"93fa08ee14c847","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":92,"dbReadsTimeInMs":9,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Task
Major
Pushed to bb-10.2-marko (on top of some unrelated patches) for test and review.