Type:
Task
Priority:
Major
Resolution:
Fixed
We haven't seen any noticeable speed improvements from building the server with jemalloc. And we did have user complains about inability to use other memory allocators with MariaDB. But TokuDB (and, possibly, RockDB) need jemalloc for a good performance.
A solution could be:
do not build with jemalloc
add malloc-liib=jemalloc to tokudb.cnf and manually add a jemalloc dependency to TokuDB packages
something similar should be done for systemd too
as TokuDB will now introduce an additional dependency that the server itself does not need, it will go into a separate rpm/deb package
This way
the server will not be built with jemalloc, won't require or run with it
when a TokuDB package is installed, it will automatically bring in jemalloc as a dependency and will make the server use it — just as before
the user can always override it and use another memory allocator, if desired
relates to
MDEV-18012
Supplied jemalloc results in immediate MariaDB Segfault on aarch64
Closed
{"report":{"fcp":1246.6999998092651,"ttfb":332.8999996185303,"pageVisibility":"visible","entityId":58501,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"da67b6a0-5fb7-4cf5-bf9b-7c2d71f9b7e5","navigationType":0,"readyForUser":1344.2999997138977,"redirectCount":0,"resourceLoadedEnd":877.6999998092651,"resourceLoadedStart":342.5,"resourceTiming":[{"duration":58.299999713897705,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":342.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":342.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":400.7999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":58.40000009536743,"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":342.7999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":342.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":401.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":365.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":343,"connectEnd":343,"connectStart":343,"domainLookupEnd":343,"domainLookupStart":343,"fetchStart":343,"redirectEnd":0,"redirectStart":0,"requestStart":417.2999997138977,"responseEnd":708.0999999046326,"responseStart":444.69999980926514,"secureConnectionStart":343},{"duration":506.80000019073486,"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":343.19999980926514,"connectEnd":401.3999996185303,"connectStart":401.3999996185303,"domainLookupEnd":401.3999996185303,"domainLookupStart":401.3999996185303,"fetchStart":343.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":411,"responseEnd":850,"responseStart":423.7999997138977,"secureConnectionStart":401.3999996185303},{"duration":92.7000002861023,"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":343.3999996185303,"connectEnd":343.3999996185303,"connectStart":343.3999996185303,"domainLookupEnd":343.3999996185303,"domainLookupStart":343.3999996185303,"fetchStart":343.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":417.5,"responseEnd":436.09999990463257,"responseStart":434.3999996185303,"secureConnectionStart":343.3999996185303},{"duration":97.5,"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":343.69999980926514,"connectEnd":343.69999980926514,"connectStart":343.69999980926514,"domainLookupEnd":343.69999980926514,"domainLookupStart":343.69999980926514,"fetchStart":343.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":417.69999980926514,"responseEnd":441.19999980926514,"responseStart":437.09999990463257,"secureConnectionStart":343.69999980926514},{"duration":95.69999980926514,"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":344,"connectEnd":344,"connectStart":344,"domainLookupEnd":344,"domainLookupStart":344,"fetchStart":344,"redirectEnd":0,"redirectStart":0,"requestStart":417.69999980926514,"responseEnd":439.69999980926514,"responseStart":436.3999996185303,"secureConnectionStart":344},{"duration":58.30000019073486,"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":344.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":344.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":402.5,"responseStart":0,"secureConnectionStart":0},{"duration":102.7000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":344.3999996185303,"connectEnd":344.3999996185303,"connectStart":344.3999996185303,"domainLookupEnd":344.3999996185303,"domainLookupStart":344.3999996185303,"fetchStart":344.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":418.09999990463257,"responseEnd":447.09999990463257,"responseStart":443.3999996185303,"secureConnectionStart":344.3999996185303},{"duration":59.09999990463257,"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":344.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":344.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":403.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":101.30000019073486,"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":344.69999980926514,"connectEnd":344.69999980926514,"connectStart":344.69999980926514,"domainLookupEnd":344.69999980926514,"domainLookupStart":344.69999980926514,"fetchStart":344.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":418.3999996185303,"responseEnd":446,"responseStart":438.19999980926514,"secureConnectionStart":344.69999980926514},{"duration":531.6999998092651,"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":345.59999990463257,"connectEnd":345.59999990463257,"connectStart":345.59999990463257,"domainLookupEnd":345.59999990463257,"domainLookupStart":345.59999990463257,"fetchStart":345.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":605.1999998092651,"responseEnd":877.2999997138977,"responseStart":871.3999996185303,"secureConnectionStart":345.59999990463257},{"duration":528.6999998092651,"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":349,"connectEnd":349,"connectStart":349,"domainLookupEnd":349,"domainLookupStart":349,"fetchStart":349,"redirectEnd":0,"redirectStart":0,"requestStart":731.8999996185303,"responseEnd":877.6999998092651,"responseStart":872.7999997138977,"secureConnectionStart":349},{"duration":136.80000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":848.7999997138977,"connectEnd":848.7999997138977,"connectStart":848.7999997138977,"domainLookupEnd":848.7999997138977,"domainLookupStart":848.7999997138977,"fetchStart":848.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":953.3999996185303,"responseEnd":985.5999999046326,"responseStart":984.7999997138977,"secureConnectionStart":848.7999997138977}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":103,"responseStart":333,"responseEnd":348,"domLoading":337,"domInteractive":1442,"domContentLoadedEventStart":1442,"domContentLoadedEventEnd":1489,"domComplete":2167,"loadEventStart":2167,"loadEventEnd":2168,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1415.3999996185303},{"name":"bigPipe.sidebar-id.end","time":1418.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1418.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":1419.8999996185303},{"name":"activityTabFullyLoaded","time":1509.5999999046326}],"measures":[],"correlationId":"122e1692fe4073","effectiveType":"4g","downlink":9.7,"rtt":0,"serverDuration":156,"dbReadsTimeInMs":11,"dbConnsTimeInMs":20,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Done: TokuDB is in a separate rpm package (in deb it already was). Server isn't linked with jemalloc.
But TokuDB is still linked with jemalloc, I didn't use malloc-liib=jemalloc approach, because it doesn't work very well with systemd.