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

MySQL Table Statistics - disable automatically

    XMLWordPrintable

    Details

    • Epic Name:
      MySQL Table Statistics - disable automatically
    • Story Points:
      0
    • Sprint:
      Platform Sprint 2, Platform Sprint 3
    • Needs QA:
      Yes
    • Needs Doc:
      Yes

      Description

      MySQL with too many tables (as counted by SELECT COUNT( * ) FROM information_schema.tables) can lead to Prometheus overload due to too many time series in it. It can also lead to too many queries from mysqld_exporter and extra load on MySQL.

      If there are too many tables, disable those mysqld_exporter collectors:

      • --collect.auto_increment.columns
      • --collect.info_schema.tables
      • --collect.info_schema.tablestats
      • --collect.perf_schema.indexiowaits
      • --collect.perf_schema.tableiowaits
      • --collect.perf_schema.tablelocks

      In this Epic, we do that automatically if there are more than 1000 tables when mysqld_exporter Agent is added. Configuration, UI, and CLI changes were extracted into PMM-4535.

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned
                Reporter:
                alexey.palazhchenko Alexey Palazhchenko
                Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved: