On Tue, Sep 28, 2010 at 6:24 PM, Jan Steinman <Jan@stripped> wrote:
> > From: "Jangita" <jangita@stripped>
> > I do not think there is anything wrong with having one huge file is
> There is if you're doing incremental back-ups, in which case adding one
> byte to that file costs you 50GB of backup space.
That is only true if you're backing up on the FS level, which means you have
to quiesce the database first. The better/easier way to do incremental mysql
backups is by grabbing the closed binlog files; the downside to that is of
course that replaying those takes more time than restoring the datafile.
That being said, I don't know wether InnoDB files don't get updated metadata
even if no DML happens in them.
> You don't have to take insults personally. You can sidestep negative
> energy; you can look for the good in others and utilize that good, as
> different as it may be, to improve your point of view and to enlarge your
> perspective. -- Stephen R. Covey
> :::: Jan Steinman, EcoReality Co-op ::::
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel