mysql optimization : tune thread_cache_size

Based on the info in the MySQL Documentation you should do the following: Find out what the highest number of simultaneous connections mysqld has had using Connections, Threads_created, and Max_used_connections,

• SHOW GLOBAL STATUS LIKE 'Connections';
• SHOW GLOBAL STATUS LIKE 'Threads_created';
• SHOW GLOBAL STATUS LIKE 'Max_used_connections';

Try calculating the following
Threads_created / Connections : If this is over 0.01, then increase thread_cache_size. At the very least, thread_cache_size should be greater than Max_used_connections.


http://serverfault.com/questions/408845/what-value-of-thread-cache-size-should-i-use
http://anothermysqldba.blogspot.com/2013/09/mysql-optimization-tip-threadcachesize.html