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

Not possible to modifying list of collected metrics

    XMLWordPrintable

    Details

      Description

      User impact: User cannot modify list of collected metrics

      Steps to reproduce:

      1. Specify metric for exporter (node_exporter or mysql_exporter):
         pmm-admin add mysql:metrics  --  --collect.perf_schema.eventswaits=false 
      2. Check logs.

      Actual result:

      time="2018-11-29T11:41:36Z" level=info msg=" --collect.slave_status" source="mysqld_exporter.go:423"
      time="2018-11-29T11:41:36Z" level=info msg=" --collect.info_schema.processlist" source="mysqld_exporter.go:423"
      time="2018-11-29T11:41:36Z" level=info msg=" --collect.perf_schema.tablelocks" source="mysqld_exporter.go:423"
      time="2018-11-29T11:41:36Z" level=info msg=" --collect.perf_schema.eventswaits" source="mysqld_exporter.go:423"
      time="2018-11-29T11:41:36Z" level=info msg=" --collect.perf_schema.file_events" source="mysqld_exporter.go:423"
      time="2018-11-29T11:41:36Z" level=info msg=" --collect.info_schema.query_response_time" source="mysqld_exporter.go:423"
      time="2018-11-29T11:41:36Z" level=info msg=" --collect.info_schema.innodb_cmp" source="mysqld_exporter.go:423"
      time="2018-11-29T11:41:36Z" level=info msg=" --collect.info_schema.innodb_cmpmem" source="mysqld_exporter.go:423"
      time="2018-11-29T11:41:36Z" level=info msg="Enabled Low Resolution scrapers:" source="mysqld_exporter.go:427"
      time="2018-11-29T11:41:36Z" level=info msg=" --collect.global_variables" source="mysqld_exporter.go:429"
      time="2018-11-29T11:41:36Z" level=info msg=" --collect.info_schema.tables" source="mysqld_exporter.go:429"
      time="2018-11-29T11:41:36Z" level=info msg=" --collect.auto_increment.columns" source="mysqld_exporter.go:429"
      time="2018-11-29T11:41:36Z" level=info msg=" --collect.perf_schema.tableiowaits" source="mysqld_exporter.go:429"
      time="2018-11-29T11:41:36Z" level=info msg=" --collect.perf_schema.indexiowaits" source="mysqld_exporter.go:429"
      time="2018-11-29T11:41:36Z" level=info msg=" --collect.binlog_size" source="mysqld_exporter.go:429"
      time="2018-11-29T11:41:36Z" level=info msg=" --collect.info_schema.tablestats" source="mysqld_exporter.go:429"
      time="2018-11-29T11:41:36Z" level=info msg=" --collect.info_schema.userstats" source="mysqld_exporter.go:429"
      time="2018-11-29T11:41:36Z" level=info msg=" --collect.custom_query" source="mysqld_exporter.go:429"
      

      Expected result: Eventswaits metric should be disabled

      Additional information: It was found that there are 2 problems: the first one is node_exporter doesn't have option to disable default metrics, and the second is disabling default metrics doesn't work for mysqld_exporter

      Original report:
      Here is the result of my attempts of collecting only one collector diskstats.

      [root@ip-10-178-0-47 ec2-user]# pmm-admin ls
      pmm-admin 1.16.1
      
      PMM Server      | 10.178.0.47 
      Client Name     | pmm-client-hostname
      Client Address  | 10.178.0.47 
      Service Manager | linux-upstart
      
      ------------------- ------------------- ----------- -------- --------------------------------------- --------
      SERVICE TYPE        NAME                LOCAL PORT  RUNNING  DATA SOURCE                             OPTIONS 
      ------------------- ------------------- ----------- -------- --------------------------------------- --------
      linux:metrics       PGSQL-PGSQL_NODE-1  42000       YES      -                                               
      postgresql:metrics  PGSQL-PGSQL_NODE-1  42005       YES      postgresql:***@localhost:5432/postgres          
      [root@ip-10-178-0-47 ec2-user]# 
      [root@ip-10-178-0-47 ec2-user]# 
      
      [root@ip-10-178-0-47 ec2-user]# pmm-admin rm linux:metrics PGSQL-PGSQL_NODE-1
      OK, removed system PGSQL-PGSQL_NODE-1 from monitoring.
      
      [root@ip-10-178-0-47 ec2-user]# pmm-admin add linux:metrics PGSQL-PGSQL_NODE-1 -- -collectors.enabled=diskstats
      OK, now monitoring this system.
      
      [root@ip-10-178-0-47 ec2-user]# pmm-admin ls
      pmm-admin 1.16.1
      
      PMM Server      | 10.178.0.47 
      Client Name     | pmm-client-hostname
      Client Address  | 10.178.0.47 
      Service Manager | linux-upstart
      
      ------------------- ------------------- ----------- -------- --------------------------------------- --------
      SERVICE TYPE        NAME                LOCAL PORT  RUNNING  DATA SOURCE                             OPTIONS 
      ------------------- ------------------- ----------- -------- --------------------------------------- --------
      linux:metrics       PGSQL-PGSQL_NODE-1  42000       YES      -                                               
      postgresql:metrics  PGSQL-PGSQL_NODE-1  42005       YES      postgresql:***@localhost:5432/postgres
                
      [root@ip-10-178-0-47 ec2-user]# cat /var/log/pmm-linux-metrics-42000.log 
      time="2018-11-13T13:23:31Z" level=info msg="Starting node_exporter (version=, branch=, revision=)" source="node_exporter.go:142"
      time="2018-11-13T13:23:31Z" level=info msg="Build context (go=go1.10.1, user=, date=)" source="node_exporter.go:143"
      time="2018-11-13T13:23:31Z" level=info msg="Enabled collectors:" source="node_exporter.go:162"
      time="2018-11-13T13:23:31Z" level=info msg=" - filesystem" source="node_exporter.go:164"
      time="2018-11-13T13:23:31Z" level=info msg=" - loadavg" source="node_exporter.go:164"
      time="2018-11-13T13:23:31Z" level=info msg=" - netdev" source="node_exporter.go:164"
      time="2018-11-13T13:23:31Z" level=info msg=" - netstat" source="node_exporter.go:164"
      time="2018-11-13T13:23:31Z" level=info msg=" - stat" source="node_exporter.go:164"
      time="2018-11-13T13:23:31Z" level=info msg=" - time" source="node_exporter.go:164"
      time="2018-11-13T13:23:31Z" level=info msg=" - textfile" source="node_exporter.go:164"
      time="2018-11-13T13:23:31Z" level=info msg=" - diskstats" source="node_exporter.go:164"
      time="2018-11-13T13:23:31Z" level=info msg=" - meminfo" source="node_exporter.go:164"
      time="2018-11-13T13:23:31Z" level=info msg=" - uname" source="node_exporter.go:164"
      time="2018-11-13T13:23:31Z" level=info msg=" - vmstat" source="node_exporter.go:164"
      time="2018-11-13T13:23:31Z" level=info msg=" - meminfo_numa" source="node_exporter.go:164"
      time="2018-11-13T13:23:31Z" level=info msg=" - filefd" source="node_exporter.go:164"
      time="2018-11-13T13:23:31Z" level=info msg="Starting HTTPS server for https://10.178.0.47:42000/metrics ..." source="server.go:106"
      [root@ip-10-178-0-47 ec2-user]#
      

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  andrii.skomorokhov Andrii Skomorokhov
                  Reporter:
                  vadim.yalovets Vadim Yalovets
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  8 Start watching this issue

                  Dates

                  • Created:
                    Updated:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 1 day, 7 hours, 30 minutes
                    1d 7h 30m