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.nanni@stripped>wrote:
> No, as already explained, it is not possible, Innodb datafiles *never*
> On May 22, 2012 10:05 AM, "Kishore Vaishnav" <kishore@stripped>
>> 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
>> the table and the datafile shrinks itself ?
>> *thanks & regards,
>> Kishore Kumar Vaishnav
>> On Mon, May 21, 2012 at 6:43 PM, Johan De Meersman <vegivamp@stripped
>> > ----- Original Message -----
>> > > From: "Manivannan S." <manivannan_s@stripped>
>> > >
>> > > 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
>> > 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,
>> > 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