Details

    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

      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.

      Attachments

        Issue Links

          Activity

            markus makela 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.

            markus makela 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.
            markus makela 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.

            markus makela 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 markus makela
              febridev febriyant
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start 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.