Innodb does not release the space unless you optimize the tables. To dot
that you need to run dummy alter on all tables, by issuing "Alter table
<table name> engine=InnoDB"
but the space shall not regaing unless you start the table with
Then if you run the alter you shall gain space that was occupied.
But in your current scenario, there is space that is occupied that is not
shall not get released from OS even you run alter on the table. The space
shall be available in the table space "ibdata". If you have a option of
reimporting then take a dump, reimport the same with
"innodb_file_per_table" option enabled.
On Thu, Dec 4, 2008 at 4:19 PM, Shachi Govil <shachi.govil@stripped>wrote:
> I thought you always have to go to the physical location and delete the tmp
> files manually. These are created in tmp folder.
> I am not sure if restarting helps...
> Shachi Govil
> ----- Original Message ----- From: "Ananda Kumar" <anandkl@stripped>
> To: "Jonas Genannt" <jonasge@stripped>
> Cc: <mysql@stripped>
> Sent: Thursday, December 04, 2008 4:09 PM
> Subject: Re: Alter Table - InnoDB
> So, now u dont have free space in your file system.
>> Is this a production db.
>> I think, restarting the db, should not cause any harm. Which version of
>> On 12/4/08, Jonas Genannt <jonasge@stripped> wrote:
>>> Hi Ananda,
>>> > 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.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: