PMM2 - no data for graphs

PMM2 - ProxySql graphs aren’t showing the data.

PMM-agent Version: 2.27.0
PMMVersion: 2.27.0

Hello @Ani_Ghoghoberidze,
Please give the exact command you used to add proxysql to your PMM.

Hi @matthewb

First of all, sorry for the late reply, I missed notification.

Here’s the commands :

sudo pmm-admin config --server-insecure-tls --server-url=https://user:password@IP

sudo pmm-admin add proxysql --username=user --password=password --port=port

Can you provide which port you used when adding proxysql to pmm? Also, can you run these queries on the proxysql admin interface?

SELECT hostgroup, srv_host, srv_port, * FROM stats_mysql_connection_pool
SELECT COUNT(cli_host) as connection_count, cli_host FROM stats_mysql_processlist GROUP BY cli_host
SELECT hostgroup_id, hostname, port, gtid_port, * FROM runtime_mysql_servers