Hi Jeff,
 
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 comes in.
 
Hope that helps...
 
Regards,
 

________________________________
 From: Jeff Pang <jeffrp...@gmail.com>
To: mysql@lists.mysql.com 
Sent: Tuesday, December 27, 2011 8:45 AM
Subject: thread connected and thread cached
 
Hello,

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?

Thanks.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql

Reply via email to