Type:
Task
Priority:
Critical
Resolution:
Fixed
This task will allow to have packed keys and packed values of non-sorted fields in the sort buffer.
It will incorporate the code of wl 1509 from mysql-5.7 that implemented packed values of non-sorted fields in the sort buffer.
Packed keys in sort buffer will help greatly to resolve the problem of
mdev-6529.
{"report":{"fcp":1122.5,"ttfb":422.1000003814697,"pageVisibility":"visible","entityId":46405,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"d072cbd8-b24c-472e-b525-0afe3c98df28","navigationType":0,"readyForUser":1184.5,"redirectCount":0,"resourceLoadedEnd":1348.8000011444092,"resourceLoadedStart":427.1000003814697,"resourceTiming":[{"duration":278.3000011444092,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":427.1000003814697,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":427.1000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":705.4000015258789,"responseStart":0,"secureConnectionStart":0},{"duration":278.1999988555908,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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":427.3000011444092,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":427.3000011444092,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":705.5,"responseStart":0,"secureConnectionStart":0},{"duration":289,"initiatorType":"script","name":"https://jira.mariadb.org/s/c54b129276d75dc2a3460e1d78f37913-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":427.4000015258789,"connectEnd":427.4000015258789,"connectStart":427.4000015258789,"domainLookupEnd":427.4000015258789,"domainLookupStart":427.4000015258789,"fetchStart":427.4000015258789,"redirectEnd":0,"redirectStart":0,"requestStart":427.4000015258789,"responseEnd":716.4000015258789,"responseStart":716.4000015258789,"secureConnectionStart":427.4000015258789},{"duration":362,"initiatorType":"script","name":"https://jira.mariadb.org/s/f867843cd2fdb209d4d1d4f760f86346-CDN/lu2bsh/820016/12ta74/eb142f92e4bd16bd1ef8b08c1b9d5d56/_/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":427.5,"connectEnd":427.5,"connectStart":427.5,"domainLookupEnd":427.5,"domainLookupStart":427.5,"fetchStart":427.5,"redirectEnd":0,"redirectStart":0,"requestStart":427.5,"responseEnd":789.5,"responseStart":789.5,"secureConnectionStart":427.5},{"duration":365,"initiatorType":"script","name":"https://jira.mariadb.org/s/ffdb17665775c5b4d6f097f3974ee359-CDN/lu2bsh/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":427.70000076293945,"connectEnd":427.70000076293945,"connectStart":427.70000076293945,"domainLookupEnd":427.70000076293945,"domainLookupStart":427.70000076293945,"fetchStart":427.70000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":427.70000076293945,"responseEnd":792.7000007629395,"responseStart":792.7000007629395,"secureConnectionStart":427.70000076293945},{"duration":365.3999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":427.8000011444092,"connectEnd":427.8000011444092,"connectStart":427.8000011444092,"domainLookupEnd":427.8000011444092,"domainLookupStart":427.8000011444092,"fetchStart":427.8000011444092,"redirectEnd":0,"redirectStart":0,"requestStart":427.8000011444092,"responseEnd":793.2000007629395,"responseStart":793.2000007629395,"secureConnectionStart":427.8000011444092},{"duration":365.5999984741211,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":427.9000015258789,"connectEnd":427.9000015258789,"connectStart":427.9000015258789,"domainLookupEnd":427.9000015258789,"domainLookupStart":427.9000015258789,"fetchStart":427.9000015258789,"redirectEnd":0,"redirectStart":0,"requestStart":427.9000015258789,"responseEnd":793.5,"responseStart":793.5,"secureConnectionStart":427.9000015258789},{"duration":366,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bsh/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":428,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":428,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":794,"responseStart":0,"secureConnectionStart":0},{"duration":366,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":428,"connectEnd":428,"connectStart":428,"domainLookupEnd":428,"domainLookupStart":428,"fetchStart":428,"redirectEnd":0,"redirectStart":0,"requestStart":428,"responseEnd":794,"responseStart":794,"secureConnectionStart":428},{"duration":366.20000076293945,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bsh/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":428.20000076293945,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":428.20000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":794.4000015258789,"responseStart":0,"secureConnectionStart":0},{"duration":366.1999988555908,"initiatorType":"script","name":"https://jira.mariadb.org/s/81b5d7c27af3ebc078cc4a36383678ba-CDN/lu2bsh/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":428.3000011444092,"connectEnd":428.3000011444092,"connectStart":428.3000011444092,"domainLookupEnd":428.3000011444092,"domainLookupStart":428.3000011444092,"fetchStart":428.3000011444092,"redirectEnd":0,"redirectStart":0,"requestStart":428.3000011444092,"responseEnd":794.5,"responseStart":794.5,"secureConnectionStart":428.3000011444092},{"duration":715.1000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":434.5,"connectEnd":434.5,"connectStart":434.5,"domainLookupEnd":434.5,"domainLookupStart":434.5,"fetchStart":434.5,"redirectEnd":0,"redirectStart":0,"requestStart":434.5,"responseEnd":1149.6000003814697,"responseStart":1149.6000003814697,"secureConnectionStart":434.5},{"duration":914.2000007629395,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bsh/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":434.6000003814697,"connectEnd":434.6000003814697,"connectStart":434.6000003814697,"domainLookupEnd":434.6000003814697,"domainLookupStart":434.6000003814697,"fetchStart":434.6000003814697,"redirectEnd":0,"redirectStart":0,"requestStart":434.6000003814697,"responseEnd":1348.8000011444092,"responseStart":1348.8000011444092,"secureConnectionStart":434.6000003814697},{"duration":420.1000003814697,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":928,"connectEnd":928,"connectStart":928,"domainLookupEnd":928,"domainLookupStart":928,"fetchStart":928,"redirectEnd":0,"redirectStart":0,"requestStart":928,"responseEnd":1348.1000003814697,"responseStart":1348.1000003814697,"secureConnectionStart":928},{"duration":253.5,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1101.900001525879,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1101.900001525879,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1355.400001525879,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":201,"responseStart":422,"responseEnd":429,"domLoading":425,"domInteractive":1375,"domContentLoadedEventStart":1375,"domContentLoadedEventEnd":1410,"domComplete":2224,"loadEventStart":2224,"loadEventEnd":2225,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1358.7000007629395},{"name":"bigPipe.sidebar-id.end","time":1359.400001525879},{"name":"bigPipe.activity-panel-pipe-id.start","time":1359.6000003814697},{"name":"bigPipe.activity-panel-pipe-id.end","time":1361.900001525879},{"name":"activityTabFullyLoaded","time":1452}],"measures":[],"correlationId":"b8a5fa475d26e5","effectiveType":"4g","downlink":9.1,"rtt":0,"serverDuration":167,"dbReadsTimeInMs":16,"dbConnsTimeInMs":23,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}