Type:
Priority:
Resolution:
Fixed
Affects Version/s:
10.6 , 10.10(EOL) , 10.11 , 11.1(EOL) , 11.2(EOL) , 11.3(EOL)
Ever since MDEV-12227 MDEV-26782
Having read-ahead enabled for temporary tablespace pages would cause debug assertion failures in MDEV-28699
blocks
MDEV-28699
Shrink temporary tablespaces without restart
Closed
made changes -
2023-09-11 11:40
Description
Disable the read-ahead logic for temporary tablespace.
Ever since MDEV-12227 MDEV-26782 MDEV-28699
Labels
performance
Fix Version/s
10.6.16
[ 29014
]
Fix Version/s
10.10.7
[ 29018
]
Fix Version/s
10.11.6
[ 29020
]
Fix Version/s
11.1.3
[ 29023
]
Fix Version/s
11.2.2
[ 29035
]
Fix Version/s
10.6
[ 24028
]
Fix Version/s
10.10
[ 27530
]
Fix Version/s
10.11
[ 27614
]
Fix Version/s
11.1
[ 28549
]
Fix Version/s
11.3
[ 28565
]
Fix Version/s
11.2
[ 28603
]
Resolution
Fixed
[ 1
]
Status
Open
[ 1
]
Closed
[ 6
]
made changes -
2023-09-12 19:53
Link
This issue is part of TODO-4253
[ TODO-4253
]
made changes -
2023-09-12 19:53
Link
This issue is part of TODO-4253
[ TODO-4253
]
made changes -
2023-09-14 07:49
Fix Version/s
11.2.2
[ 29035
]
{"report":{"fcp":818.6999999880791,"ttfb":328.69999998807907,"pageVisibility":"visible","entityId":124955,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"1faef5c7-8557-4a1c-9e9e-3bcd0256b37d","navigationType":0,"readyForUser":888.6000000238419,"redirectCount":0,"resourceLoadedEnd":539.1999999880791,"resourceLoadedStart":333.4000000357628,"resourceTiming":[{"duration":6.699999988079071,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":333.4000000357628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":333.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":340.10000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":6.600000023841858,"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":333.69999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":333.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":340.30000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":103.69999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":333.80000001192093,"connectEnd":333.80000001192093,"connectStart":333.80000001192093,"domainLookupEnd":333.80000001192093,"domainLookupStart":333.80000001192093,"fetchStart":333.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":343.80000001192093,"responseEnd":437.5,"responseStart":364.80000001192093,"secureConnectionStart":333.80000001192093},{"duration":205.19999998807907,"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":334,"connectEnd":334,"connectStart":334,"domainLookupEnd":334,"domainLookupStart":334,"fetchStart":334,"redirectEnd":0,"redirectStart":0,"requestStart":344,"responseEnd":539.1999999880791,"responseStart":363.5,"secureConnectionStart":334},{"duration":7.800000011920929,"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":334.10000002384186,"connectEnd":334.10000002384186,"connectStart":334.10000002384186,"domainLookupEnd":334.10000002384186,"domainLookupStart":334.10000002384186,"fetchStart":334.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":334.10000002384186,"responseEnd":341.9000000357628,"responseStart":341.9000000357628,"secureConnectionStart":334.10000002384186},{"duration":9,"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":334.30000001192093,"connectEnd":334.30000001192093,"connectStart":334.30000001192093,"domainLookupEnd":334.30000001192093,"domainLookupStart":334.30000001192093,"fetchStart":334.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":334.30000001192093,"responseEnd":343.30000001192093,"responseStart":343.30000001192093,"secureConnectionStart":334.30000001192093},{"duration":9.600000023841858,"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":334.5,"connectEnd":334.5,"connectStart":334.5,"domainLookupEnd":334.5,"domainLookupStart":334.5,"fetchStart":334.5,"redirectEnd":0,"redirectStart":0,"requestStart":334.5,"responseEnd":344.10000002384186,"responseStart":344.10000002384186,"secureConnectionStart":334.5},{"duration":10.400000035762787,"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":334.69999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":334.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":345.10000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":10.899999976158142,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":334.80000001192093,"connectEnd":334.80000001192093,"connectStart":334.80000001192093,"domainLookupEnd":334.80000001192093,"domainLookupStart":334.80000001192093,"fetchStart":334.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":334.80000001192093,"responseEnd":345.69999998807907,"responseStart":345.60000002384186,"secureConnectionStart":334.80000001192093},{"duration":11.300000011920929,"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":335,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":335,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":346.30000001192093,"responseStart":0,"secureConnectionStart":0},{"duration":12.399999976158142,"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":335.10000002384186,"connectEnd":335.10000002384186,"connectStart":335.10000002384186,"domainLookupEnd":335.10000002384186,"domainLookupStart":335.10000002384186,"fetchStart":335.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":335.10000002384186,"responseEnd":347.5,"responseStart":347.5,"secureConnectionStart":335.10000002384186},{"duration":12.899999976158142,"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":341.10000002384186,"connectEnd":341.10000002384186,"connectStart":341.10000002384186,"domainLookupEnd":341.10000002384186,"domainLookupStart":341.10000002384186,"fetchStart":341.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":341.10000002384186,"responseEnd":354,"responseStart":354,"secureConnectionStart":341.10000002384186},{"duration":14.699999988079071,"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":343,"connectEnd":343,"connectStart":343,"domainLookupEnd":343,"domainLookupStart":343,"fetchStart":343,"redirectEnd":0,"redirectStart":0,"requestStart":343,"responseEnd":357.69999998807907,"responseStart":357.69999998807907,"secureConnectionStart":343},{"duration":222.39999997615814,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":582.1000000238419,"connectEnd":582.1000000238419,"connectStart":582.1000000238419,"domainLookupEnd":582.1000000238419,"domainLookupStart":582.1000000238419,"fetchStart":582.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":770.3000000119209,"responseEnd":804.5,"responseStart":803.6999999880791,"secureConnectionStart":582.1000000238419}],"fetchStart":0,"domainLookupStart":46,"domainLookupEnd":63,"connectStart":63,"connectEnd":83,"secureConnectionStart":72,"requestStart":83,"responseStart":329,"responseEnd":343,"domLoading":332,"domInteractive":947,"domContentLoadedEventStart":947,"domContentLoadedEventEnd":990,"domComplete":2156,"loadEventStart":2156,"loadEventEnd":2156,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":921.1999999880791},{"name":"bigPipe.sidebar-id.end","time":922},{"name":"bigPipe.activity-panel-pipe-id.start","time":922.1000000238419},{"name":"bigPipe.activity-panel-pipe-id.end","time":924.9000000357628},{"name":"activityTabFullyLoaded","time":1008.1000000238419}],"measures":[],"correlationId":"45a490fd597d52","effectiveType":"4g","downlink":9.3,"rtt":0,"serverDuration":134,"dbReadsTimeInMs":23,"dbConnsTimeInMs":33,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
MDEV-28699 Shrink temporary tablespaces without restart
