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

Conditionally run MySQL Custom Queries

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: New
    • Priority: Feature Request
    • Resolution: Unresolved
    • Affects Version/s: 1.15.0, 1.16.0, 1.17.0
    • Fix Version/s: None
    • Component/s: PMM Client
    • Labels:
      None

      Description

      I have some relatively expensive queries to run that collect metrics from a lot of tables I have. I have failover replicas for all of my masters that are mostly unused until they are promoted to master. I'd like to only run this metric collection on the slaves, to not increase the load on my masters.

      I think this can be s a general use case, where before running something expensive, a pre-query runs to see if anything has changed. It'd be nice if PMM exposed another field in the yaml called `prequery` or something, expecting a truthy value back, and only run the real query if the prequery returns true.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                derekperkins Derek Perkins
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: