Hi! 👋 We are doing a big documentation refresh. Help us improve — what's missing or could be better? Let us know! Simply send an email or start a conversation in Google Groups!

Global Variables Quick Reference

The table below lists the most commonly used ProxySQL global variables, their default values, and a brief description. Variables are grouped by functional area. For full documentation on any variable, see the dedicated sections under Global Variables in the sidebar.

Network & Interfaces

Variable NameDefaultDescription
mysql-interfaces0.0.0.0:6033TCP interfaces for client connections
pgsql-interfaces(empty)TCP interfaces for PostgreSQL client connections
admin-mysql_ifaces0.0.0.0:6032Admin interface address

Authentication

Variable NameDefaultDescription
admin-admin_credentialsadmin:adminAdmin interface credentials
admin-stats_credentialsstats:statsStats-only interface credentials

Threading & Performance

Variable NameDefaultDescription
mysql-threads4Number of MySQL worker threads
mysql-max_connections2048Maximum client connections
mysql-connection_max_age_ms0Maximum backend connection age (0 = unlimited)

Query Processing

Variable NameDefaultDescription
mysql-query_digeststrueEnable query digest collection
mysql-multiplexingtrueEnable connection multiplexing
mysql-default_query_timeout36000000Default query timeout (ms)

Monitoring

Variable NameDefaultDescription
mysql-monitor_enabledtrueEnable backend monitoring
mysql-monitor_connect_interval60000Connection check interval (ms)
mysql-monitor_ping_interval10000Ping check interval (ms)