ITPUB
ITPUB
Dec 21, 2017 · Databases

Why MySQL Connections Stall and How Adjusting thread_cache_size Fixes It

The article explains why Percona‑MySQL 5.6 experiences occasional high‑latency connections, analyzes the role of thread pools and thread cache settings, and shows step‑by‑step how increasing thread_cache_size to match active connections eliminates the slowdown.

MySQLThread Pooldatabase_configuration
0 likes · 6 min read
Why MySQL Connections Stall and How Adjusting thread_cache_size Fixes It