MySQL Thread Cache Size

 It's advisable to set thread_cache_size so that most new connections use threads from the cache rather than newly created threads. This saves some thread-creation overhead, though normally does not create a significant performance improvement.

To Set the Thread Cache Size Use Below Step

mysql> set global thread_cache_size = 16;

Query OK, 0 rows affected (0.00 sec)

or for a persistent change, edit my.cnf

thread_cache_size       = 16

Have a look at the variables:

mysql> show variables;

+--------------------------------------------------------+--------

| Variable_name                                          | Value

| thread_cache_size                                      | 16