[mythtv-users] Slow MySQL query after delete

David Rees drees76 at gmail.com
Fri Nov 30 19:04:14 UTC 2007


On Nov 30, 2007 7:51 AM, Larry K <lunchtimelarry at gmail.com> wrote:
> FYI, I enabled slow deletes and so far I am not convinced it has helped any.
> This was a useful suggestion that perhaps I dismissed prematurely.

On JFS/XFS filesystems, it's not likely to help that much unless you
have really big recordings. If you use ext3, it's almost a
requirement.

> Several people have suggested we convert the recordedseek table to innoDB,
> but that table does not participate in the BUSQ.

Please convert ALL tables to InnoDB (except for nestitle, see my post
from last night), not just the recordedseek table. Let us know how it
works.

-Dave


More information about the mythtv-users mailing list