List:General Discussion« Previous MessageNext Message »
From:Chandru Date:December 4 2008 12:09pm
Subject:Re: Alter Table - InnoDB
View as plain text  
Hi jones,
  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
"innodb_file_per_table" option.
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.

Regards,
Chandru.
www.mafiree.com

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...
>
> Regards,
> 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
>> mysql.
>>
>> regards
>> anandkl
>>
>>
>> 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.
>>>
>>> Greets,
>>>       Jonas
>>>
>>>
>>
>
>
>  --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>

Thread
Alter Table - InnoDBJonas Genannt4 Dec
  • Re: Alter Table - InnoDBAnanda Kumar4 Dec
    • Re: Alter Table - InnoDBJonas Genannt4 Dec
      • Re: Alter Table - InnoDBAnanda Kumar4 Dec
        • Re: Alter Table - InnoDBShachi Govil4 Dec
          • Re: Alter Table - InnoDBJonas Genannt4 Dec
          • Re: Alter Table - InnoDBChandru4 Dec
            • RE: Alter Table - InnoDBRolando Edwards4 Dec
        • Re: Alter Table - InnoDBJonas Genannt4 Dec
  • Re: Alter Table - InnoDBMartijn Tonies4 Dec