MySQL Forums
Forum List  »  Optimizer & Parser

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
3028
July 31, 2011 10:16AM
1445
August 08, 2011 08:51AM
961
September 17, 2011 02:18PM
Re: Close conections
975
September 18, 2011 12:54PM
1016
September 18, 2011 02:48PM
964
September 19, 2011 07:23PM
896
September 20, 2011 05:40AM
1068
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.