Details

    • Epic Name:
      MySQL Table Statistics - disable automatically
    • 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: