Hi.
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