[mythtv-users] Slow MySQL query after delete

Jerome Yuzyk jerome at supernet.ab.ca
Thu Nov 29 03:34:10 UTC 2007

On Wednesday 28 November 2007 20:10, Larry K wrote:
> > >(Though there's a good chance you /should/ enable slow deletes.)
> >
> > Since the issue here is a slow SQL statement and not a slow file system
> > (mine is xfs and deletes have never been slow), I wonder how this will
> > help?  I thought this myth-setup option was to implemented to help
> > overcome slow file system deletes.
> >
> > >Yep.  Without changing your MySQL configuration, that's as good as it
> > >will get.  I'll leave figuring out how to change your MySQL
> > >configuration--and the consequences of doing so--to you (as really, the
> > >fact that it takes 6-7 seconds to schedule recordings should make no
> > >difference to you).
> If the scheduler is blocking the frontend when it does this 7 second
> operation, it clearly makes a difference to me.  It is very frustrating to
> sit and wait up to 10 seconds after every delete (from either the frontend
> or mythweb).
> I am open to suggestions as to how I can improve this situation.
> Thanks,
> Larry

This has to indicate using slow deletes then. I have a pretty wimpy FE/BE 
machine and slow deletes on and from the Recorded Programs in the frontend of 
MythWeb the wait is only a second or two for even the longest (5 hours of 
football) delete.

More information about the mythtv-users mailing list