[mythtv-users] Slow MySQL query after delete

crs23 pvr at groundhog.pair.com
Thu Sep 6 02:29:39 UTC 2007



Michael T. Dean wrote:
> 
> Speaking of which--sorry to get on topic--this reminded me of an
> important change that the OP should note...
> 
> OP, you still listening?  :)
> 
> In the new optimize_mythdb.pl that's in SVN trunk, we now do an ANALYZE
> TABLE in addition to the REPAIR and OPTIMIZE.  Unfortunately the one in
> SVN trunk relies on some Perl bindings functionality that's not in
> 0.20-fixes, but it should be an easy change.  The attached (untested)
> patch (where I never even attempted executing the changed script) should
> add the ANALYZE to a 0.20-fixes optimize_mythdb.pl.  If you patch your
> copy and re-run optimize_mythdb.pl (when Myth isn't busy recording or
> transcoding or whatever), does it help?
> 

Yep, I'm still here.  I applied your patch and ran it.  Unfortunately, I'm
still getting about 30 seconds.  Thanks for trying.  With various
defragmentations and my.cnf adjustments and running optimize on the DB I
appear to be down from 36 seconds to 30 seconds, but that's really not good
enough.  As I mentioned in another post in this thread I think I'll just
have to remove rows from recordmatch.  I also pointed out that this SELECT
should be considered a serious bug in MythTV.

-- 
View this message in context: http://www.nabble.com/Slow-MySQL-query-after-delete-tf4366877s15552.html#a12514556
Sent from the mythtv-users mailing list archive at Nabble.com.



More information about the mythtv-users mailing list