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 > >