On Wed, Jan 26, 2011 at 6:58 AM, Robinson, Eric <eric.robin...@psmnv.com>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