ProxySQL icon



Plugin: go.d.plugin Module: proxysql


This collector monitors ProxySQL servers.

This collector is supported on all platforms.

This collector supports collecting metrics from multiple instances of this integration, including remote instances.

Default Behavior


This integration doesn’t support auto-detection.


The default configuration for this integration does not impose any limits on data collection.

Performance Impact

The default configuration for this integration is not expected to impose a significant performance impact on the system.



No action required.



The configuration file name for this integration is go.d/proxysql.conf.

You can edit the configuration file using the edit-config script from the Netdata config directory.

cd /etc/netdata 2>/dev/null || cd /opt/netdata/etc/netdata
sudo ./edit-config go.d/proxysql.conf


The following options can be defined globally: update_every, autodetection_retry.

Name Description Default Required
update_every Data collection frequency. 5 False
autodetection_retry Recheck interval in seconds. Zero means no recheck will be scheduled. 0 False
dsn Data Source Name. See DSN syntax. stats:stats@tcp( True
my.cnf Specifies my.cnf file to read connection parameters from under the [client] section. False
timeout Query timeout in seconds. 1 False


TCP socket

An example configuration.

  - name: local
    dsn: stats:stats@tcp(


An example configuration.

  - name: local
    my.cnf: '/etc/my.cnf'


Note: When you define multiple jobs, their names must be unique.

Local and remote instances.

  - name: local
    dsn: stats:stats@tcp(

  - name: remote
    dsn: stats:stats@tcp(


Metrics grouped by scope.

The scope defines the instance that the metric belongs to. An instance is uniquely identified by a set of labels.

Per ProxySQL instance

These metrics refer to the entire monitored application.

This scope has no labels.


Metric Dimensions Unit
proxysql.client_connections_count connected, non_idle, hostgroup_locked connections
proxysql.client_connections_rate created, aborted connections/s
proxysql.server_connections_count connected connections
proxysql.server_connections_rate created, aborted, delayed connections/s
proxysql.backends_traffic recv, sent B/s
proxysql.clients_traffic recv, sent B/s
proxysql.active_transactions_count client connections
proxysql.questions_rate questions questions/s
proxysql.slow_queries_rate slow queries/s
proxysql.queries_rate autocommit, autocommit_filtered, commit_filtered, rollback, rollback_filtered, backend_change_user, backend_init_db, backend_set_names, frontend_init_db, frontend_set_names, frontend_use_db queries/s
proxysql.backend_statements_count total, unique statements
proxysql.backend_statements_rate prepare, execute, close statements/s
proxysql.client_statements_count total, unique statements
proxysql.client_statements_rate prepare, execute, close statements/s
proxysql.cached_statements_count cached statements
proxysql.query_cache_entries_count entries entries
proxysql.query_cache_memory_used used B
proxysql.query_cache_io in, out B/s
proxysql.query_cache_requests_rate read, write, read_success requests/s
proxysql.mysql_monitor_workers_count workers, auxiliary threads
proxysql.mysql_monitor_workers_rate started workers/s
proxysql.mysql_monitor_connect_checks_rate succeed, failed checks/s
proxysql.mysql_monitor_ping_checks_rate succeed, failed checks/s
proxysql.mysql_monitor_read_only_checks_rate succeed, failed checks/s
proxysql.mysql_monitor_replication_lag_checks_rate succeed, failed checks/s
proxysql.jemalloc_memory_used active, allocated, mapped, metadata, resident, retained B
proxysql.memory_used auth, sqlite3, query_digest, query_rules, firewall_users_table, firewall_users_config, firewall_rules_table, firewall_rules_config, mysql_threads, admin_threads, cluster_threads B
proxysql.uptime uptime seconds

Per command

These metrics refer to the SQL command.


Label Description
command SQL command.


Metric Dimensions Unit
proxysql.mysql_command_execution_rate uptime seconds
proxysql.mysql_command_execution_time time microseconds
proxysql.mysql_command_execution_duration 100us, 500us, 1ms, 5ms, 10ms, 50ms, 100ms, 500ms, 1s, 5s, 10s, +Inf microseconds

Per user

These metrics refer to the user.


Label Description
user username from the mysql_users table


Metric Dimensions Unit
proxysql.mysql_user_connections_utilization used percentage
proxysql.mysql_user_connections_count used connections

Per backend

These metrics refer to the backend server.


Label Description
host backend server host
port backend server port


Metric Dimensions Unit
proxysql.backend_status online, shunned, offline_soft, offline_hard status
proxysql.backend_connections_usage free, used connections
proxysql.backend_connections_rate succeed, failed connections/s
proxysql.backend_queries_rate queries queries/s
proxysql.backend_traffic recv, send B/s
proxysql.backend_latency latency microseconds


There are no alerts configured by default for this integration.


Debug Mode

To troubleshoot issues with the proxysql collector, run the go.d.plugin with the debug option enabled. The output should give you clues as to why the collector isn’t working.

  • Navigate to the plugins.d directory, usually at /usr/libexec/netdata/plugins.d/. If that’s not the case on your system, open netdata.conf and look for the plugins setting under [directories].

    cd /usr/libexec/netdata/plugins.d/
  • Switch to the netdata user.

    sudo -u netdata -s
  • Run the go.d.plugin to debug the collector:

    ./go.d.plugin -d -m proxysql

Get Netdata

Sign up for free

Want to see a demonstration of Netdata for multiple use cases?

Go to Live Demo