Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-734

Apply function max_over_time() to History_list_length, Threads_running metrics

    Details

      Description

      I've seen that many PromQL queries we are using are displaying wrong information.

      Example is looking at threads_running, the query at the moment is:

      mysql_global_status_threads_running{instance="$host"}
      

      but this should for this specific metric become:

      max_over_time(mysql_global_status_threads_running{instance="$host"}[$interval])
      

      You can see the graph of the same host but 2 different metrics as attachment

        Smart Checklist

          Attachments

          1. Screen Shot 2017-03-30 at 18.52.00.png
            152 kB
            Kenny Gryp
          2. Screen Shot 2017-03-30 at 18.52.21.png
            122 kB
            Kenny Gryp
          3. Screen Shot 2017-03-30 at 22.55.32.png
            79 kB
            Kenny Gryp
          4. Screen Shot 2017-03-30 at 22.55.39.png
            104 kB
            Kenny Gryp
          5. Screen Shot 2017-03-30 at 22.56.01.png
            86 kB
            Kenny Gryp

            Issue Links

              Activity

                People

                • Assignee:
                  nailya.kutlubaeva Nailya Kutlubaeva
                  Reporter:
                  gryp Kenny Gryp (Inactive)
                • Votes:
                  1 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: