Boost MySQL Performance by Tuning Thread Cache Size

If the MySQL configuration file sets thread_cache_size, the thread that handled a client request is kept in a cache after the client disconnects, ready to serve the next client instead of being destroyed, provided the cache limit is not reached.

The status variable Thread_created shows the total number of threads that have been created. You can view it with: show global status like 'Thread%'; If Thread_created is unusually high, it indicates that MySQL is constantly creating new threads, which consumes resources. Increasing thread_cache_size can reduce this overhead.

You can check the current thread_cache_size setting with:

show variables like 'thread_cache_size';

To change the cache size, execute for example:

set global thread_cache_size=32;