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

Reply via email to