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

MaxScale can add processlist function ?

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: 1.4.3
    • Fix Version/s: N/A
    • Component/s: maxadmin
    • Labels:
      None
    • Environment:
      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

              Assignee:
              Unassigned Unassigned
              Reporter:
              sysdljr sysdljr
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration