Currently, in order to kill an idle connection an administrator has to first run maxctrl list sessions and then run the SQL KILL command with the session ID. This whole process would be much simpler if the second step could be done via MaxCtrl.
Original description:
I can got list of session with this command from maxadmin
maxadmin list sessions
my question is how to kill sessions from maxadmin list sessions ? because some day I got issue like too much idle connections on maxscale.
You can kill sessions with the SQL KILL command through MaxScale. There's currently no way to kill individual sessions via MaxCtrl but it does make sense to be able to do that. If it's OK with you, I'll convert this into a feature request as it requires new functionality.
markus makela
added a comment - You can kill sessions with the SQL KILL command through MaxScale. There's currently no way to kill individual sessions via MaxCtrl but it does make sense to be able to do that. If it's OK with you, I'll convert this into a feature request as it requires new functionality.
Added the maxctrl destroy session command. This can be used to kill long-running sessions from the MaxScale host without having to install a command line connector or use database credentials.
markus makela
added a comment - Added the maxctrl destroy session command. This can be used to kill long-running sessions from the MaxScale host without having to install a command line connector or use database credentials.
People
markus makela
febriyant
Votes:
1Vote for this issue
Watchers:
3Start watching this issue
Dates
Created:
Updated:
Resolved:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":884.5,"ttfb":197.90000009536743,"pageVisibility":"visible","entityId":91403,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"dc85471c-7876-40d1-9bd2-c5756f89d7ce","navigationType":0,"readyForUser":966.5999999046326,"redirectCount":0,"resourceLoadedEnd":599.8000001907349,"resourceLoadedStart":205.5,"resourceTiming":[{"duration":3.9000000953674316,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":205.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":205.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":209.40000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":4.399999618530273,"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":205.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":205.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":210.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":233.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":206,"connectEnd":206,"connectStart":206,"domainLookupEnd":206,"domainLookupStart":206,"fetchStart":206,"redirectEnd":0,"redirectStart":0,"requestStart":213.30000019073486,"responseEnd":439.80000019073486,"responseStart":245.09999990463257,"secureConnectionStart":206},{"duration":393.7000002861023,"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":206.09999990463257,"connectEnd":206.09999990463257,"connectStart":206.09999990463257,"domainLookupEnd":206.09999990463257,"domainLookupStart":206.09999990463257,"fetchStart":206.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":214.09999990463257,"responseEnd":599.8000001907349,"responseStart":273.09999990463257,"secureConnectionStart":206.09999990463257},{"duration":126.5,"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":206.30000019073486,"connectEnd":206.30000019073486,"connectStart":206.30000019073486,"domainLookupEnd":206.30000019073486,"domainLookupStart":206.30000019073486,"fetchStart":206.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":215.69999980926514,"responseEnd":332.80000019073486,"responseStart":332,"secureConnectionStart":206.30000019073486},{"duration":125.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":206.5,"connectEnd":206.5,"connectStart":206.5,"domainLookupEnd":206.5,"domainLookupStart":206.5,"fetchStart":206.5,"redirectEnd":0,"redirectStart":0,"requestStart":217.5,"responseEnd":332,"responseStart":327.5,"secureConnectionStart":206.5},{"duration":144.40000009536743,"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":206.59999990463257,"connectEnd":206.59999990463257,"connectStart":206.59999990463257,"domainLookupEnd":206.59999990463257,"domainLookupStart":206.59999990463257,"fetchStart":206.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":219,"responseEnd":351,"responseStart":350.30000019073486,"secureConnectionStart":206.59999990463257},{"duration":11.300000190734863,"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":206.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":206.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":218,"responseStart":0,"secureConnectionStart":0},{"duration":151.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":206.90000009536743,"connectEnd":206.90000009536743,"connectStart":206.90000009536743,"domainLookupEnd":206.90000009536743,"domainLookupStart":206.90000009536743,"fetchStart":206.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":221.09999990463257,"responseEnd":358.59999990463257,"responseStart":357.90000009536743,"secureConnectionStart":206.90000009536743},{"duration":12.100000381469727,"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":207.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":207.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":219.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":150.39999961853027,"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":207.30000019073486,"connectEnd":207.30000019073486,"connectStart":207.30000019073486,"domainLookupEnd":207.30000019073486,"domainLookupStart":207.30000019073486,"fetchStart":207.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":221.5,"responseEnd":357.69999980926514,"responseStart":356.30000019073486,"secureConnectionStart":207.30000019073486},{"duration":347.30000019073486,"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":217.5,"connectEnd":217.5,"connectStart":217.5,"domainLookupEnd":217.5,"domainLookupStart":217.5,"fetchStart":217.5,"redirectEnd":0,"redirectStart":0,"requestStart":246.59999990463257,"responseEnd":564.8000001907349,"responseStart":555.5,"secureConnectionStart":217.5},{"duration":348.8999996185303,"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":217.80000019073486,"connectEnd":217.80000019073486,"connectStart":217.80000019073486,"domainLookupEnd":217.80000019073486,"domainLookupStart":217.80000019073486,"fetchStart":217.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":252.09999990463257,"responseEnd":566.6999998092651,"responseStart":556.9000000953674,"secureConnectionStart":217.80000019073486},{"duration":236.30000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":568.5,"connectEnd":568.5,"connectStart":568.5,"domainLookupEnd":568.5,"domainLookupStart":568.5,"fetchStart":568.5,"redirectEnd":0,"redirectStart":0,"requestStart":769.5999999046326,"responseEnd":804.8000001907349,"responseStart":804.0999999046326,"secureConnectionStart":568.5},{"duration":229.59999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":839.3000001907349,"connectEnd":839.3000001907349,"connectStart":839.3000001907349,"domainLookupEnd":839.3000001907349,"domainLookupStart":839.3000001907349,"fetchStart":839.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":1036.9000000953674,"responseEnd":1068.9000000953674,"responseStart":1068.1999998092651,"secureConnectionStart":839.3000001907349}],"fetchStart":0,"domainLookupStart":3,"domainLookupEnd":11,"connectStart":11,"connectEnd":33,"secureConnectionStart":20,"requestStart":33,"responseStart":198,"responseEnd":216,"domLoading":202,"domInteractive":1021,"domContentLoadedEventStart":1021,"domContentLoadedEventEnd":1072,"domComplete":1710,"loadEventStart":1710,"loadEventEnd":1711,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":999.3000001907349},{"name":"bigPipe.sidebar-id.end","time":1000.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.start","time":1001},{"name":"bigPipe.activity-panel-pipe-id.end","time":1002.1999998092651},{"name":"activityTabFullyLoaded","time":1121.5999999046326}],"measures":[],"correlationId":"8aceb927fab6e7","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":102,"dbReadsTimeInMs":13,"dbConnsTimeInMs":22,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
You can kill sessions with the SQL KILL command through MaxScale. There's currently no way to kill individual sessions via MaxCtrl but it does make sense to be able to do that. If it's OK with you, I'll convert this into a feature request as it requires new functionality.