ZFSTuningGuide, MySQL on ZFS, zfs set sync=disabled question

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

ZFSTuningGuide, MySQL on ZFS, zfs set sync=disabled question

Dmitriy Makarov

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

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!
[hidden email] mailing list
To unsubscribe, send any mail to "[hidden email]"