Thanks for the response, Chris.  I have analyzed, optimized, checked, etc. 
Everything looks relatively good/healthy on the server side of things.  It 
is MyISAM.  That's one thing I don't really know very well, the benefits of 
the different DB engines.

Not sure if I'm going to be able to see a process list when there are 
problems because the problems are really intermittant.

When I do "show processlist" logged in as the same user, I don't see anything 
else executing.

The client gets an average of 600 hits per day on their site.  Nothing too 
crazy.  That's the other thing that's driving me nuts.  They get traffic, 
but it shouldn't be so much that it's causing issues ilke this.

Shouldn't have to make such radical changes for this site.  All I can think 
is that it's an issue with their server and/or other customers on the same 
shared server.

-TG

----- Original Message -----
From: Chris <[EMAIL PROTECTED]>
To: TG <[EMAIL PROTECTED]>
Cc: php-db@lists.php.net
Date: Thu, 06 Nov 2008 08:45:16 +1100
Subject: Re: [PHP-DB] Joomla MySQL query performance affected by anything 
non-server related?

> 
> > 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?
> 
> It could be worth either doing an analyze 
> (http://dev.mysql.com/doc/refman/5.0/en/analyze-table.html) or possibly 
> doing a dump/restore - in case there is lots of "bloat" either in the 
> indexes or tables. Normally you wouldn't see this with mysql (especially 
> myisam) but it's worth a shot.
> 
> What other queries are running at the same time? (use 'show processlist' 
> inside mysql to get a list), maybe you're getting lots of hits to the 
> same tables and myisam is locking everything, and it's time to convert 
> to innodb.
> 
> 
> -- 
> Postgresql & php tutorials
> http://www.designmagick.com/
> 
> 

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

Reply via email to