At 09:38 AM 7/27/2006, Ratheesh K J wrote:
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
So, what have you tried? Give us some information -- knowing which version
you are running would be a good start.
Are the queries slow if run from the command line?
Are there enough threads in Apache?
Have you rebuilt your indexes? Dropped them and replaced.
Run optimize database?
Done a dump and restore?
Miles Thompson
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.394 / Virus Database: 268.10.4/401 - Release Date: 7/26/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
