Prometheus exporter for ProxySQL performance data.
Prometheus exporter for ProxySQL performance data. Supported versions: 1.2 and 1.3.
make
The MySQL server's data source name must be set via the DATA_SOURCE_NAME
environment variable. The format of this
variable is described at https://github.com/go-sql-driver/mysql#dsn-data-source-name.
To enable HTTP basic authentication, set environment variable HTTP_AUTH
to user:password pair. Alternatively, you can
use YAML file with server_user
and server_password
fields.
export DATA_SOURCE_NAME='stats:stats@tcp(127.0.0.1:42004)/'
export HTTP_AUTH='user:password'
./proxysql_exporter <flags>
Note, using stats
user requires ProxySQL 1.2.4 or higher. Otherwise, use admin
user.
Name | Description |
---|---|
collect.detailed.stats_mysql_processlist |
Collect detailed connection list from stats_mysql_processlist. |
collect.mysql_connection_list |
Collect connection list from stats_mysql_processlist. (default true) |
collect.mysql_connection_pool |
Collect from stats_mysql_connection_pool. (default true) |
collect.mysql_status |
Collect from stats_mysql_global (SHOW MYSQL STATUS). (default true) |
collect.runtime_mysql_servers |
Collect from runtime_mysql_servers - need admin credentials. (default false) |
collect.stats_memory_metrics |
Collect memory metrics from stats_memory_metrics. |
Name | Description |
---|---|
version |
Print version information and exit. |
web.auth-file |
Path to YAML file with server_user, server_password keys for HTTP Basic authentication (overrides HTTP_AUTH environment variable). |
web.listen-address |
Address to listen on for web interface and telemetry. (default ":42004") |
web.ssl-cert-file |
Path to SSL certificate file. |
web.ssl-key-file |
Path to SSL key file. |
web.telemetry-path |
Path under which to expose metrics. (default "/metrics") |
There is a Grafana dashboard for ProxySQL available as a part of PMM project, you can see the demo here.
If you find a bug in Percona ProxySQL Exporter or one of the related projects, you should submit a report to that project's JIRA issue tracker.
Your first step should be to search the existing set of open tickets for a similar report. If you find that someone else has already reported your problem, then you can upvote that report to increase its visibility.
If there is no existing report, submit a report following these steps:
An excellent resource is Elika Etemad's article on filing good bug reports..
As a general rule of thumb, please try to create bug reports that are: