Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-37635

push statistics instead of pull

    XMLWordPrintable

Details

    Description

      When monitoring MariaDB all tools are using queries like
      SHOW GLOBAL STATUS
      SHOW VARIABLES
      SHOW SLAVE STATUS
      SHOW PROCESSLIST | SELECT * from information.processlist;

      These queries are sent very often (once a minute in some cases) to the server and uses notable resources to parse and provide the result.

      The idea is that instead of sending queries instead request which variables/status variables are of interested, if processlist should be provided and how often to send result. One can also ask to get results incremental (like mariadb-ladmin)
      The server will then send the results to the client contentiously at the requested interval.

      What can also be done is that if the server notices increased resource usage, it starts for a time send things more often. If there is less resource issue, the server could change this less often.

      Attachments

        Issue Links

          Activity

            People

              ralf.gebhardt Ralf Gebhardt
              monty Michael Widenius
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.