Hi,

I think I have already reported this once, when myisampack cannot wriote whole TMD file in tmpdir, it exits and doesn't delete the TMD file. This efectively prevents successive myisampack runs to operate in that directory at all.

In my case, the disk is filled up to 100%, but because the file is left there, not even much smaller table can be compressed successively.

How-To-Repeat:

Celegans_new.intragenome_data: myisampack --backup -f
--tmpdir=/usr/local/mysql/tmp intragenome_data.MYI Compressing /data1/mysql/Celegans_new/intragenome_data.MYD: (20219 records) - Calculating statistics - Compressing file /usr/local/mysql/bin/myisampack: Error writing file
'/usr/local/mysql/tmp/intragenome_data.TMD' (Errcode: 28) /usr/local/mysql/bin/myisampack: Got error 0 reading records Aborting: /data1/mysql/Celegans_new/intragenome_data.MYD is not compressed ERROR: Compressing Celegans_new.intragenome_data failed, restoring old file. mv: cannot stat `intragenome_data.OLD': No such file or directory ERROR: Anyway, we have to continue and rebuild index even in case myisampack
failed. Celegans_new.intragenome_data: myisamchk -O sort_buffer_size=256M -O
key_buffer_size=512M -O read_buffer_size=8M -O write_buffer_size=8M -rq -f -a -S
--tmpdir=/usr/local/mysql/tmp /data1/mysql/Celegans_new/intragenome_data.MYI - check key delete-chain - check record delete-chain - recovering (with sort) MyISAM-table
'/data1/mysql/Celegans_new/intragenome_data.MYI' Data records: 20219 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 - Sorting index for MyISAM-table
'/data1/mysql/Celegans_new/intragenome_data.MYI'

Linux 2.4.19-pre1, 3.23.49a.