Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
2.2.0
-
Yes
-
Yes
-
No
-
No
-
[obsolete] C/S Core
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:
- Setup PMM to monitor PS8.
- login as admin
- click on 'Insight' on the main breadcrumb
- select 'Advanced Data Exploration'
- in filters select : mysql_info_schema_innodb_tablespace_allocated_size_bytes metric
- 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"}