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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]