On Wed, Jan 26, 2011 at 6:58 AM, Robinson, Eric <eric.robinson@stripped>wrote:
> > > You need to quiesce the InnoDb background threads. One technique is
> > > mentioned here:
> > > http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-tablesp
> > aces.html
> > >
> > > Look for the section talking about "clean" backups.
> > Now we're talkin. I'll check it out.
> I read that section but it is not at all clear (1) how one quiesces the
> InnoDB background threads, or (2) if there is a way to keep them
> quiesced while the backup is in progress.
From what I see there:
> You can make a clean backup .ibd file using the following method:
> Stop all activity from the
> *mysqld*<http://dev.mysql.com/doc/refman/5.5/en/mysqld.html>server and commit all
> Wait until SHOW ENGINE INNODB
> STATUS<http://dev.mysql.com/doc/refman/5.5/en/show-engine.html>shows that there are
> no active transactions in the database, and the main
> thread status of InnoDB is Waiting for server activity. Then you can
> make a copy of the .ibd file.
> I would assume that "flush tables with read lock" would work for 1. and
then you wait for 2. to happen. Probably shouldn't take very long,
especially in the quiet moments.
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel