Type:
Priority:
Resolution:
Fixed
Affects Version/s:
None
This comes from analyzing benchmark which does "connect/disconnect", mostly
The output from VTune shows a lot of time spent in GetFileAttributes(), which is Windows'
Top Hotspots
Function Module CPU Time
NtWaitForWorkViaWorkerFactory ntdll.dll 56.896s
GetFileAttributesA KERNELBASE.dll 13.874s <--- This one
WaitForSingleObjectEx KERNELBASE.dll 10.879s
CreateNamedPipeA KERNEL32.DLL 8.437s
[Unknown stack frame(s)] [Unknown] 4.612s
[Others] N/A* 19.807s
Here is the callstack leading to it
CPU Time
1 of 1: 100.0% (13.874s of 13.874s)
KERNELBASE.dll ! GetFileAttributesA - [unknown source file]
server.dll ! my_access + 0xd - my_access.c:39
server.dll ! check_db_dir_existence + 0x67 - sql_db.cc:1935
server.dll ! mysql_change_db + 0x226 - sql_db.cc:1610
server.dll ! acl_authenticate + 0x853 - sql_acl.cc:14380
server.dll ! check_connection + 0x206 - sql_connect.cc:1081
server.dll ! login_connection + 0x40 - sql_connect.cc:1142
server.dll ! thd_prepare_connection + 0x15 - sql_connect.cc:1327
server.dll ! threadpool_add_connection + 0x180 - threadpool_common.cc:261
server.dll ! tp_callback + 0x42 - threadpool_common.cc:186
ntdll.dll ! TppSimplepExecuteCallback + 0x98 - [unknown source file]
ntdll.dll ! TppWorkerThread + 0x689 - [unknown source file]
KERNEL32.DLL ! BaseThreadInitThunk + 0x13 - [unknown source file]
ntdll.dll ! RtlUserThreadStart + 0x20 - [unknown source file]
Given that NtWaitForWorkViaWorkerFactory is not anything we can influence much (that's a threadpool management), this makes my_access() the top-1 hotspot
However we do not need to instantly recheck if directory is still there. If it was there, and there was no "drop database", it remains in place. We can assume, that removing database directory manually outside of the server does not happen (or those who do punish themselves), we can cache the results of this operation, speeding up the connect, and every "USE db"
Transition
Time In Source Status
Execution Times
Open
Closed
5d 18h 21m
1
{"report":{"fcp":667.6999998092651,"ttfb":154.09999990463257,"pageVisibility":"visible","entityId":89288,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"ad8d92d2-9223-4b7a-b858-663a16032718","navigationType":0,"readyForUser":720.1999998092651,"redirectCount":0,"resourceLoadedEnd":263.2999997138977,"resourceLoadedStart":161.59999990463257,"resourceTiming":[{"duration":3.1999998092651367,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":161.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":161.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":164.7999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":3.4000000953674316,"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":161.7999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":161.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":165.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":71.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/b09d0d077992e4331b5f9ec0d3ec448c-CDN/lu2bsh/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":162,"connectEnd":162,"connectStart":162,"domainLookupEnd":162,"domainLookupStart":162,"fetchStart":162,"redirectEnd":0,"redirectStart":0,"requestStart":167.69999980926514,"responseEnd":233.40000009536743,"responseStart":192.40000009536743,"secureConnectionStart":162},{"duration":101.2999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/b47ab3df14096803b180217eb8482517-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":162,"connectEnd":162,"connectStart":162,"domainLookupEnd":162,"domainLookupStart":162,"fetchStart":162,"redirectEnd":0,"redirectStart":0,"requestStart":168.19999980926514,"responseEnd":263.2999997138977,"responseStart":199.7999997138977,"secureConnectionStart":162},{"duration":44.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/6c569cbf8087ab04e40d0bef98627457-CDN/lu2bsh/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":162.09999990463257,"connectEnd":162.09999990463257,"connectStart":162.09999990463257,"domainLookupEnd":162.09999990463257,"domainLookupStart":162.09999990463257,"fetchStart":162.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":169.2999997138977,"responseEnd":206.69999980926514,"responseStart":206.19999980926514,"secureConnectionStart":162.09999990463257},{"duration":50.90000009536743,"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":162.2999997138977,"connectEnd":162.2999997138977,"connectStart":162.2999997138977,"domainLookupEnd":162.2999997138977,"domainLookupStart":162.2999997138977,"fetchStart":162.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":170.19999980926514,"responseEnd":213.19999980926514,"responseStart":212.5,"secureConnectionStart":162.2999997138977},{"duration":53.09999990463257,"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":162.40000009536743,"connectEnd":162.40000009536743,"connectStart":162.40000009536743,"domainLookupEnd":162.40000009536743,"domainLookupStart":162.40000009536743,"fetchStart":162.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":172,"responseEnd":215.5,"responseStart":214.90000009536743,"secureConnectionStart":162.40000009536743},{"duration":9.199999809265137,"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":162.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":162.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":171.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":54.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":162.59999990463257,"connectEnd":162.59999990463257,"connectStart":162.59999990463257,"domainLookupEnd":162.59999990463257,"domainLookupStart":162.59999990463257,"fetchStart":162.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":173.69999980926514,"responseEnd":217.40000009536743,"responseStart":216.7999997138977,"secureConnectionStart":162.59999990463257},{"duration":10.599999904632568,"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":162.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":162.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":173.2999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":58.200000286102295,"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":162.7999997138977,"connectEnd":162.7999997138977,"connectStart":162.7999997138977,"domainLookupEnd":162.7999997138977,"domainLookupStart":162.7999997138977,"fetchStart":162.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":174.69999980926514,"responseEnd":221,"responseStart":220.2999997138977,"secureConnectionStart":162.7999997138977},{"duration":22.09999990463257,"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":171.40000009536743,"connectEnd":177.90000009536743,"connectStart":177.90000009536743,"domainLookupEnd":177.90000009536743,"domainLookupStart":177.90000009536743,"fetchStart":171.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":178,"responseEnd":193.5,"responseStart":190.40000009536743,"secureConnectionStart":177.90000009536743},{"duration":22.59999990463257,"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":171.59999990463257,"connectEnd":171.59999990463257,"connectStart":171.59999990463257,"domainLookupEnd":171.59999990463257,"domainLookupStart":171.59999990463257,"fetchStart":171.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":179.5,"responseEnd":194.19999980926514,"responseStart":191.19999980926514,"secureConnectionStart":171.59999990463257},{"duration":151.59999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":437.69999980926514,"connectEnd":437.69999980926514,"connectStart":437.69999980926514,"domainLookupEnd":437.69999980926514,"domainLookupStart":437.69999980926514,"fetchStart":437.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":554.6999998092651,"responseEnd":589.2999997138977,"responseStart":588.6999998092651,"secureConnectionStart":437.69999980926514},{"duration":70.89999961853027,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":642.4000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":642.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":713.2999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":87.69999980926514,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":657,"connectEnd":657,"connectStart":657,"domainLookupEnd":657,"domainLookupStart":657,"fetchStart":657,"redirectEnd":0,"redirectStart":0,"requestStart":715.9000000953674,"responseEnd":744.6999998092651,"responseStart":743.5999999046326,"secureConnectionStart":657}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":28,"responseStart":155,"responseEnd":171,"domLoading":158,"domInteractive":770,"domContentLoadedEventStart":770,"domContentLoadedEventEnd":810,"domComplete":1207,"loadEventStart":1207,"loadEventEnd":1208,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":754.5},{"name":"bigPipe.sidebar-id.end","time":755.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":755.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":756.0999999046326},{"name":"activityTabFullyLoaded","time":818.9000000953674}],"measures":[],"correlationId":"c119d8632c11d5","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":68,"dbReadsTimeInMs":11,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
