[mythtv-users] Slow MySQL query after delete

[mons37318 at mypacks.net]

-----Original Message-----
>From: "Jay R. Ashworth" <jra at baylink.com>
>Sent: Dec 2, 2007 8:17 PM
>To: mythtv-users at mythtv.org
>Subject: Re: [mythtv-users] Slow MySQL query after delete
>
>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.  :-)
>

is there some nice linux command that lists what file systems your devices are using? (and if not, why not? one shouldn't have to go attempt to repartition the drives to get an answer to this (which is the only place i've seen it, albeit most often in Windows)
(and Jay, you left me a Linux install disc, but didn't tell me how to partition the drive - unless Linux plans to tell me, email me at my regular address (yes i just moved this list) and let me know?)




--
Pam from Boston
"You're going to have to explain it. Bear with the rest of us mortals as we stumble blindly along in your shadow." -- Stacy, in Sy's House fanfic  "Of a Thursday"
http://www.fanfiction.net/s/2399047/7/