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

PXC/Galera dashboards: Empty service name with MySQL version < 5.6.40

    XMLWordPrintable

    Details

    • Story Points:
      1
    • Sprint:
      Platform Sprint 28
    • Needs Review:
      Yes
    • Needs QA:
      Yes

      Description

      In all PXC dashboards, the service_name variable is being populated by the following query:

      query_result(mysql_galera_variables_info{wsrep_cluster_name=~"$cluster"} * on(service_name) mysql_global_variables_wsrep_rsu_commit_timeout)
      

      The problem is since the wsrep_rsu_commit_timeout only became available in MySQL 5.6.40, the query returns no results if the clients are running an older version.
      This effectively causes no data to be displayed on the PXC dashboards.

      A potential fix would be to replace that with a variable available in every version, for example:

      query_result(mysql_galera_variables_info{wsrep_cluster_name=~"$cluster"} * on(service_name) mysql_global_variables_wsrep_auto_increment_control)
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            ivan.groenewold Ivan Groenewold
            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 - 5 hours, 15 minutes
                5h 15m

                  Smart Checklist