See details in the attached test case. If we create the right spread of values in the key and pick the range just right, when rowid_filter optimizer switch is enabled, the optimizer will sacrifice a part of the key for the rowid_filter. As a result we use only the u_delete_user and end up examining 5K+ rows out of 10K in the table. If we disable rowid_filter, the user_name constraint is being used, and we examine only 1 row.
causes
MDEV-30142
rowid_filter: negative access cost factor values
Closed
duplicates
MDEV-19720
Server crash in st_join_table::save_explain_data or Assertion `sel->quick' failed in JOIN::make_range_rowid_filters with rowid_filter=on
Closed
is caused by
MDEV-16188
Use in-memory PK filters built from range index scans
Closed
mentioned in
Page Failed to load
Page Failed to load
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Page Loading...
Show 22 more links (22 mentioned in)
{"report":{"fcp":710.3000001907349,"ttfb":200.80000019073486,"pageVisibility":"visible","entityId":111925,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"c9ad5d37-9b67-40c1-91de-2aaa0e3e7582","navigationType":0,"readyForUser":798.0999999046326,"redirectCount":0,"resourceLoadedEnd":863,"resourceLoadedStart":205.09999990463257,"resourceTiming":[{"duration":6.200000286102295,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":205.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":205.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":211.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":6.199999809265137,"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":205.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":205.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":211.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":59.200000286102295,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":205.59999990463257,"connectEnd":205.59999990463257,"connectStart":205.59999990463257,"domainLookupEnd":205.59999990463257,"domainLookupStart":205.59999990463257,"fetchStart":205.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":205.59999990463257,"responseEnd":264.80000019073486,"responseStart":264.80000019073486,"secureConnectionStart":205.59999990463257},{"duration":132,"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":209.69999980926514,"connectEnd":209.69999980926514,"connectStart":209.69999980926514,"domainLookupEnd":209.69999980926514,"domainLookupStart":209.69999980926514,"fetchStart":209.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":209.69999980926514,"responseEnd":341.69999980926514,"responseStart":341.69999980926514,"secureConnectionStart":209.69999980926514},{"duration":136,"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":209.80000019073486,"connectEnd":209.80000019073486,"connectStart":209.80000019073486,"domainLookupEnd":209.80000019073486,"domainLookupStart":209.80000019073486,"fetchStart":209.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":209.80000019073486,"responseEnd":345.80000019073486,"responseStart":345.80000019073486,"secureConnectionStart":209.80000019073486},{"duration":136.09999990463257,"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":210,"connectEnd":210,"connectStart":210,"domainLookupEnd":210,"domainLookupStart":210,"fetchStart":210,"redirectEnd":0,"redirectStart":0,"requestStart":210,"responseEnd":346.09999990463257,"responseStart":346.09999990463257,"secureConnectionStart":210},{"duration":136.30000019073486,"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":210.19999980926514,"connectEnd":210.19999980926514,"connectStart":210.19999980926514,"domainLookupEnd":210.19999980926514,"domainLookupStart":210.19999980926514,"fetchStart":210.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":210.19999980926514,"responseEnd":346.5,"responseStart":346.5,"secureConnectionStart":210.19999980926514},{"duration":196.09999990463257,"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":210.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":210.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":406.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":136.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":210.5,"connectEnd":210.5,"connectStart":210.5,"domainLookupEnd":210.5,"domainLookupStart":210.5,"fetchStart":210.5,"redirectEnd":0,"redirectStart":0,"requestStart":210.5,"responseEnd":347,"responseStart":347,"secureConnectionStart":210.5},{"duration":195.80000019073486,"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":210.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":210.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":406.5,"responseStart":0,"secureConnectionStart":0},{"duration":136.7999997138977,"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":210.80000019073486,"connectEnd":210.80000019073486,"connectStart":210.80000019073486,"domainLookupEnd":210.80000019073486,"domainLookupStart":210.80000019073486,"fetchStart":210.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":210.80000019073486,"responseEnd":347.59999990463257,"responseStart":347.59999990463257,"secureConnectionStart":210.80000019073486},{"duration":590.1999998092651,"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":220.5,"connectEnd":220.5,"connectStart":220.5,"domainLookupEnd":220.5,"domainLookupStart":220.5,"fetchStart":220.5,"redirectEnd":0,"redirectStart":0,"requestStart":220.5,"responseEnd":810.6999998092651,"responseStart":810.6999998092651,"secureConnectionStart":220.5},{"duration":585.7000002861023,"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":227.19999980926514,"connectEnd":227.19999980926514,"connectStart":227.19999980926514,"domainLookupEnd":227.19999980926514,"domainLookupStart":227.19999980926514,"fetchStart":227.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":227.19999980926514,"responseEnd":812.9000000953674,"responseStart":812.9000000953674,"secureConnectionStart":227.19999980926514},{"duration":392.90000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":418.09999990463257,"connectEnd":418.09999990463257,"connectStart":418.09999990463257,"domainLookupEnd":418.09999990463257,"domainLookupStart":418.09999990463257,"fetchStart":418.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":418.09999990463257,"responseEnd":811,"responseStart":811,"secureConnectionStart":418.09999990463257},{"duration":192.59999990463257,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":704.4000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":704.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":897,"responseStart":0,"secureConnectionStart":0},{"duration":17.09999990463257,"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":845.9000000953674,"connectEnd":845.9000000953674,"connectStart":845.9000000953674,"domainLookupEnd":845.9000000953674,"domainLookupStart":845.9000000953674,"fetchStart":845.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":845.9000000953674,"responseEnd":863,"responseStart":863,"secureConnectionStart":845.9000000953674}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":5,"responseStart":201,"responseEnd":227,"domLoading":204,"domInteractive":933,"domContentLoadedEventStart":933,"domContentLoadedEventEnd":975,"domComplete":1598,"loadEventStart":1598,"loadEventEnd":1598,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":906.8000001907349},{"name":"bigPipe.sidebar-id.end","time":907.5999999046326},{"name":"bigPipe.activity-panel-pipe-id.start","time":907.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":910.1999998092651},{"name":"activityTabFullyLoaded","time":983.5}],"measures":[],"correlationId":"992ce355847b6f","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":124,"dbReadsTimeInMs":17,"dbConnsTimeInMs":26,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Critical MDEV-30142 rowid_filter: negative access cost factor values
MDEV-16188 Use in-memory PK filters built from range index scans
Page Failed to load
Page Loading...