Do a "show status" and check on what mysql is doing. I would start by looking
at:
threads_created - if this is high, increase your thread_cache_size. This means MySQL is busy creating and destroying threads instead
of reusing them. This can take a toll on the OS.
Opened_tables - if this number is high/climbing, MySQL is buys opening and closing tables, which means your table_cache is probably
too low. Compare open_tables to table_cache, open_tables should be lower.
Show variables will help you see your current settings. Some things can be changed on the fly, like the thread cache, so can can do
some things without taking MySQL down.
----- Original Message -----
From: "Ratheesh K J" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Thursday, July 27, 2006 8:38 AM
Subject: MySQL performing too badly under heavy load - urgent hlp needed
Hello all,
Stuck up with a major problem. Urgent hlp required
MySQL seems to be performing too bad during heavy load on the server. Queries which normally take around 5 secs to complete are
taking more than 1000 secs to complete during load.
What could be the reason. Show processlist shows many process in sending data state. All tables are of INNODB type. But we are not
running any transactions as yet.
The server is clogged due to many httpd requests (150 Max). All the httpd requests are in W state ( means sending response ). What
could be causing this. Is it MySQL or is it Apache...
Any suggestions would help...
Thanks,
Ratheesh K J
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
