Re: myisamchk requires huge amounts of disk space

[Dan Nelson]

In the last episode (Jul 07), Rick Moore said:
> Hello!
> 
> I'm running mysql 3.23.15 on FreeBSD 4.0.  The database consists of a single
> table which take about 8 gigs on a 32 gig partition.  I've confirmed this
> with df -k.
> 
> I set and export "TMPDIR=." and when I run "myisamchk -r -R1 *.MYI",
> the "-r" bit fails, claiming that it is out of disk space.  I am
> fairly certain TMPDIR is working correctly, but how much disk space
> does myisamchk require? Seems unreasonable to require 4x the disk
> space just to recover files.  Am I doing something wrong, or is there
> a bug, or is that they way it is?

What is the size of the temporary database file just before myisamchk
fails?  Are you maybe hitting your filesize resource limit (ulimit -f)
or something?

-- 
	Dan Nelson
	dnelson@stripped