ProxySQL 3.1.6 Release Notes

Release date: 2026-03-10

ProxySQL 3.1.6 is the first release of the Innovative Tier, introducing revolutionary observability features built directly into the proxy. It incorporates all improvements from ProxySQL 3.0.6 while adding the Embedded Time-Series Database (TSDB) and the Fast Forward Traffic Observer (FFTO). This version is built using PROXYSQL31=1.

Release commit: 3803f11077f21510b2b43ea7168abf91b54b739e

Highlights (Innovative Tier)

• Embedded Time-Series Database (TSDB): A native, high-performance metric storage subsystem capable of recording historical performance data for long time.
• Fast Forward Traffic Observer (FFTO): Deep observability for traffic in fast-forward mode, allowing administrators to inspect and analyze traffic that was previously "invisible" to ProxySQL's query logging.
• Native Monitoring Dashboard: A built-in web dashboard leveraging the TSDB to provide real-time and historical performance visualization.
• Comprehensive Release Tiers: Introduction of the tier-based build system to provide clear upgrade paths for stable, innovative, and experimental features.

New Features (3.1.x)

Embedded Time-Series Database (TSDB)

Native Metric Storage (f17e999, #5383, #5426)
ProxySQL 3.1.6 introduces a native, high-performance TSDB subsystem. This subsystem automatically samples and records internal metrics, backend health status, and query execution statistics. By storing this data in an optimized and embedded SQLite-based database, ProxySQL can provide historical performance analysis without requiring external monitoring infrastructure. Configuration is managed via the new tsdb- prefixed variables.

Historical Monitoring Dashboard (c73011b, #5383)
Leveraging the TSDB, ProxySQL now includes a built-in monitoring dashboard accessible via the HTTP server. This dashboard provides visual representations of backend health, connection pool utilization, and query latency over time, allowing for rapid identification of performance trends and anomalies.

Fast Forward Traffic Observer (FFTO)

Visibility for Fast-Forwarded Traffic (3a3be5a, #5410)
In previous versions, traffic routed through ProxySQL in "fast-forward" mode (direct packet-level forwarding) bypassed the query logging and statistics gathering modules. FFTO addresses this limitation by implementing a non-blocking observer that analyzes the packet stream in real-time. This provides visibility into query patterns and execution counts even for traffic that is being forwarded with minimal overhead.

Protocol-Aware Traffic Analysis (40aff57, #5410)
FFTO is fully compatible with both MySQL and PostgreSQL protocols. It can reconstruct query boundaries, identify statement types, and record metrics such as affected_rows and rows_sent for fast-forwarded sessions. This data is exposed through new statistics tables and can be exported to external monitoring systems.

Features Inherited from v3.0.6 (Stable Tier)

ProxySQL 3.1.6 includes all features, bug fixes, and improvements from the v3.0.6 release, including:

• Security Hardening: Secure SCRAM authentication replacing strtok usage (#5348).
• PostgreSQL Meta-Commands: Support for \d, \dt, \l in the Admin interface (#5367).
• Protocol Resilience: Hardened PostgreSQL protocol handling and malformed packet validation (#5429).
• macOS Support: Full compatibility with macOS (Darwin/Apple Silicon) (#5308).
• Prometheus Labels: Protocol-specific labeling for ambiguous metrics (#5361).

For a detailed list of these core improvements, please refer to the ProxySQL 3.0.6 Release Notes.

Contributors

ProxySQL is a community-driven project, and we are grateful to all the contributors who helped make this release possible. A special thank you to:

• @rahim-kanji for the extensive work on PostgreSQL protocol hardening and meta-command support.
• @wazir-ahmed for implementing the TSDB subsystem and MCP stack.
• @JavierJF for adding PostgreSQL replication lag monitoring and improving diagnostics.
• @Gonlo2 for critical fixes in connection pool management and SSL handling.
• @mirostauder for build system improvements and Fedora 43 support.
• @evkuzin for enhancing Prometheus metric observability.
• @orbisai0security for identifying and fixing security vulnerabilities.
• @mevishalr for performance optimizations in query logging.

We also thank everyone who reported bugs, tested experimental features, and provided feedback during this release cycle.

Hashes

The release commit is: 3803f11077f21510b2b43ea7168abf91b54b739e

SHA256s:

c6dd6660abb1d326cf07105cd0b37ee88b32cacc4b7a871ff71b53d1ab7fecd6  proxysql-3.1.6-1-almalinux10-clang.x86_64.rpm
6ac343ec8c9272886dc9b8b86b099803288b0a55eb340683e37d296714f507ca  proxysql-3.1.6-1-almalinux10.aarch64.rpm
9cd37ba870f462ed8c8d267e54b222d6ad2aede0d823a2c63c256d2ffe6a380f  proxysql-3.1.6-1-almalinux10.x86_64.rpm
c43c4e942a6fccec15531897dc907d03a668b06de0e4cf887fe25fded5632924  proxysql-3.1.6-1-almalinux8-clang.x86_64.rpm
40c4df5215ad410161dd314716ad55196189fa53c43b1b919e9cdfab1caaa562  proxysql-3.1.6-1-almalinux8.aarch64.rpm
42cc70fd81cac7d697403366a33fd54f4d318bf048852bcbc0275290aca0b9ee  proxysql-3.1.6-1-almalinux8.x86_64.rpm
9017bcebf7d04c329b11890cdabd71946987811b2fc98061426dc0c25ca321e4  proxysql-3.1.6-1-almalinux9-clang.x86_64.rpm
7da8cdbe935c4b17e1793ae934b3d7caa9484e26a0911f7040091b29b9390387  proxysql-3.1.6-1-almalinux9.aarch64.rpm
90f08da700258ed7fb8270b8f09e911befcecd02c91a730c8a2f181b16791207  proxysql-3.1.6-1-almalinux9.x86_64.rpm
52c35bf716ce44d60bfbc473aa6e8180e55d57755986297e81ddd7614dae57fb  proxysql-3.1.6-1-centos10-clang.x86_64.rpm
e59c81d668fb9054d86203e381825fee02ba9df5672c57bb24928a5bdc4fb777  proxysql-3.1.6-1-centos10.aarch64.rpm
ef02c1c031ec83905b2b57f787b1185b8f05d4d6f1c846b405547dd661cc15f1  proxysql-3.1.6-1-centos10.x86_64.rpm
540c3d9b9af8becb3c40c75cff7634d51801a4e6558767f88ea5a8543733a12c  proxysql-3.1.6-1-centos9-clang.x86_64.rpm
31033db686f9fef45f6e8c75801fd717c437a7bad868fd3671abb59763c3d7ed  proxysql-3.1.6-1-centos9.aarch64.rpm
a409810f43d4f5f3bac617830d0ae94deea7f088aed52153dd08b29a412451a8  proxysql-3.1.6-1-centos9.x86_64.rpm
7d78240dd012b848a30ba0a0ee32a348a467339b4536928f48546bb5265a3865  proxysql-3.1.6-1-dbg-almalinux10.x86_64.rpm
139eaf0a5df93d8b497253cc6c546fa2bb05b5eb59724457f4e3143e0c83cb35  proxysql-3.1.6-1-dbg-almalinux8.x86_64.rpm
df14371648f1128c09e04bc24cd7169aaa271d80900c856f1266701de682b0e6  proxysql-3.1.6-1-dbg-almalinux9.x86_64.rpm
48f4324277c719b2ef7de6660c2aaadab4c0a537e96b7424afda0b648cb2f54d  proxysql-3.1.6-1-dbg-centos10.x86_64.rpm
6cd3560174a4e703fba4c675439612551da1dc71d56da5236c4a44d15022da2d  proxysql-3.1.6-1-dbg-centos9.x86_64.rpm
9f7595147c819ea8761dd4ab6a9005aaef4e0504b95e12767c8c46b0458bb3d9  proxysql-3.1.6-1-dbg-fedora42.x86_64.rpm
71260c70004542a606e95f2ab866a55898228b7564751865152ce3a2bf385aaf  proxysql-3.1.6-1-dbg-fedora43.x86_64.rpm
c5027caeadb428195a8e10c6bb88aeae5525221659eb2265039cde8cb46c418a  proxysql-3.1.6-1-dbg-opensuse15.x86_64.rpm
4c90070ef52fc92abd7b9a55f5024b208f4e6540976a7399ad25da3bd77ac968  proxysql-3.1.6-1-dbg-opensuse16.x86_64.rpm
97472c0b0410438c1941561604f5bab625f2f5668b7ce30e51a2604aa0ddd153  proxysql-3.1.6-1-fedora42-clang.x86_64.rpm
c156ce0d6f4df277a4b7123d8ad286184ba67c04709f2b044e663f0bfaeec237  proxysql-3.1.6-1-fedora42.aarch64.rpm
af1e21fd368498a484c3cb619a132b5eaf5c278a9a412cf9235509f2a3c9630b  proxysql-3.1.6-1-fedora42.x86_64.rpm
31490630cfe94588adc3816d720719fcc7519e6670df6df043245c359bdda176  proxysql-3.1.6-1-fedora43-clang.x86_64.rpm
66d0b35302a1e7f5c64dea13edfd75a22cef2350a322b1d2a160d2c6c7af8d70  proxysql-3.1.6-1-fedora43.aarch64.rpm
930c490a85264ac162b83ac006191df9e6a7bf846eeabec0e525bbf8001dc258  proxysql-3.1.6-1-fedora43.x86_64.rpm
8c57529f3bce1cc53945b1a4266919929f3b5ce72789e5df834c47363e977203  proxysql-3.1.6-1-opensuse15-clang.x86_64.rpm
f8bf88de7e2eccff13181ae1fa79122ce72853690315c55b67ed77120f65f999  proxysql-3.1.6-1-opensuse15.aarch64.rpm
63cf0ad07623d78ecfd28b836781fee7ff6e22f832f409d8b3138219a2589284  proxysql-3.1.6-1-opensuse15.x86_64.rpm
30dea4eb9dc356695752254b530b0c3e5a10467aa692b655da0565c4b4e3a9a8  proxysql-3.1.6-1-opensuse16-clang.x86_64.rpm
22799609e01d09a38d9c20a051a2a283050de4691365c41d8041e894a21646bc  proxysql-3.1.6-1-opensuse16.aarch64.rpm
5c5f2eda6c5c62ea085ebeaf6024df6f89a0bb96140ad50ac281207e212d2f46  proxysql-3.1.6-1-opensuse16.x86_64.rpm
e696c5925c7adbd6b423d06799ec5ced9753f850ac0a3ae79c0ba50917927363  proxysql_3.1.6-dbg-debian12_amd64.deb
0c1bca285893ac7cb5d338af1891653b2c6237ed589ec2d022f887323282fbb5  proxysql_3.1.6-dbg-debian13_amd64.deb
3fd6b7647b9cf4bf6205a5c091bf71211bc95a48246ba131d536c907531cec07  proxysql_3.1.6-dbg-ubuntu22_amd64.deb
3a9758bedf337dfef40279835bb0519082d644be8cbe1395c35d15bf5fcbef93  proxysql_3.1.6-dbg-ubuntu22_arm64.deb
ff70c4d5f769a7e2c7c5186e92fb63e70cc830cf0c62b58bc47c7a11fb4dff6e  proxysql_3.1.6-dbg-ubuntu24_amd64.deb
47f7325579aa4b4818fea28d352fc515857dfb148db2f0c1fbe7cdfd46bf544b  proxysql_3.1.6-dbg-ubuntu24_arm64.deb
a0258c91f5ee6f658ae8753efea11804537b85412d8eec5c2571e37c5414270f  proxysql_3.1.6-debian12-clang_amd64.deb
a771810b803975f7da64965afb6b6e4b15fb6be0e0bd28bde1475f1a6c14b85c  proxysql_3.1.6-debian12_amd64.deb
73d3a0c96662c89d5ebcd4f6fdf5c4340c9e3437583c3ad2b5eb15bf9805d78e  proxysql_3.1.6-debian12_arm64.deb
d40985a791c38225a54954cd39ef0188f244bd681042b23062931fe6f3e54bbd  proxysql_3.1.6-debian13-clang_amd64.deb
77819cca79b66ac378d32509620f1eb1552e4b2e7149a1170d86720ff518bbaf  proxysql_3.1.6-debian13_amd64.deb
dde9bd409a7f62c7e69c51a777fca2cd12d108d0a5ed5ada1dbfc1e3c48df760  proxysql_3.1.6-debian13_arm64.deb
37fa35e9bbd01206bfd1cf46c08ce7924f213e5ed2cf844ea98fad8e4f6fddaa  proxysql_3.1.6-ubuntu22-clang_amd64.deb
ad3f8f0a9b289a0b0a75d000d78a2540f09662f9ea32b6a6c25d80fb9f85bd0e  proxysql_3.1.6-ubuntu22-clang_arm64.deb
49555fc478a073b4fc97b880ba2182fc199a795f83f68cfcfb587a125754cb75  proxysql_3.1.6-ubuntu22_amd64.deb
6f27698a8423f7764be94d963136ad864a876af7fe5d122d2443211b1606c977  proxysql_3.1.6-ubuntu22_arm64.deb
23b8ada03a3b574fa258e3b652e6ae9064df8bcd45ea609490d82fb096601505  proxysql_3.1.6-ubuntu24-clang_amd64.deb
cd1cf46abc3b03f9667e4184f392f7188e42d62908f7fdbb3622d60d392ca9ce  proxysql_3.1.6-ubuntu24-clang_arm64.deb
7f4ae10b24298b7cf0ade9c055758da3c7fc4f53a0aa1ceedd9154cdefaab024  proxysql_3.1.6-ubuntu24_amd64.deb
d660481ea1ddecbd8af41f2726b1e77bedf747bb030d8fb054b5d4ce12ea7230  proxysql_3.1.6-ubuntu24_arm64.deb