Date: Wed, 23 Nov 2016 22:00:22 +0100 From: Miroslav Lachman <000.fbsd@quip.cz> To: =?UTF-8?Q?Morgan_Wesstr=c3=b6m?= <freebsd-database@pp.dyndns.biz>, freebsd-database@freebsd.org Subject: Re: Need some further understanding of MariaDB/MySQL on ZFS Message-ID: <58360366.10609@quip.cz> In-Reply-To: <5835B6E9.9000004@pp.dyndns.biz> References: <5834C395.5080305@pp.dyndns.biz> <583554EE.8010304@quip.cz> <5835B6E9.9000004@pp.dyndns.biz>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?58360366.10609>