System Statistics and MySQL Connection Information

ProxySQL exports a lot of metrics, all visible in the stats schema and queryable using any client that uses the MySQL protocol.
This allows to ingest metrics into external monitoring tools, like Percona PMM, grafana, Severalnines ClusterControl, graphite, datadog, and others already existing or being under development.

Although we believe these monitoring tools are great and they are the right way to monitor ProxySQL, we are often faced with the issue that ProxySQL isn’t monitored while still being evaluated. This makes the troubleshooting of performance and behavior very difficult in such scenarios.
For this reason, ProxySQL version 1.4.4 introduces a new graphical stats interface: a web UI to export some metrics.
This feature doesn’t replace all the statistics already available through the Admin interface, but it facilitates the troubleshooting while ProxySQL is still being evaluated and metrics are not collected into an external software.

This feature is not final yet, only few metrics are available, and it is subject to changes in future.

Configure HTTP server

Currently there are only 2 variables related to HTTP servers:

HTTP server is currently disabled by default. To enable it it is enough to configure admin-web_enabled=true. For example:

SET admin-web_enabled='true';
LOAD ADMIN VARIABLES TO RUNTIME;

Similarly, to disable it:

SET admin-web_enabled='false';
LOAD ADMIN VARIABLES TO RUNTIME;

Once HTTP server is enabled, you can point your browser to port 6080, for example https://127.0.0.1:6080 , and use admin-stats_credentials to login.

Once you login, a dashboard with generic information is displayed. From here, you can choose a category to get useful metrics on System statistics and MySQL Connections: