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

Innodb Tablespace data is not collected for Percona Server 8

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 2.2.0
    • Fix Version/s: None
    • Component/s: MySQLd_Exporter
    • Labels:
    • Story Points:
      3
    • Needs Review:
      Yes
    • Needs QA:
      Yes
    • Needs Packaging:
      No
    • Needs Doc:
      No

      Description

       

      User Impact:

      User can not see any data by mysql_info_schema_innodb_tablespace_allocated_size_bytes mtric during Percona Server 8 monitoring

      Steps to Reproduce:

      1. Setup PMM to monitor PS8.
      2. login as admin
      3. click on 'Insight' on the main breadcrumb
      4. select 'Advanced Data Exploration'
      5. in filters select : mysql_info_schema_innodb_tablespace_allocated_size_bytes  metric
      6. add service_name = ps_8.0_0.0.0.0_1 to filter

      Actual Result:
      No data displayed. See attached screenshot. 

      Expected Result:
      data should be displayed.

      Additional information:

      Filter with service_name = ps_5.7_0.0.0.0_1 -  shows data

       

      Original report:

      Original description from Peter Zaitsev :

      I have 2  Percona Server provisioned with PMM, for PS5.7 I see the innodb_tablespace related information is reported (example below)  however PS8 reports no metrics through it also has this table.

       

      mysql_info_schema_innodb_tablespace_allocated_size_bytes{agent_id="/agent_id/df9cfd20-8c2c-46ff-a53b-6e6f308fddab",agent_type="mysqld_exporter",az="myaz",environment="versions",instance="/agent_id/df9cfd20-8c2c-46ff-a53b-6e6f308fddab",job="mysqld_exporter_agent_id_df9cfd20-8c2c-46ff-a53b-6e6f308fddab_lr-1m0s",machine_id="/machine_id/612892249edc4cf7b40cdfd1534feded",node_id="/node_id/5389b202-d9ad-4857-978b-de49cfc811e2",node_model="linode1024",node_name="ps57-2-n-1-tpcc-tb1-s10-th1x",node_type="generic",region="datacenter4",service_id="/service_id/dd4ea72b-9431-4dde-a72e-5971697acd9e",service_name="ps57-2-n-1-tpcc-tb1-s10-th1x-mysql",service_type="mysql",tablespace_name="mysql/engine_cost"}

       

       

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              pz Peter Zaitsev
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: