Hi,
Here, threads_connected is considerable and below the preset value.
The threads_connected and threads_running are the good indicators to see how
loaded the server is. In your case it is good numbers.
So use 'iostat'/relavant utility to monitor the DB activity.
Also threads_created is more, which should be low. so to average it
increase the thread_cache size to some 64 or more.
Ref:
http://www.mysql.com/news-and-events/newsletter/2004-01/a0000000301.html
Thanks
ViSolve DB Team
----- Original Message -----
From: "Ratheesh K J" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Tuesday, January 23, 2007 11:59 AM
Subject: Urgent - MySQL 5 - mysqld using a lot of memory consistently
Hello all,
Recently we upgraded from MySQL 4.1.11 to MySQL 5.0.22. The queries are
taking a lot of time to execute in the newer version. The queries which were
executing within 10 secs are now taking more than 100 secs.
Running an expalin on the queries showed that an index_merge optimization is
being used which is a new concept in MySQL 5. My initial doubt was on this
but now when I checked top it shows that mysqld is consistently using 59% of
Memory and 25% of cpu even when there is no load.
the SHOW STATUS command in mysql shows:
Threads_created 21863
Threads_cached 1
Threads_connected 38
Connections 5784350
Running a SHOW VARIABLES shows:
thread_cache_size 8
It is evident that mysqld is creating a lots of threads... Could this be the
problem?
Thanks,
Ratheesh K J
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]