További okosságok thread_cache_size témában

Thread_cache (from mysql doc) :

"How many threads we should keep in a cache for reuse. When a client disconnects, the client's threads are put in the cache if there aren't more than thread_cache_size threads from before. All new threads are first taken from the cache, and only when the cache is empty is a new thread created. This variable can be increased to improve performance if you have a lot of new connections. (Normally this doesn't give a notable performance improvement if you have a good thread implementation.) By examing the difference between the Connections and Threads_created you can see how efficient the current thread cache is for you."

--

If Threads_created is big, you may want to increase the thread_cache_size variable. The cache hit rate can be calculated with Threads_created/Connections.

--

Thread Cache

First calculate your cache hit rate using the following formula:

100 - ((Threads_created / Connections) * 100)

Should be as close to 100% as possible. You will need to adjust the thread_cache_size variable. To adjust it, increase thread_cache_size until threads_created stops going up. Just making thread_cache_size 2 or 3 can make a big difference.

--

Még mindig nem vagyok elégedett a teljesítménnyel. A fentiek értelmében növeltem az értéket, mysql restart volt.