Re: Close conections
Posted by:
Rick James
Date: September 18, 2011 12:54PM
It is a rare machine that needs thread_cache_size greater than 10.
That is the number of threads to keep open waiting for another connection to come in, not the number of threads total. Only if your number of threads ramps up and down rapidly do you need to use a high number.
To judge whether to increase it, look at Threads_created (from SHOW STATUS). Only if that is several per second (after dividing by Uptime), should you consider raising thread_cache_size.
Subject
Views
Written By
Posted
3755
July 31, 2011 10:16AM
1742
August 08, 2011 08:51AM
1332
September 17, 2011 02:18PM
Re: Close conections
1263
September 18, 2011 12:54PM
1284
September 18, 2011 02:48PM
1323
September 19, 2011 07:23PM
1162
September 20, 2011 05:40AM
1438
September 21, 2011 11:37PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.