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

Track average query duration for services and servers

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 6.2.0
    • Core
    • None
    • MXS-SPRINT-133, MXS-SPRINT-134, MXS-SPRINT-135

    Description

      Currently the average query duration is tracked for servers only when a readwritesplit service uses it and is configured with slave_selection_criteria=ADAPTIVE_ROUTING. In addition, only queries classified as reads are tracked.

      As query latency is a good metric for measuring the overall performance of a cluster, it should be tracked both at the service level as well as on the server level. Initially, the average should take into account all queries regardless of whether they are writes or reads.

      The new statistic should be separate from the existing adaptive_avg_select_time statistic exposed in the servers REST API resource. This will keep the semantics of the existing statistic the same as it was in older releases.

      Attachments

        Activity

          People

            nantti Niclas Antti
            markus makela markus makela
            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.