PMM - Query Analytics

Percona Monitoring and Management (PMM) Database Monitoring and Management
1

Hi

We installed PMM Version 2.43.2 and we can monitor 3 servers where we installed Percona Xtra Cluster, except on dashboard “PMM Query Analytics”, here just appear pmm-server and we can’t add the 3 servers.

Please advice.

Thank you

2

Please provide the exact command you used to add the pmm-agent to each of the 3 servers. Verify that your slow log is enabled, and long-query-time=0, or verify that your performance_schema is enabled with defaults.

3

Thank you for your reply.

We add the pmm-agent on 3 nodes using:
apt-get install pmm2-client

$ pmm-admin status
Agent ID : /agent_id/8d197198-9e7a-470f-b68f-8e2fe86bccc2
Node ID : /node_id/4aeb89e8-172c-4bee-919f-cf463133dd79
Node name: xx

PMM Server:
URL : https://xx.xx.xx.xx:443/
Version: 2.43.2

PMM Client:
Connected : true
Time drift : 413.189µs
Latency : 647.228µs
Connection uptime: 100
pmm-admin version: 2.43.2
pmm-agent version: 2.43.2
Agents:
/agent_id/340e4a71-5cb1-4475-8542-a9b5daec06cf vmagent Running 42000
/agent_id/4f9b0bb1-ab7e-4cbc-b817-b83aeac372c2 mysqld_exporter Running 42002
/agent_id/ce6e216e-f592-4d7c-9677-5a3519ba035c node_exporter Running 42001
/agent_id/f8c2dbbb-047e-40da-88ca-d915c9964c87 mysql_slowlog_agent Running 0

The slow log is enabled, but the long_query_time has this value:

±----------------±------------+
| Variable_name | Value |
±----------------±---------------- +
| long_query_time | 10.000000 |
±-------------------±--------------+

Please advice
Thanks

4

That means you will not see any queries inside PMM unless the query takes longer than 10s to execute. I recommend you SET PERSIST long_query_time=0; FLUSH SLOW LOGS; Or switch to the perfschema query source.