[mythtv-users] Slow MySQL query after delete

crs23 pvr at groundhog.pair.com
Thu Sep 6 02:52:42 UTC 2007

crs23 wrote:
> 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
recordmatch table.

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 mailing list