From: Claudio Nanni Date: May 22 2012 8:10am Subject: Re: Reducing ibdata1 file size List-Archive: http://lists.mysql.com/mysql/227477 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0015174bdf0698db3c04c09b8dfb --0015174bdf0698db3c04c09b8dfb Content-Type: text/plain; charset=ISO-8859-1 Kishore, No, as already explained, it is not possible, Innodb datafiles *never* shrink. Cheers Claudio On May 22, 2012 10:05 AM, "Kishore Vaishnav" wrote: > Hi, > > I understand that if I set the innodb_file_per_table then once the table > is drop the datafile will also be lost. But is there a way where I truncate > the table and the datafile shrinks itself ? > > *thanks & regards, > __________________* > Kishore Kumar Vaishnav > * > * > On Mon, May 21, 2012 at 6:43 PM, Johan De Meersman >wrote: > > > ----- Original Message ----- > > > From: "Manivannan S." > > > > > > How to reduce the ibdata1 file size in both LINUX and WINDOWS > > > machine. > > > > This is by design - you cannot reduce it, nor can you remove added > > datafiles. > > > > If you want to shrink the ibdata files, you must stop all connections to > > the server, take a full backup, stop the server, remove the datafiles > (and > > maybe change the config), restart the server (will take time to recreate > > emtpy datafiles) and then import the backup. > > > > For new tables, you can turn on the option innodb_file_per_table - then > > every (new) table gets it's own datafile; and when you drop the table, > that > > datafile also gets deleted. > > > > > > -- > > Bier met grenadyn > > Is als mosterd by den wyn > > Sy die't drinkt, is eene kwezel > > Hy die't drinkt, is ras een ezel > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql > > > > > --0015174bdf0698db3c04c09b8dfb--