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

Force an alert when detecting too many connections

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 2.6.1
    • Fix Version/s: None
    • Component/s: MySQLd_Exporter
    • Labels:

      Description

      Scenario

      The mysqld_exporter cannot connect to the database due to "Too many connections"

      Issue

      Whilst you can see the issue in the agent logs, you can end up with no data points and this then masks a real issue unless very careful with all alerting rules. The other issue is that with sufficient iterations you can end up with a spattering of data points which also hides the issue.

      Improvement

      Similar to the "up" metric, perhaps we can have a "inaccessible" metric (mysql_inaccessible etc) that receives a data point with a value of 0 when OK and 1 when down. Alternatively, perhaps the existing mysql_up metric could have a zero datapoint generated instead of a new metric.

      This would allow for a single alert rule to check instead of needing to have more complex rules that use absent{} etc

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              ceri.williams Ceri Williams
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: