From owner-freebsd-performance@FreeBSD.ORG Fri Nov 18 10:40:56 2011 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 2CC2C106564A for ; Fri, 18 Nov 2011 10:40:56 +0000 (UTC) (envelope-from nec556@retena.com) Received: from resmaa12.ono.com (smtp12.ono.com [62.42.230.20]) by mx1.freebsd.org (Postfix) with ESMTP id B154D8FC17 for ; Fri, 18 Nov 2011 10:40:55 +0000 (UTC) Received: from GogPortatil.retena.com (95.20.141.54) by resmaa12.ono.com (8.5.113) (authenticated as nec556@retena.com) id 4EB899200026A45B for freebsd-performance@freebsd.org; Fri, 18 Nov 2011 11:40:53 +0100 Message-ID: <4EB899200026A45B@> (added by postmaster@resmaa12.ono.com) X-Mailer: QUALCOMM Windows Eudora Version 7.1.0.9 Date: Fri, 18 Nov 2011 11:40:49 +0100 To: freebsd-performance@freebsd.org From: Eduardo Morras In-Reply-To: References: <4ec60f6b.893a440a.4ce1.ffffa30dSMTPIN_ADDED@mx.google.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1"; format=flowed Content-Transfer-Encoding: quoted-printable X-Antivirus: AVG for E-mail 10.0.1411 [2092/4022] Subject: Re: ZFS Few Questions X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 18 Nov 2011 10:40:56 -0000 At 11:33 18/11/2011, Istv=C3=A1n wrote: >No problem for the most of the MySQL DBAs=20 >because consistency is not in their dictionary anyway :) I mean that surely db will be corrupted and=20 nothing could be recovered. I know postgresql and=20 there you have a begin snapshot - end snapshot=20 for this topic, data changes are stored in=20 temporal archives and main db files are=20 consistent, allowing you to make a filesystem snapshot. For mysql don't= know.=20