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

Details

    • 1
    • Platform Sprint 28
    • Yes
    • 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

            Unassigned Unassigned
            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