Need some further understanding of MariaDB/MySQL on ZFS

Wed Nov 23 21:00:28 UTC 2016

Morgan Wesström wrote on 2016/11/23 16:34:

> Thank you Miroslav, this was the vital piece of information I needed. It
> seems MySQL changed the default value of innodb_file_per_table from 0 to
> 1 with version 5.6.
> https://dev.mysql.com/doc/refman/5.6/en/server-default-changes.html
>
> The parameter isn't mentioned in any of the online ZFS/MySQL wikis or
> blogs that I've found, not even FreeBSD's own wiki. I assume this change
> could interfere with people running production systems on ZFS.

I added note to FreeBSD ZFS Tuning page: 
https://wiki.freebsd.org/ZFSTuningGuide

Miroslav Lachman