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

PMM 2 - pmm-admin allow disable collection of metrics for mysqld_exporter

    XMLWordPrintable

    Details

      Description

      Currently there is no way to disable the collection of a specific metrics for the mysqld_exporter.

      In my case when client logging is enabled, the log get's spammed by entries like:

      2019-11-14 15:05:46 root[root] @ localhost [127.0.0.1] ERROR 1286: Unknown storage engine 'TOKUDB' : SHOW ENGINE TOKUDB STATUS
      2019-11-14 15:06:46 root[root] @ localhost [127.0.0.1] ERROR 1054: Unknown column 'FILE_FORMAT' in 'field list' : SELECT
       SPACE,
       NAME,
       ifnull(FILE_FORMAT, 'NONE') as FILE_FORMAT,
       ifnull(ROW_FORMAT, 'NONE') as ROW_FORMAT,
       ifnull(SPACE_TYPE, 'NONE') as SPACE_TYPE,
       FILE_SIZE,
       ALLOCATED_SIZE
       FROM information_schema.innodb_sys_tablespaces
      2019-11-14 15:06:46 root[root] @ localhost [127.0.0.1] ERROR 1146: Table 'heartbeat.heartbeat' doesn't exist : SELECT UNIX_TIMESTAMP(ts), UNIX_TIMESTAMP(NOW(6)), server_id from `heartbeat`.`heartbeat`
      2019-11-14 15:06:46 root[root] @ localhost [127.0.0.1] ERROR 1286: Unknown storage engine 'TOKUDB' : SHOW ENGINE TOKUDB STATUS
      
      

      It would be great to have the possibility to disable some metrics via pmm-admin command.

       

      Regards,

      Patrick

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned
                Reporter:
                kummutat Patrick kummutat
                Votes:
                12 Vote for this issue
                Watchers:
                16 Start watching this issue

                  Dates

                  Created:
                  Updated: