Admin historical statistics

Since ProxySQL 1.4.4 Admin stores historical metrics in new database named proxysql_stats.db in the datadir.Tables structures is subject to future changes.

admin-stats_mysql_connection_pool

The refresh interval (in seconds) to update the historical statistics of the connection pool.

|System Variable|Name|admin-stats_mysql_connection_pool
|Dynamic|Yes
|Permitted Values|Type|Integer (seconds)
|Default|60
|Valid values|5, 10, 30, 60, 120, 300

​

admin-stats_mysql_connections

The refresh interval (in seconds) to update the historical statistics of MySQL connections, both frontends and backends.

|System Variable|Name|admin-stats_mysql_connections
|Dynamic|Yes
|Permitted Values|Type|Integer (seconds)
|Default|60
|Valid values|5, 10, 30, 60, 120, 300

​

admin-stats_mysql_query_cache

The refresh interval (in seconds) to update the historical statistics of MySQL Query Cache.

|System Variable|Name|admin-stats_mysql_query_cache
|Dynamic|Yes
|Permitted Values|Type|Integer (seconds)
|Default|60
|Valid values|5, 10, 30, 60, 120, 300

​

admin-stats_system_cpu

The refresh interval (in seconds) to update the historical statistics of CPU usage.

|System Variable|Name|admin-stats_system_cpu
|Dynamic|Yes
|Permitted Values|Type|Integer (seconds)
|Default|60
|Valid values|5, 10, 30, 60, 120, 300

​

admin-stats_system_memory

The refresh interval (in seconds) to update the historical statistics of memory usage.Note: These statistics are not available if ProxySQL is not compiled with jemalloc. Note that all official packages are compiled with jemalloc.

|System Variable|Name|admin-stats_mysql_system_memory
|Dynamic|Yes
|Permitted Values|Type|Integer (seconds)
|Default|60
|Valid values|5, 10, 30, 60, 120, 300

​