"Aman Raheja" <[EMAIL PROTECTED]> wrote: > $ perror 28 > Error code 28: No space left on device > > I agree that there is not much disk space. > > THE ISSUE: I want to reclaim the disk space that should be freed because > of the millions of records I deleted. I need disk space to reclaim disk > space? Atleast that's what it seems to be.
When you delete records from MyISAM data file you only delete records. You don't physically empty the disk space they use. The OPTIMIZE TABLE operation works by making a temporary table. Of course it can be as big as the original table is (including index). So you can't OPTIMIZE TABLE if you don't have spare about 78+16G. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]