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

Fix global status metric names in mysqld_exporter

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.17.1
    • Component/s: MySQLd_Exporter
    • Labels:

      Description

      User impact: User doesn't see MySQL metrics
      Steps to reproduce:

      1. Install MySQL 8.0 and install "validate password" component
      2. Create user for PMM
      3. Add MySQL to PMM

      Actual result:
      pmm-admin check-network returns that mysql:metrics service is DOWN and there are errors in prometheus.log:

      [root@ff4b8f057886 opt]# tail -50 /var/log/prometheus.log 
      level=warn ts=2019-01-29T09:08:03.050992552Z caller=scrape.go:713 component="scrape manager" scrape_pool=mysql-hr target=https://10.10.11.53:42002/metrics-hr msg="append failed" err="no token found"

      Expected result: All services are running

      Original report:
      For Mysql 8.012  with  https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html#sysvar_validate_password.dictionary_file 

      Mysqld_exporter reports metrics with "." inside  name and this is invalid for Prometheus so it skips  the metrics and writes a message to the logs  

       

      based on : 

      https://github.com/prometheus/mysqld_exporter/pull/337 

      and 

      https://github.com/prometheus/mysqld_exporter/issues/325#issuecomment-426798030?

      and 

      https://www.percona.com/forums/questions-discussions/percona-monitoring-and-management/53180-pmm-mysql-8-0-11-instances-not-showing-graphs/page2

       

      TODO: port changes from upstream to temporary  fix the problem before we\ll update exporter 

       

       

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                roma.novikov Roma Novikov
                Reporter:
                roma.novikov Roma Novikov
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

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