MySQL performing too badly under heavy load - urgent hlp needed

2006-07-27 Thread Ratheesh K J
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

Re: MySQL performing too badly under heavy load - urgent hlp needed

2006-07-27 Thread Martin Jespersen
I doubt apache is to blame. 5 seconds for a query on a website is extremely slow, so if that is your normal results, then you have a problem there already. I've been building database driven websites for around 11 years and i don't think i can remember a single time i went into production with

Re: MySQL performing too badly under heavy load - urgent hlp needed

2006-07-27 Thread Miles Thompson
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

Re: MySQL performing too badly under heavy load - urgent hlp needed

2006-07-27 Thread rouvas
On Thursday 27 July 2006 17:00, Martin Jespersen wrote: I doubt apache is to blame. 5 seconds for a query on a website is extremely slow, so if that is your normal results, then you have a problem there already. I've been building database driven websites for around 11 years and i don't think

Re: MySQL performing too badly under heavy load - urgent hlp needed

2006-07-27 Thread Brent Baisley
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