MySQL threads tuning
February 21, 2007
Some quick info I have pulled off of the web on MySQL performance tuning. I am currently working on some mysql performance tuning and this is some of the information I have gathered.
Threads_created details the number of threads that have been created since the MySQL server started, and Connections is the total number of client connections to the MySQL server since startup. To work out the thread cache hit ratio, we use this calculation:
100 - ((Threads_created / Connections) * 100)
100 - ((10 / 78298) * 100) = ~99.987 Thread cache hit ratio
The ideal situation is to get Threads_created as close as possible to thread_cache_size - no new connections having to wait for new thread allocation - staying as close to around a 99% hit ratio as you can.
Of course, these hit ratios can be skewed on a system that has recently been restarted.
Comments
Got something to say?
