Main Runtime

Overview

The ProxySQL Admin interface exposes configuration and runtime tables accessible via either the MySQL or PostgreSQL protocol. There are 50+ configuration and runtime tables across MySQL, PostgreSQL, and system categories.

Configuration Layers

Every configuration item exists in three layers:

Layer	Table Prefix	Description
Memory	(no prefix)	In-memory working copy — edit here
Runtime	`runtime_`	Active configuration used by worker threads
Disk	`disk`	Persisted to SQLite (`proxysql.db`)

Key Configuration Tables

MySQL/PostgreSQL Common Tables

Table	Configures
`mysql_users`, `pgsql_users`	Frontend and Backend MySQL/PostgreSQL Users
`mysql_servers`, `pgsql_servers`	Backend MySQL/PostgreSQL Servers
`mysql_query_rules`, `pgsql_query_rules`	Query Rules for MySQL/PostgreSQL traffic
`mysql_replication_hostgroups`, `pgsql_replication_hostgroups`	MySQL/PostgreSQL replication clusters with servers in RW or RO mode
`mysql_query_rules_fast_routing`, `pgsql_query_rules_fast_routing`	Query Rules for MySQL/PostgreSQL traffic specialized in routing
`mysql_hostgroup_attributes`, `pgsql_hostgroup_attributes`	Hostgroup-specific attributes that override global settings

MySQL Specific Tables

Table	Configures
`mysql_collations`	Known MySQL charsets and collations
`mysql_galera_hostgroups`	MySQL clusters using Galera replication
`mysql_group_replication_hostgroups`	MySQL clusters using Group Replication
`mysql_servers_ssl_params`	Backend MySQL Server specific SSL Parameters

System Tables

Table	Configures
`global_variables`	All variables
`scheduler`	Tasks that the Scheduler can execute
`proxysql_servers`	List of core nodes in ProxySQL Cluster
`restapi_routes`	RESTAPI endpoints

In the following sections you will find a detailed description of all the configuration tables.

Key Table Categories

Server Management

mysql_servers / pgsql_servers — Backend database servers organised into hostgroups
mysql_replication_hostgroups — Read/write split based on read_only
mysql_group_replication_hostgroups — Group Replication topology
mysql_galera_hostgroups — Galera Cluster topology
mysql_hostgroup_attributes / pgsql_hostgroup_attributes — Per-hostgroup settings

User Authentication

mysql_users / pgsql_users — Frontend/backend credentials, default hostgroup, SSL requirements, connection limits

Query Routing

mysql_query_rules / pgsql_query_rules — Pattern matching, rewriting, caching, routing, and load balancing
mysql_query_rules_fast_routing / pgsql_query_rules_fast_routing — Optimised routing by username, schema, and flags

Other Tables

scheduler — Automated task execution
global_variables — Key-value configuration store
mysql_collations — Character set and collation reference
proxysql_servers — ProxySQL cluster node definitions
restapi_routes — REST API endpoint configuration

Table Definitions

The following provide detailed information on tables and columns by category.