[mythtv-users] Slow MySQL query after delete

[Jay R. Ashworth]

On Sun, Dec 02, 2007 at 10:59:14AM -0500, Pam Ashworth wrote:
> >I suspect a lot of people never see this issue because they let auto- 
> >expire take care of most of their deletions, so they rarely actually  
> >try to trigger two scheduler events close to each other.
> 
> does it happen if you create a playlist and delete the playlist? (just
> wondering as I used to have trouble with that. I have my machine set
> up to delete slowly now, because I saw the option for it and because
> deletes were glitching my playback as I was recording onto DVD (analog
> via video cables).)

Note that we're using XFS for our media drives.

I think.  :-)

> I saw the scheduler one night. I was recording three shows and then
> three more and it was near the top of the hour and all the tuners were
> changing (on a system with 512MB RAM and 2400(Mhz?) cpu.) My brother
> has this little program and it watched the messages (from the backend
> log maybe) in realtime and when the hour hit - it nearly just froze
> (I think perhaps, the first time, mythfill chose that moment to run
> (arrgghhh). the second time, i was just the scheduler.) Ultimately,
> it got everything done and if there were glitches, they must have hit
> the commercials as I never saw/heard them. but it was pretty scary
> to watch at the time, considering that we'd had three different 10pm
> lockups by then (I think we had a rootkit?) and I thought I was seeing
> another one (and the system takes 4 minutes to reboot - a fact which
> NBC cares nothing about. I *like* teasers, and I like seeing the lat
> 30 seconds of Grey's)
>
> but no, as Jay asked me the other night, I haven't done any mutiple
> deletes lately unless I did them with a Delete Playlist

And, alas, she had nothing that I could try manually deleting; save
something for me, 'k?

Cheers
-- jra
-- 
Jay R. Ashworth                   Baylink                      jra at baylink.com
Designer                     The Things I Think                       RFC 2100
Ashworth & Associates     http://baylink.pitas.com                     '87 e24
St Petersburg FL USA      http://photo.imageinc.us             +1 727 647 1274

	     Witty slogan redacted until AMPTP stop screwing WGA