do u have one file per table or just one system tablespace datafile. On Tue, May 22, 2012 at 2:20 PM, Kishore Vaishnav <kish...@railsfactory.org>wrote:
> 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 > >> > > >> > > >> > > >