Date: Wed, 23 Nov 2016 09:50:17 +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: <58355849.6070501@quip.cz> In-Reply-To: <583554EE.8010304@quip.cz> References: <5834C395.5080305@pp.dyndns.biz> <583554EE.8010304@quip.cz>
next in thread | previous in thread | raw e-mail | index | archive | help
Miroslav Lachman wrote on 2016/11/23 09:35: > If you have innodb_file_per_table On, then all tables data are stored in > /var/db/mysql/databasename/ and only internal InnoDB data are stored in > /var/db/mysql/innodb/ib_data > > https://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_data_home_dir > > > The common part of the directory path for all InnoDB data files in the > *system tablespace*. This setting _does not affect the location of > file-per-table tablespaces when innodb_file_per_table is enabled_. The > default value is the MySQL data directory. If you specify the value as > an empty string, you can use absolute file paths in innodb_data_file_path. Just to say more - if you need file-per-table, then you can use 16K for /var/db/mysql too (and then you don't need separate /var/db/mysql/innodb) zroot/var/db/mysql recordsize=16K mount point /var/db/mysql * optional zroot/var/db/mysql/innodb recordsize=16K mount point /var/db/mysql/innodb zroot/var/db/mysql/innodb/logs recordsize=128K mount point /var/db/mysql/innodb/logs Or you can use your setup and set innodb_file_per_table = off in you my.cnf. Miroslav Lachman
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?58355849.6070501>