threads_connected tells you total number of connections created since server startup and
threads_cached says how many stay alive (connection pooling) even if there are no clients
connected. This means that because the value of threads_cached was reduced on your server,
it is having to fork more and more new connections every time a request for connection
Hope that helps...
From: Jeff Pang <jeffrpang@stripped>
Sent: Tuesday, December 27, 2011 8:45 AM
Subject: thread connected and thread cached
I got the two picutures attached from mycheckpoint's web graph.
They are showing the threads_connected have been increasing from 24th.
But threads_cached have been decreasing from the same day.
What does this mean for my mysql?
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql