No data for a remote database in Query analytics

we are running on 2.20.

For a newly added remote monitoring host Mysql 8.0 , query analytics data is not showing up. rest all data is working as expected for the host.

Noticed the relevant QAN MySQL Perfschema Agent is in WAITING status.

performance schema is enabled while adding the system to PMM.
Perf schema is enabled in the remote database.
user has the right permissions.
connectivity is fine as we can get the remaining data for the system.

How do we troubleshoot on why the agent is not started ?

1 Like

Did you ‘Test Connection’ before adding the remote MySQL?

1 Like