ProxySQL Routing Dashboard

Generated: 2026-09-04 02:59:52    |    Reset: 2026-09-01 00:00:00
Backends Online
4/4
Total Queries
102,316
Peak Connections
67
Failed Connections
6
Data Transferred
1.2 GB

Read / Write Distribution

Based on query totals from main.stats_mysql_connection_pool
Write Queries 94,674 (92.5%)
92.5%
Read Queries 7,642 (7.5%)
7.5%

Busiest Backend

IRIS DB One
Write
  • Queries94,674

Server Distribution

Query load percentage per server relative to its hostgroup
IRIS DB One Write 94,674 (100.0%)
100.0%
IRIS DB One Read 1,571 (20.6%)
20.6%
IRIS DB Two Read 5,325 (69.7%)
69.7%
ProxySQL DB Read 746 (9.8%)
9.8%

Totals by Hostgroup

Quick view of traffic concentration and connection pool pressure
Role Servers Online Queries Active Conn Idle Conn Successful Conn Failed Conn Peak Conn
Write 1 1 94,674 0 27 27 0 24
Read 3 3 7,642 0 48 56 6 43

Backend Detail

Per-backend routing, connection, and latency statistics
Server Hostgroup Status Active Conn Idle Conn Successful Conn Failed Conn Peak Conn Bytes Sent Bytes Recv
IRIS DB One Write ONLINE 0 27 27 0 24 330.2 MB 893 MB
IRIS DB One Read ONLINE 0 10 12 0 8 294.6 KB 1.2 MB
IRIS DB Two Read ONLINE 0 29 33 4 28 1 MB 4.9 MB
ProxySQL DB Read ONLINE 0 9 11 2 7 139.9 KB 627.5 KB