From owner-freebsd-database@freebsd.org  Sun Feb 12 19:13:11 2017
Return-Path: <owner-freebsd-database@freebsd.org>
Delivered-To: freebsd-database@mailman.ysv.freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org
 [IPv6:2001:1900:2254:206a::19:1])
 by mailman.ysv.freebsd.org (Postfix) with ESMTP id 96E58CDC0AB
 for <freebsd-database@mailman.ysv.freebsd.org>;
 Sun, 12 Feb 2017 19:13:11 +0000 (UTC)
 (envelope-from supportme@ukr.net)
Received: from frv197.fwdcdn.com (frv197.fwdcdn.com [212.42.77.197])
 (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits))
 (Client did not present a certificate)
 by mx1.freebsd.org (Postfix) with ESMTPS id 5BDC71131
 for <freebsd-database@freebsd.org>; Sun, 12 Feb 2017 19:13:11 +0000 (UTC)
 (envelope-from supportme@ukr.net)
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=ukr.net;
 s=ffe; h=Content-Transfer-Encoding:Content-Type:MIME-Version:Message-Id:To:
 Subject:From:Date:Sender:Reply-To:Cc:Content-ID:Content-Description:
 Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:
 In-Reply-To:References:List-Id:List-Help:List-Unsubscribe:List-Subscribe:
 List-Post:List-Owner:List-Archive;
 bh=IQcYNu6JIazOTRdMP4gA71CUWOAy31BqYtifFd7hprU=; b=DTPEf1gYzXC9HNIuIMmVVQyJ5W
 gvdZ8tkLsjYO/zcCBErttmm1XlPyIhS7dklzFfqgUZrW/P+uVKxiH71yXoUkXl3FIv7fd7ZV478H4
 NcBGfNRXzlohVpb9xYaPpmFLZsuEVJnSpuhe3xkiIPUzQX91Ed625y4z2ZG0qY9jJCRw=;
Received: from [10.10.10.41] (helo=frv41.fwdcdn.com)
 by frv197.fwdcdn.com with smtp ID 1ccza7-000Pv2-00
 for freebsd-database@freebsd.org; Sun, 12 Feb 2017 21:13:07 +0200
Date: Sun, 12 Feb 2017 21:13:06 +0200
From: Dmitriy Makarov <supportme@ukr.net>
Subject: ZFSTuningGuide, MySQL on ZFS, zfs set sync=disabled question
To: freebsd-database@freebsd.org
X-Mailer: mail.ukr.net 5.0
Message-Id: <1486921081.706105866.ct4tsp9m@frv41.fwdcdn.com>
Received: from supportme@ukr.net by frv41.fwdcdn.com;
 Sun, 12 Feb 2017 21:13:06 +0200
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: binary
Content-Disposition: inline
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.23
Precedence: list
List-Id: Database use and development under FreeBSD
 <freebsd-database.freebsd.org>
List-Unsubscribe: <https://lists.freebsd.org/mailman/options/freebsd-database>, 
 <mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database/>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <https://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
 <mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 12 Feb 2017 19:13:11 -0000

Hello,

reading https://wiki.freebsd.org/ZFSTuningGuide I found the tweak

* zfs set sync=disabled tank/db

but no tip/note/info about this decision, or warning.

Googling about disabling sync with MySQL got results with strong and reasonable advice do *not* disabling sync for databases like

http://list.zfsonlinux.org/pipermail/zfs-discuss/2015-February/021132.html
https://wiki.archlinux.org/index.php/ZFS#Database  ("never disable sync for a database!")

FreeBSD wiki recommended to sync=disable, is it related with some of FreeBSD ZFS extra-feature which is not present in other OS ZFS implementations?
Is it totally safe disabling sync for heavy loaded databases (for InnoDB-only MySQL), what side effects can occur (common and worst case) and why?

Thank You for detailed answer!