From: Johan De Meersman Date: April 21 2010 9:24am Subject: Re: better way to backup 50 Gig db? List-Archive: http://lists.mysql.com/mysql/221338 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016367d6fa4989c270484bbc4f3 --0016367d6fa4989c270484bbc4f3 Content-Type: text/plain; charset=ISO-8859-1 On Wed, Apr 21, 2010 at 10:50 AM, Claudio Nanni wrote: > Johan, > Is the fact that InnoDB ignores the command FLUSH TABLES WITH READ LOCK; > enough? :) > > InnoDB has buffers and activities going on even if you locked the tables > and you are not sure that its buffers are on the disk when you snapshot. > Again, you might be lucky and trust in the InnoDB recovery, what I state is > that there is only one 100% guaranteed safe way to have binary backups. > Aha, that's a tidbit I didn't know :-) It does hold back queries, but the engine doesn't stop it's maintenance threads. I tend to do a full dump with --single-transaction once a week, and copy the binlogs on the other days, though. That should suffice, I guess ? :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --0016367d6fa4989c270484bbc4f3--