From: Johan De Meersman Date: January 26 2011 11:29am Subject: Re: InnoDB and rsync List-Archive: http://lists.mysql.com/mysql/224232 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0015174c110a0633e6049abe27ea --0015174c110a0633e6049abe27ea Content-Type: text/plain; charset=ISO-8859-1 On Wed, Jan 26, 2011 at 6:58 AM, Robinson, Eric 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*server and commit all transactions. > 2. > > Wait until SHOW ENGINE INNODB STATUSshows 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 --0015174c110a0633e6049abe27ea--