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 <[EMAIL PROTECTED]>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" <[EMAIL PROTECTED]> > To: "Jonas Genannt" <[EMAIL PROTECTED]> > Cc: <mysql@lists.mysql.com> > 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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > >
