From: Eric Robinson Date: January 26 2011 5:58am Subject: RE: InnoDB and rsync List-Archive: http://lists.mysql.com/mysql/224231 Message-Id: <768FEA3F936926468F594E3CA7741FE802A8CA36@ipa-vault.nvipa.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable > > You need to quiesce the InnoDb background threads. One technique is=20 > > mentioned here: > > http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-tablesp > aces.html > >=20 > > Look for the section talking about "clean" backups. >=20 > Now we're talkin. I'll check it out. >=20 >=20 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. Disclaimer - January 25, 2011=20 This email and any files transmitted with it are confidential and = intended solely for Robinson, Eric,Shawn Green (MySQL),Reindl = Harald,mysql@stripped. If you are not the named addressee you = should not disseminate, distribute, copy or alter this email. Any views = or opinions presented in this email are solely those of the author and = might not represent those of Physicians' Managed Care or Physician = Select Management. Warning: Although Physicians' Managed Care or = Physician Select Management has taken reasonable precautions to ensure = no viruses are present in this email, the company cannot accept = responsibility for any loss or damage arising from the use of this email = or attachments.=20 This disclaimer was added by Policy Patrol: http://www.policypatrol.com/