Do a "show status" and check on what mysql is doing. I would start by looking
at:
threads_created - if this is high, increase your thread_cache_size. This means MySQL is busy creating and destroying threads instead
of reusing them. This can take a toll on the OS.
Opened_tables - if this number
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 t
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
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 wit
