[mythtv-users] Slow MySQL query after delete

[Jay R. Ashworth]

On Thu, Nov 29, 2007 at 07:41:11PM -0500, Michael T. Dean wrote:
> a file system thing--i.e. disk thrashing as XFS tries to delete the
> recording at full speed

Just to be clear: the issue, I believe, is actually the load that's
placed on the machine as the filesystem moves blocks to the free list;
unlink() ought to return semi-instantly, as all it has to fiddle
directly is the directories.

The filesystem code itself reaps the blocks on the final unlink (when
the link count in the inode drops to 0, assuming the open count is also
0).

But certainly, this is something that newer filesystems probably do
differently...  so that could be the cause. 

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