Java High-Performance Architecture

Aug 7, 2015 · Databases

Boost MySQL Connection Performance with Thread Cache: How It Works & Tuning Tips

MySQL uses a Thread Cache pool to store idle connection threads, dramatically speeding up client connection creation; understanding parameters like thread_cache_size and thread_stack, monitoring cache hit rates, and proper tuning can keep the hit rate around 90% for optimal performance.