ProxySQL PMM Failed to Load Connection Pool Usage Graph

Jyoti_Rajai · July 2, 2022, 4:56am

Hey Team,

Greetings !!

I am facing issue while view PMM graphs of ProxySQL.

There is one Graph Named → Connection Pool Usage appear blank.

Can you help how to gets this graph ?

Thank you in Advance.

Vadim_Yalovets · July 4, 2022, 6:32am

Hi Jyoti,

Could you show parameters of metric proxysql_connection_pool_status ?
It can be done in Explore.

e.g.

Jyoti_Rajai · July 4, 2022, 9:22am

Vadim_Yalovets · July 4, 2022, 10:24am

Also could you enter the editing mode of element

and provide a screenshot of Query inspector Data ?
e.g.

Jyoti_Rajai · July 5, 2022, 6:05am

Apostolos_Karavias · June 1, 2023, 7:57am

Hello, I have the same issue with 2.37 PMM Server. Added Proxies, everything works ok expect this table in Grafana:

Roma_Novikov · June 1, 2023, 9:34am

Hello @Apostolos_Karavias, may I ask what version of the client you are currently using? It seems that this issue is connected to [PMM-12090] ProxySQL: Metrics for Client Frontend Connections not present - Percona JIRA. To stay informed, I recommend keeping an eye on Jira for any updates regarding this matter.

Apostolos_Karavias · June 1, 2023, 10:16am

Hi, it’s 2.37, I’ll check the Jira for updates, thank you for your time.