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]

Reply via email to