Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-774

MaxScale can add processlist function ?

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 1.4.3
    • N/A
    • maxadmin
    • None
    • CentOS 6.7, MaxScale 1.4.3, MariaDB 10.1.14

    Description

      HI, all
      recently , we are testing maxscale 1.4.3 + mariadb galera cluster, maxscale's read write split function and privilege control is very good.
      Make a small suggestion:
      in mariadb show processlist , host column show all is Maxcale server's IP, if found some slow statement, it can's confirm the statement come from which ip.
      present, we use method is install mysql sniff tools in MaxScale sever, capture the statement for the specified port, but it is more trouble.
      In maxadmin, show sessions only can show Client Address, it can't show process id or process detail info, if can add mysql's id and info column of show processlist, It is very easy to analyze the source of the problem.
      thanks.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              sysdljr sysdljr
              Votes:
              0 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.