[MXS-3152] Kill session via MaxCtrl Created: 2020-09-03 Updated: 2022-04-21 Resolved: 2022-04-19 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | maxadmin, maxctrl, REST-API |
| Affects Version/s: | 2.4.7 |
| Fix Version/s: | 22.08.0 |
| Type: | New Feature | Priority: | Major |
| Reporter: | febriyant | Assignee: | markus makela |
| Resolution: | Fixed | Votes: | 1 |
| Labels: | maxscale, processlist, sessions | ||
| Environment: |
Centos 7 |
||
| Issue Links: |
|
||||||||
| Description |
|
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
my question is how to kill sessions from maxadmin list sessions ? because some day I got issue like too much idle connections on maxscale. |
| Comments |
| Comment by markus makela [ 2020-09-03 ] |
|
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. |
| Comment by markus makela [ 2022-04-08 ] |
|
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. |