Some metrics are not reporting for the MySQL sensor

Problem:

You are missing some metrics like Latency, Wait Events in the Instana dashboard for MySQL.

Solution:

This problem can occur if there is an issue with the performance_schema installation on the node. You can easily verify this problem by looking up for the below permission denied errors in the agent logs:

2018-10-22T12:24:01.389-03:00 | ERROR | instana-scheduler-thread-2 | Mysql | com.instana.sensor-mysql - 1.1.55 | Error during sense in MySQL sensor
java.sql.SQLException: (conn=55691) Can't find file: './performance_schema/events_waits_summary_global_by_event_name.frm' (errno: 13 - Permission denied)

You can resolve this issue by performing a re-setup of the schema. If the problem still persists then please contact Support.