TG wrote:
----- 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
agree. they drove me nuts several times with some crazy issues, but - it usually happen with other hosting companies too. as you said support is fast and good. I like them and I use them for a while.

-afan



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

Reply via email to