[mythtv-users] Slow MySQL query after delete
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