Kishore, No, as already explained, it is not possible, Innodb datafiles *never* shrink.
Cheers Claudio On May 22, 2012 10:05 AM, "Kishore Vaishnav" <kish...@railsfactory.org> 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 <vegiv...@tuxera.be > >wrote: > > > ----- Original Message ----- > > > From: "Manivannan S." <manivanna...@spanservices.com> > > > > > > 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 > > > > >