sysown / proxysql

High-performance MySQL proxy with a GPL license.
http://www.proxysql.com
GNU General Public License v3.0
6.06k stars 983 forks source link

[Question] Does ProxySQL Provide Metrics for User Maximum Connections and Current Connection Usage? #4526

Closed psujit775 closed 7 months ago

psujit775 commented 7 months ago

ProxySQL 2.1 and later versions include a built-in Prometheus exporter, exposing relevant ProxySQL metrics.

In ProxySQL, we can limit the maximum connections per user or per host group.

Does ProxySQL expose any metrics that can indicate the maximum connections for a user or a host group? Similarly, is there any metric that can provide the current connections used by the user or a host group?

Use Case:

I want to raise an alert if a user or host group has used 80% of their defined max_connections.

renecannao commented 7 months ago

Hi @psujit775 Interesting timing... See #4529

psujit775 commented 7 months ago

Thanks for the consideration @renecannao . I'll close this and follow #4529