Type:
Bug
Resolution:
Fixed
Affects Version/s:
None
Fix Version/s:
None
Component/s:
None
I tested MariaDB 5.5.23 with sysbench.
And that time, Aborted_clients metric value is not much grew up.
But, After I applied MariaDB to production database,
Aborted_clients is growing up ever even though normal close of client side.
So, I tested same code with MySQL 5.5.23 community version. But it's okay.
And, MariaDB(with ThreadPool)'s memory usage is really stable under 2GB(Buffer pool is not including)
when I test with sysbench.
But in real service (java application), memory usage is growing up over 6~7GB(without BufferPool).
I'm not sure Aborted_clients metric is related with this memory usage.
Could you check this out ?
Thanks.
after test status----------------------------------------------------------------------------------
root@localhost:(none) 10:22:10>show global status like 'Aborted_clients';
---------------- ------+
---------------- ------+
---------------- ------+
mysql> show global status like 'Aborted_clients';
---------------- ------+
---------------- ------+
---------------- ------+
test code --------------------------------------------------------------------------------------------
public class AbortedClientsTester {
public static void main(String[] args) throws Exception {
Connection[] conns = new Connection[100] ;
for(int idx=0; idx<100; idx++)
{
conns[idx] = getConnection();
}
Thread.sleep(1000*10);
for(int idx=0; idx<100; idx++)
{
conns[idx].close();
}
}
protected static Connection getConnection() throws Exception
{
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://127.0.0.1:3306/sysbench";
String uid = "sysbench";
String pwd = "sysbench";
Class.forName(driver).newInstance();
Connection conn = DriverManager.getConnection(url, uid, pwd);
return conn;
}
}
Transition
Time In Source Status
Execution Times
Closed
Reopened
155d 9h 22m
1
Reopened
Closed
1h 28m
1
{"report":{"fcp":1334.300000011921,"ttfb":213.69999998807907,"pageVisibility":"visible","entityId":21291,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"af5016f8-6ce1-4343-bb18-f47c4943bcd2","navigationType":0,"readyForUser":1401.699999988079,"redirectCount":0,"resourceLoadedEnd":1585.800000011921,"resourceLoadedStart":218.5999999642372,"resourceTiming":[{"duration":665.1000000238419,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":218.5999999642372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":218.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":883.6999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":665.1000000238419,"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":218.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":218.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":884,"responseStart":0,"secureConnectionStart":0},{"duration":674.0999999642372,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":219,"connectEnd":219,"connectStart":219,"domainLookupEnd":219,"domainLookupStart":219,"fetchStart":219,"redirectEnd":0,"redirectStart":0,"requestStart":219,"responseEnd":893.0999999642372,"responseStart":893.0999999642372,"secureConnectionStart":219},{"duration":708.8999999761581,"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":219.19999998807907,"connectEnd":219.19999998807907,"connectStart":219.19999998807907,"domainLookupEnd":219.19999998807907,"domainLookupStart":219.19999998807907,"fetchStart":219.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":219.19999998807907,"responseEnd":928.0999999642372,"responseStart":928.0999999642372,"secureConnectionStart":219.19999998807907},{"duration":712.3999999761581,"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":219.30000001192093,"connectEnd":219.30000001192093,"connectStart":219.30000001192093,"domainLookupEnd":219.30000001192093,"domainLookupStart":219.30000001192093,"fetchStart":219.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":219.30000001192093,"responseEnd":931.6999999880791,"responseStart":931.6999999880791,"secureConnectionStart":219.30000001192093},{"duration":712.8000000119209,"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":219.5,"connectEnd":219.5,"connectStart":219.5,"domainLookupEnd":219.5,"domainLookupStart":219.5,"fetchStart":219.5,"redirectEnd":0,"redirectStart":0,"requestStart":219.5,"responseEnd":932.3000000119209,"responseStart":932.3000000119209,"secureConnectionStart":219.5},{"duration":713.1000000238419,"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":219.5999999642372,"connectEnd":219.5999999642372,"connectStart":219.5999999642372,"domainLookupEnd":219.5999999642372,"domainLookupStart":219.5999999642372,"fetchStart":219.5999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":219.5999999642372,"responseEnd":932.6999999880791,"responseStart":932.6999999880791,"secureConnectionStart":219.5999999642372},{"duration":812.6000000238419,"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":219.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":219.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1032.5,"responseStart":0,"secureConnectionStart":0},{"duration":713.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":220.0999999642372,"connectEnd":220.0999999642372,"connectStart":220.0999999642372,"domainLookupEnd":220.0999999642372,"domainLookupStart":220.0999999642372,"fetchStart":220.0999999642372,"redirectEnd":0,"redirectStart":0,"requestStart":220.0999999642372,"responseEnd":933.3000000119209,"responseStart":933.3000000119209,"secureConnectionStart":220.0999999642372},{"duration":812.5,"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":220.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":220.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1032.699999988079,"responseStart":0,"secureConnectionStart":0},{"duration":713.4000000357628,"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":220.39999997615814,"connectEnd":220.39999997615814,"connectStart":220.39999997615814,"domainLookupEnd":220.39999997615814,"domainLookupStart":220.39999997615814,"fetchStart":220.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":220.39999997615814,"responseEnd":933.8000000119209,"responseStart":933.8000000119209,"secureConnectionStart":220.39999997615814},{"duration":1333.3999999761581,"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":225.69999998807907,"connectEnd":225.69999998807907,"connectStart":225.69999998807907,"domainLookupEnd":225.69999998807907,"domainLookupStart":225.69999998807907,"fetchStart":225.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":225.69999998807907,"responseEnd":1559.0999999642372,"responseStart":1559.0999999642372,"secureConnectionStart":225.69999998807907},{"duration":1359.6000000238419,"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":226.19999998807907,"connectEnd":226.19999998807907,"connectStart":226.19999998807907,"domainLookupEnd":226.19999998807907,"domainLookupStart":226.19999998807907,"fetchStart":226.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":226.19999998807907,"responseEnd":1585.800000011921,"responseStart":1585.800000011921,"secureConnectionStart":226.19999998807907},{"duration":263.5999999642372,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1043.5,"connectEnd":1043.5,"connectStart":1043.5,"domainLookupEnd":1043.5,"domainLookupStart":1043.5,"fetchStart":1043.5,"redirectEnd":0,"redirectStart":0,"requestStart":1043.5,"responseEnd":1307.0999999642372,"responseStart":1307.0999999642372,"secureConnectionStart":1043.5}],"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":1,"connectEnd":1,"requestStart":20,"responseStart":214,"responseEnd":226,"domLoading":217,"domInteractive":1606,"domContentLoadedEventStart":1606,"domContentLoadedEventEnd":1645,"domComplete":2213,"loadEventStart":2213,"loadEventEnd":2213,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1587.699999988079},{"name":"bigPipe.sidebar-id.end","time":1588.5999999642372},{"name":"bigPipe.activity-panel-pipe-id.start","time":1588.699999988079},{"name":"bigPipe.activity-panel-pipe-id.end","time":1589.699999988079},{"name":"activityTabFullyLoaded","time":1656.300000011921}],"measures":[],"correlationId":"be1748a744d1b1","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":124,"dbReadsTimeInMs":18,"dbConnsTimeInMs":29,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}