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
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.
As an example of a query that showed up on the log recently:
UPDATE jos_content SET hits = ( hits + 1 ) WHERE id='123'
The log says this took 7 seconds. There's an index on "id". There are only
400 or so records in the whole table. It's not like there are a million
records and no index.
Is there ANY rational reason this query would EVER take 7 seconds to execute?
Any info/thoughts/advice would be appreciated. I know my way around a
database or two and know a few things about optimization, but I need some
solid evidence to throw at this web host so they'll listen to me. They're
usually really awesome, but this case is causing me to lose my hair.
Thanks in advance!
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php