MySQL Forums
Forum List  »  Performance

Re: thread_cache_size: Need suggestion on this paramateer
Posted by: Rick James
Date: December 27, 2015 10:17AM

I'd rather go a different direction because of

> Max_used_connections | 27169

Since you did not complain about performance, I assume you have a huge number of connections doing nothing almost all the time. That, itself, is wasting some resources.

What are your clients? How many are there? Apache? Tomcat? Something else? If Apache, what is MaxClients set to? It is rarely practical to set it higher than, say, 20.


First, try to decrease the number of clients.

Second, if you are running Windows, set thread_cache_size to 0, else set it to 40. (The OSs work differently.) thread_cache_size size is a _cache_. Up to that many _extra_ processes are kept alive. If the number of connections is very steady; it can be set low. How much does Connections fluctuate?

The other STATUS values are better measured in "per second", what was 'Uptime'?

Options: ReplyQuote

Written By
Re: thread_cache_size: Need suggestion on this paramateer
December 27, 2015 10:17AM

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.