Infrastructure Agent MySQL custom metric not reporting

Products

• DX Application Performance Management
• DX APM SaaS

Issue/Introduction

I have created the new custom metric in schema.json as per documentation (see below) but it is not reported in the Metric View:

{  
   "query":"select ( 'ON' = (select SERVICE_STATE FROM performance_schema.replication_connection_status)) as state",
        "metrics":[
            {
               "metricPath":[
                   {
                       "name":"Replica:Slave IO Running"
                   }                    
               ],                                            
               "metricType":"IntCounter",
               "metricValue":"$.resultSet[0].state"
           }
        ],
        "calculatedMetrics":[ ]            
    },

What could be the issue ?

Environment

DX APM

Cause

Incorrect metricType in-use

Resolution

1. Open schema.json

2, Change the value of MetricType from "IntCounter"  to "IntFluctuatingCounter"

3. Save the file and restart the InfastructureAgent

Additional Information

Techdocs DX Agents - Viewing Additional Metrics of MySQL 5.7.XX, MySQL 6.X, and MySQL 7.X