----- Original Message -----
From: Afan Pasalic <[EMAIL PROTECTED]>
To: TG <[EMAIL PROTECTED]>
Cc: php-db@lists.php.net
Date: Wed, 05 Nov 2008 17:07:46 -0600
Subject: Re: [PHP-DB] Joomla MySQL query performance affected by anything 
non-server related?

> TG wrote:
> > Been getting the occasional warning on one of our client sites about 
> > excessive CPU usage and/or slow MySQL queries.
> >
> > Looking at the logs, it looks like it's more the latter (slow queries).
> >
> > Some of the queries involve some joins, etc.  But nothing too crazy, and 
> > there are the standard indexes on most of the relevant columns used in 
> > join/where clauses.  Everything Joomla 1.5 does when it does it's initial 
> > setup.
> >
> > I've done everything the web host recommends and the last thing they said 
to 
> > check the PHP code and try to optimize that a bit.  But it's standard 
> > Joomla 1.5 stuff.  They claim they don't have any other clients having 
> > problems with Joomla 1.5.
> >
> > In the end, I think this is a problem with their MySQL server or their 
server 
> > in general, but they won't admit to that.  So forgive me if this is more 
of 
> > a MySQL issue and not so much PHP-DB related, but it's the PHP side that 
is 
> > the last thing they're recommending I check that I technically haven't 
> > because I think Joomla's probably fine.
> >   
> sounds like hostmonster.com :-)
> had the same issue few times.
> tried to figure out and wasn't able. talked several times with support 
> and "suddenly" it was working ok again.
> 
> afan



Bingo!  hah.. I was going to be nice and not mention their name, because 
they've been outstanding in everything else.  Tech support has always been 
prompt and knowledgable.

I still like my Dreamhost.

Thanks for letting me know that other people have had this problem with them. 
 Maybe it'll be magically 'fixed' now for us as well.

The "too slow" logs for the last few days haven't had anything over the 7 
second one I mentioned.  The problem really came to light when there were 
multiple 20+ second queries causing problems.

-TG

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to