From: Kishore Vaishnav Date: May 22 2012 8:04am Subject: Re: Reducing ibdata1 file size List-Archive: http://lists.mysql.com/mysql/227476 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=00151773d75cfebf8604c09b7924 --00151773d75cfebf8604c09b7924 Content-Type: text/plain; charset=ISO-8859-1 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 > > --00151773d75cfebf8604c09b7924--