On Wed, Apr 21, 2010 at 10:50 AM, Claudio Nanni <claudio.na...@gmail.com>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
