Both our code and the referenced MySQL work log mention not only index merge but also others (like index_merge_union). Judging from our code, it appears that codepaths where some index_merge_* optimizer switch is used are gated by the index merge option itself (as though it is a top-level switch) so it appears sufficient for the new hint to affect only index merge, and the others will either be enabled or disabled accordingly. Testing will bear it out and I'll update accordingly.
Dave Gosselin
added a comment - - edited Both our code and the referenced MySQL work log mention not only index merge but also others (like index_merge_union). Judging from our code, it appears that codepaths where some index_merge_* optimizer switch is used are gated by the index merge option itself (as though it is a top-level switch) so it appears sufficient for the new hint to affect only index merge, and the others will either be enabled or disabled accordingly. Testing will bear it out and I'll update accordingly.
People
Dave Gosselin
Sergei Petrunia
Votes:
0Vote for this issue
Watchers:
4Start watching this issue
Dates
Created:
Updated:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":720.9000000953674,"ttfb":155.09999990463257,"pageVisibility":"visible","entityId":132905,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"9ba6e2d1-b202-4dba-8c5b-4e1d6a239cf7","navigationType":0,"readyForUser":825.4000000953674,"redirectCount":0,"resourceLoadedEnd":458.90000009536743,"resourceLoadedStart":169.30000019073486,"resourceTiming":[{"duration":13.199999809265137,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":169.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":169.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":182.5,"responseStart":0,"secureConnectionStart":0},{"duration":14.900000095367432,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":169.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":169.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":184.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":120.10000038146973,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":169.69999980926514,"connectEnd":169.69999980926514,"connectStart":169.69999980926514,"domainLookupEnd":169.69999980926514,"domainLookupStart":169.69999980926514,"fetchStart":169.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":186.30000019073486,"responseEnd":289.80000019073486,"responseStart":242.80000019073486,"secureConnectionStart":169.69999980926514},{"duration":288.7000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":170.19999980926514,"connectEnd":188.80000019073486,"connectStart":188.80000019073486,"domainLookupEnd":188.80000019073486,"domainLookupStart":188.80000019073486,"fetchStart":170.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":189,"responseEnd":458.90000009536743,"responseStart":205.19999980926514,"secureConnectionStart":188.80000019073486},{"duration":47.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":170.30000019073486,"connectEnd":170.30000019073486,"connectStart":170.30000019073486,"domainLookupEnd":170.30000019073486,"domainLookupStart":170.30000019073486,"fetchStart":170.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":190.40000009536743,"responseEnd":217.80000019073486,"responseStart":210.19999980926514,"secureConnectionStart":170.30000019073486},{"duration":48.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":170.40000009536743,"connectEnd":170.40000009536743,"connectStart":170.40000009536743,"domainLookupEnd":170.40000009536743,"domainLookupStart":170.40000009536743,"fetchStart":170.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":193.09999990463257,"responseEnd":218.5,"responseStart":212,"secureConnectionStart":170.40000009536743},{"duration":48.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":170.5,"connectEnd":170.5,"connectStart":170.5,"domainLookupEnd":170.5,"domainLookupStart":170.5,"fetchStart":170.5,"redirectEnd":0,"redirectStart":0,"requestStart":193.19999980926514,"responseEnd":218.80000019073486,"responseStart":213,"secureConnectionStart":170.5},{"duration":20.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":170.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":170.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":191.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":48.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":170.69999980926514,"connectEnd":170.69999980926514,"connectStart":170.69999980926514,"domainLookupEnd":170.69999980926514,"domainLookupStart":170.69999980926514,"fetchStart":170.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":193.40000009536743,"responseEnd":219.19999980926514,"responseStart":213.80000019073486,"secureConnectionStart":170.69999980926514},{"duration":22,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/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":170.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":170.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":192.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":51.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/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":171,"connectEnd":171,"connectStart":171,"domainLookupEnd":171,"domainLookupStart":171,"fetchStart":171,"redirectEnd":0,"redirectStart":0,"requestStart":195.09999990463257,"responseEnd":222.40000009536743,"responseStart":214.59999990463257,"secureConnectionStart":171},{"duration":267.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":183.30000019073486,"connectEnd":183.30000019073486,"connectStart":183.30000019073486,"domainLookupEnd":183.30000019073486,"domainLookupStart":183.30000019073486,"fetchStart":183.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":217.59999990463257,"responseEnd":450.90000009536743,"responseStart":444.19999980926514,"secureConnectionStart":183.30000019073486},{"duration":270.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":183.40000009536743,"connectEnd":183.40000009536743,"connectStart":183.40000009536743,"domainLookupEnd":183.40000009536743,"domainLookupStart":183.40000009536743,"fetchStart":183.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":226.40000009536743,"responseEnd":454.09999990463257,"responseStart":447.69999980926514,"secureConnectionStart":183.40000009536743},{"duration":74.5,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":432.09999990463257,"connectEnd":432.09999990463257,"connectStart":432.09999990463257,"domainLookupEnd":432.09999990463257,"domainLookupStart":432.09999990463257,"fetchStart":432.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":471.59999990463257,"responseEnd":506.59999990463257,"responseStart":505.5,"secureConnectionStart":432.09999990463257},{"duration":180.90000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":675.9000000953674,"connectEnd":675.9000000953674,"connectStart":675.9000000953674,"domainLookupEnd":675.9000000953674,"domainLookupStart":675.9000000953674,"fetchStart":675.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":820.6999998092651,"responseEnd":856.8000001907349,"responseStart":855.6999998092651,"secureConnectionStart":675.9000000953674}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":31,"responseStart":155,"responseEnd":183,"domLoading":159,"domInteractive":877,"domContentLoadedEventStart":877,"domContentLoadedEventEnd":922,"domComplete":1386,"loadEventStart":1386,"loadEventEnd":1386,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":856.0999999046326},{"name":"bigPipe.sidebar-id.end","time":856.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.start","time":857.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.end","time":858.1999998092651},{"name":"activityTabFullyLoaded","time":939.4000000953674}],"measures":[],"correlationId":"9451d0c0ca44f4","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":69,"dbReadsTimeInMs":13,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
New Feature
Critical
MDEV-33281 Implement optimizer hints like in MySQL 8
Both our code and the referenced MySQL work log mention not only index merge but also others (like index_merge_union). Judging from our code, it appears that codepaths where some index_merge_* optimizer switch is used are gated by the index merge option itself (as though it is a top-level switch) so it appears sufficient for the new hint to affect only index merge, and the others will either be enabled or disabled accordingly. Testing will bear it out and I'll update accordingly.