From: Martijn Tonies
Date: December 4 2008 11:23am
Subject: Re: Alter Table - InnoDB
List-Archive: http://lists.mysql.com/mysql/215466
Message-Id: <01b001c95602$aa4b3a70$9c02a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

Hi,

>> Since u have cancled the job, those in-complete temp files can be
>> deleted from the file system.
> 
> ok - but I'm using InnoDB. The IBdata file is bumped up. There are no
> temp files on the database directory.

What's the problem with a larger ibdata-file? If the index is dropped,
there is free space inside the file that will be re-used.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

FREE Database Workbench Lite for MySQL at the above website!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com