Thanks for the reply, but in my case the datafile is growing 1 GB per day with only 1 DB (apart from mysql / information_schema / test) and the size of the DB is just 600MB, where records get updated / deleted / added and on an average it maintains 600MB only. Now the datafile is increased to 30GB from the past 30 days, do you have any idea how to reduce this ?
Also just wondering what does the datafile contains actually and why can't it gets decreased ? *thanks & regards, __________________* Kishore Kumar Vaishnav * * On Tue, May 22, 2012 at 1:40 PM, Claudio Nanni <claudio.na...@gmail.com>wrote: > 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 >> > >> > >> >
