5 messages in com.mysql.lists.mysqlRe: MySQL performing too badly under ...
FromSent OnAttachments
Ratheesh K J27 Jul 2006 05:38 
rouvas27 Jul 2006 06:09 
Martin Jespersen27 Jul 2006 07:00 
Miles Thompson27 Jul 2006 07:03 
Brent Baisley27 Jul 2006 07:51 
Subject:Re: MySQL performing too badly under heavy load - urgent hlp needed
From:rouvas (rou@di.uoa.gr)
Date:07/27/2006 06:09:56 AM
List:com.mysql.lists.mysql

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 i can remember a single time i went into production with a single query that was slower than 0.1 second, unless it was something very rarely used for administration purposes.

From the top of my head i'd say your problem is either

a) poor datamodel design which forces slow queries b) poor usage of indexes in the database (use explain to check) c) non-optimized configuration of the server (have you tuned the server parameters to the way you use the server?) d) insufficient hardware for your needs e) any combination of the above

f) not enough memory, that forces major swapping activity

-Stathis

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