[mythtv-users] Slow MySQL query after delete
pvr at groundhog.pair.com
Thu Sep 6 02:52:42 UTC 2007
> 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.
Following up to myself, can anyone explain to me what the recordmatch table
is for? How do I remove rows from it? I tried removing items from
'Previous Recordings' in the frontend and that didn't do anything to the
View this message in context: http://www.nabble.com/Slow-MySQL-query-after-delete-tf4366877s15552.html#a12514739
Sent from the mythtv-users mailing list archive at Nabble.com.
More information about the mythtv-users