MySQL Thread_cache_size optimization method

MySQL Tutorial thread_cache_size optimization method

This in fact in the Database Tutorial configuration optimization does not play a big role, let's look at a set of parameters

MySQL thread_cache_size default configuration thread_cache_size=8

The recommended parameter thread_cache_size size setting is determined by memory and is set to 64 when memory >3g
I want to know why can't set more, our application concurrent >500 if thread_cache_size set to 500

Set method

Optimization method:

1, mysql> set global thread_cache_size=16

2. Edit/ETC/MY.CNF Change/Add