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:
>
> 1.
>
> Stop all activity from the
> *mysqld*<http://dev.mysql.com/doc/refman/5.5/en/mysqld.html>server and commit all
> transactions.
> 2.
>
> 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
