From owner-freebsd-database@freebsd.org Tue Nov 22 22:44:54 2016 Return-Path: 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 4E076C4FF36 for ; Tue, 22 Nov 2016 22:44:54 +0000 (UTC) (envelope-from freebsd-database@pp.dyndns.biz) Received: from smtprelay-h31.telenor.se (smtprelay-h31.telenor.se [213.150.131.4]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 10D1A10C9 for ; Tue, 22 Nov 2016 22:44:53 +0000 (UTC) (envelope-from freebsd-database@pp.dyndns.biz) Received: from ipb2.telenor.se (ipb2.telenor.se [195.54.127.165]) by smtprelay-h31.telenor.se (Postfix) with ESMTP id A70F3D62F for ; Tue, 22 Nov 2016 23:15:52 +0100 (CET) X-SENDER-IP: [85.226.59.81] X-LISTENER: [smtp.bredband.net] X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: A2BMOQDbwjRYEFE74lVdHAEBFgEBBQEBgx0OAQEBAQEfgRA6hwOzO4EdGIgiQxEBAgEBAQEBAQEGAQEBAQEBAjdFhRIPAQUeIjYCBRYLAgsDAgECARsMCicIAQGIbQGfd498gimMA4ELgSaNGmKCOIJdBZpOgUmZOYYnkXI0aCIKCzKCWAyCQD2IQAEBAQ X-IPAS-Result: A2BMOQDbwjRYEFE74lVdHAEBFgEBBQEBgx0OAQEBAQEfgRA6hwOzO4EdGIgiQxEBAgEBAQEBAQEGAQEBAQEBAjdFhRIPAQUeIjYCBRYLAgsDAgECARsMCicIAQGIbQGfd498gimMA4ELgSaNGmKCOIJdBZpOgUmZOYYnkXI0aCIKCzKCWAyCQD2IQAEBAQ X-IronPort-AV: E=Sophos;i="5.31,682,1473112800"; d="scan'208";a="867167747" Received: from c-513be255.107-1-64736c12.cust.bredbandsbolaget.se (HELO gatekeeper.pp.dyndns.biz) ([85.226.59.81]) by ipb2.telenor.se with ESMTP; 22 Nov 2016 23:15:51 +0100 Received: from [192.168.69.70] ([192.168.69.70]) by gatekeeper.pp.dyndns.biz (8.15.2/8.15.2) with ESMTPS id uAMMFnmh023805 (version=TLSv1.2 cipher=DHE-RSA-AES128-SHA bits=128 verify=NO) for ; Tue, 22 Nov 2016 23:15:50 +0100 (CET) (envelope-from freebsd-database@pp.dyndns.biz) To: freebsd-database@freebsd.org From: =?UTF-8?Q?Morgan_Wesstr=c3=b6m?= Subject: Need some further understanding of MariaDB/MySQL on ZFS Message-ID: <5834C395.5080305@pp.dyndns.biz> Date: Tue, 22 Nov 2016 23:15:49 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.6.0 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 22 Nov 2016 22:44:54 -0000 Hi list, first time poster here but long time FreeBSD user. I'm migrating my FreeBSD based home router to FreeBSD 11 and ZFS on root. This also includes moving my MariaDB databases to ZFS. I've studied the wiki guide as well as several other sources on this subject and I understand the complex interaction between ZFS and the internal InnoDB and MyISAM database structures. I've created the following datasets: zroot/var/db/mysql recordsize=8K mount point /var/db/mysql 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 My my.cnf contains (among others) these lines to move InnoDB databases to the correct folders: innodb_data_home_dir = /var/db/mysql/innodb innodb_log_group_home_dir = /var/db/mysql/innodb/logs When I start the server the first time the InnoDB folders are correctly populated with some default files like innodb/ibdata1 and innodb/logs/ib_logfile0. But as soon as I create a new database (foo) with InnoDB tables, the server creates a /var/db/mysql/foo folder and populates it with ibd and frm files whereas I would've expected it to create it as /var/db/mysql/innodb/foo to inherit the correct 16K recordsize. Is this correct? Shouldn't it be created under /var/db/mysql/innodb? Have I missed some vital configuration option? Kind Regards Morgan Wesström From owner-freebsd-database@freebsd.org Wed Nov 23 08:36:10 2016 Return-Path: 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 3D50EC517CC for ; Wed, 23 Nov 2016 08:36:10 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from elsa.codelab.cz (elsa.codelab.cz [94.124.105.4]) (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 02A74197 for ; Wed, 23 Nov 2016 08:36:09 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from elsa.codelab.cz (localhost [127.0.0.1]) by elsa.codelab.cz (Postfix) with ESMTP id B18CC28450; Wed, 23 Nov 2016 09:36:00 +0100 (CET) Received: from illbsd.quip.test (ip-86-49-16-209.net.upcbroadband.cz [86.49.16.209]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by elsa.codelab.cz (Postfix) with ESMTPSA id C053B28460; Wed, 23 Nov 2016 09:35:58 +0100 (CET) Subject: Re: Need some further understanding of MariaDB/MySQL on ZFS To: =?UTF-8?Q?Morgan_Wesstr=c3=b6m?= , freebsd-database@freebsd.org References: <5834C395.5080305@pp.dyndns.biz> From: Miroslav Lachman <000.fbsd@quip.cz> Message-ID: <583554EE.8010304@quip.cz> Date: Wed, 23 Nov 2016 09:35:58 +0100 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:42.0) Gecko/20100101 Firefox/42.0 SeaMonkey/2.39 MIME-Version: 1.0 In-Reply-To: <5834C395.5080305@pp.dyndns.biz> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 23 Nov 2016 08:36:10 -0000 Morgan Wesström wrote on 2016/11/22 23:15: > innodb_data_home_dir = /var/db/mysql/innodb > innodb_log_group_home_dir = /var/db/mysql/innodb/logs > > When I start the server the first time the InnoDB folders are correctly > populated with some default files like innodb/ibdata1 and > innodb/logs/ib_logfile0. But as soon as I create a new database (foo) > with InnoDB tables, the server creates a /var/db/mysql/foo folder and > populates it with ibd and frm files whereas I would've expected it to > create it as /var/db/mysql/innodb/foo to inherit the correct 16K > recordsize. > > Is this correct? Shouldn't it be created under /var/db/mysql/innodb? > Have I missed some vital configuration option? I don't think it works the way you are expecting. If you have innodb_file_per_table Off, then all InnoDB / XtraDB tables are stored in ib_data file(s) in innodb_data_home_dir = /var/db/mysql/innodb But some metadata (frm files) are stored in /var/db/mysql/databasename/ 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. Miroslav Lachman From owner-freebsd-database@freebsd.org Wed Nov 23 08:50:20 2016 Return-Path: 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 A2C98C51BD4 for ; Wed, 23 Nov 2016 08:50:20 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from elsa.codelab.cz (elsa.codelab.cz [94.124.105.4]) (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 66DBA9D7 for ; Wed, 23 Nov 2016 08:50:19 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from elsa.codelab.cz (localhost [127.0.0.1]) by elsa.codelab.cz (Postfix) with ESMTP id 49FA728451; Wed, 23 Nov 2016 09:50:18 +0100 (CET) Received: from illbsd.quip.test (ip-86-49-16-209.net.upcbroadband.cz [86.49.16.209]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by elsa.codelab.cz (Postfix) with ESMTPSA id 38F3028462; Wed, 23 Nov 2016 09:50:17 +0100 (CET) Subject: Re: Need some further understanding of MariaDB/MySQL on ZFS To: =?UTF-8?Q?Morgan_Wesstr=c3=b6m?= , freebsd-database@freebsd.org References: <5834C395.5080305@pp.dyndns.biz> <583554EE.8010304@quip.cz> From: Miroslav Lachman <000.fbsd@quip.cz> Message-ID: <58355849.6070501@quip.cz> Date: Wed, 23 Nov 2016 09:50:17 +0100 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:42.0) Gecko/20100101 Firefox/42.0 SeaMonkey/2.39 MIME-Version: 1.0 In-Reply-To: <583554EE.8010304@quip.cz> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 23 Nov 2016 08:50:20 -0000 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 From owner-freebsd-database@freebsd.org Wed Nov 23 15:58:33 2016 Return-Path: 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 52170C519A7 for ; Wed, 23 Nov 2016 15:58:33 +0000 (UTC) (envelope-from freebsd-database@pp.dyndns.biz) Received: from smtprelay-b11.telenor.se (smtprelay-b11.telenor.se [62.127.194.20]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 0CB749C6 for ; Wed, 23 Nov 2016 15:58:32 +0000 (UTC) (envelope-from freebsd-database@pp.dyndns.biz) Received: from ipb4.telenor.se (ipb4.telenor.se [195.54.127.167]) by smtprelay-b11.telenor.se (Postfix) with ESMTP id B0D23EA555 for ; Wed, 23 Nov 2016 16:34:22 +0100 (CET) X-SENDER-IP: [85.226.59.81] X-LISTENER: [smtp.bredband.net] X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: A2CqEQC/tjVYEFE74lVeHAEFAQsBgzkBAQEBAR9YgQKkWpRzggcohXkCghtCEgECAQEBAQEBAQYBAQEBAQECN0WEaQEBBCMPAQUeIhELGAICBRYLAgIJAwIBAgEbDAoUEwgBAYhtAQmudIIpi2YBCwEfBYELgSaIaIQzFkyCOIJdBZpPhkeUQIYqjWqEDCUJbiMLC4VdPTQBAYhDAQEB X-IPAS-Result: A2CqEQC/tjVYEFE74lVeHAEFAQsBgzkBAQEBAR9YgQKkWpRzggcohXkCghtCEgECAQEBAQEBAQYBAQEBAQECN0WEaQEBBCMPAQUeIhELGAICBRYLAgIJAwIBAgEbDAoUEwgBAYhtAQmudIIpi2YBCwEfBYELgSaIaIQzFkyCOIJdBZpPhkeUQIYqjWqEDCUJbiMLC4VdPTQBAYhDAQEB X-IronPort-AV: E=Sophos;i="5.31,538,1473112800"; d="scan'208";a="614069857" Received: from c-513be255.107-1-64736c12.cust.bredbandsbolaget.se (HELO gatekeeper.pp.dyndns.biz) ([85.226.59.81]) by ipb4.telenor.se with ESMTP; 23 Nov 2016 16:34:04 +0100 Received: from [192.168.69.70] ([192.168.69.70]) by gatekeeper.pp.dyndns.biz (8.15.2/8.15.2) with ESMTPS id uANFY1Nm028988 (version=TLSv1.2 cipher=DHE-RSA-AES128-SHA bits=128 verify=NO) for ; Wed, 23 Nov 2016 16:34:03 +0100 (CET) (envelope-from freebsd-database@pp.dyndns.biz) Subject: Re: Need some further understanding of MariaDB/MySQL on ZFS To: freebsd-database@freebsd.org References: <5834C395.5080305@pp.dyndns.biz> <583554EE.8010304@quip.cz> From: =?UTF-8?Q?Morgan_Wesstr=c3=b6m?= Message-ID: <5835B6E9.9000004@pp.dyndns.biz> Date: Wed, 23 Nov 2016 16:34:01 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.6.0 MIME-Version: 1.0 In-Reply-To: <583554EE.8010304@quip.cz> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 23 Nov 2016 15:58:33 -0000 On 2016-11-23 09:35, Miroslav Lachman wrote: > Morgan Wesström wrote on 2016/11/22 23:15: > >> innodb_data_home_dir = /var/db/mysql/innodb >> innodb_log_group_home_dir = /var/db/mysql/innodb/logs >> >> When I start the server the first time the InnoDB folders are correctly >> populated with some default files like innodb/ibdata1 and >> innodb/logs/ib_logfile0. But as soon as I create a new database (foo) >> with InnoDB tables, the server creates a /var/db/mysql/foo folder and >> populates it with ibd and frm files whereas I would've expected it to >> create it as /var/db/mysql/innodb/foo to inherit the correct 16K >> recordsize. >> >> Is this correct? Shouldn't it be created under /var/db/mysql/innodb? >> Have I missed some vital configuration option? > > I don't think it works the way you are expecting. > > If you have innodb_file_per_table Off, then all InnoDB / XtraDB tables > are stored in ib_data file(s) in innodb_data_home_dir = > /var/db/mysql/innodb > But some metadata (frm files) are stored in /var/db/mysql/databasename/ > > 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 > 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. Personally I'm reluctant to change default values unless I have a very good reason to do so, so I will try to find a way to adapt to it. Your suggestion to put the whole of /var/db/mysql on a 16K recordsize (except for the logs directory) is probably the way to go. I just need to delve a little bit further into the subject before I make up my mind. Thank you again for pointing me in the right direction. Morgan From owner-freebsd-database@freebsd.org Wed Nov 23 16:45:02 2016 Return-Path: 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 944EEC51905 for ; Wed, 23 Nov 2016 16:45:02 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from elsa.codelab.cz (elsa.codelab.cz [94.124.105.4]) (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 57DE718D9 for ; Wed, 23 Nov 2016 16:45:01 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from elsa.codelab.cz (localhost [127.0.0.1]) by elsa.codelab.cz (Postfix) with ESMTP id B11162846D; Wed, 23 Nov 2016 17:44:58 +0100 (CET) Received: from illbsd.quip.test (ip-86-49-16-209.net.upcbroadband.cz [86.49.16.209]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by elsa.codelab.cz (Postfix) with ESMTPSA id DBB7E28450; Wed, 23 Nov 2016 17:44:56 +0100 (CET) Subject: Re: Need some further understanding of MariaDB/MySQL on ZFS To: =?UTF-8?Q?Morgan_Wesstr=c3=b6m?= , freebsd-database@freebsd.org References: <5834C395.5080305@pp.dyndns.biz> <583554EE.8010304@quip.cz> <5835B6E9.9000004@pp.dyndns.biz> From: Miroslav Lachman <000.fbsd@quip.cz> Message-ID: <5835C788.6090601@quip.cz> Date: Wed, 23 Nov 2016 17:44:56 +0100 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:42.0) Gecko/20100101 Firefox/42.0 SeaMonkey/2.39 MIME-Version: 1.0 In-Reply-To: <5835B6E9.9000004@pp.dyndns.biz> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 23 Nov 2016 16:45:02 -0000 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 yes, the default value was changed from Off to On > 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'll take a look on this and prepare some update. > I assume this change > could interfere with people running production systems on ZFS. > Personally I'm reluctant to change default values unless I have a very > good reason to do so, so I will try to find a way to adapt to it. Your > suggestion to put the whole of /var/db/mysql on a 16K recordsize (except > for the logs directory) is probably the way to go. I just need to delve > a little bit further into the subject before I make up my mind. Thank > you again for pointing me in the right direction. innodb_file_per_table = off means that all tables from all databases are in one big file. It has some advantages - faster access, less opened file descriptors... but some disadvantage too - ibdata file can grow but will not shrink if you delete some data from tables / drop tables. It can be a big problem on huge databases with a lot of writes (UPDATE, DELETE, INSERT). We converted few of our DB servers to innodb_file_per_table = On few years ago. innodb_file_per_table = On is better for our type of workload on almost all our machines but your workload can be different and you can benefit from innodb_file_per_table = Off. So you need to test or guess what is better for your setup. Good luck Miroslav Lachman From owner-freebsd-database@freebsd.org Wed Nov 23 21:00:28 2016 Return-Path: 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 297A9C51EBA for ; Wed, 23 Nov 2016 21:00:28 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from elsa.codelab.cz (elsa.codelab.cz [94.124.105.4]) (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 E3D947E7 for ; Wed, 23 Nov 2016 21:00:27 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from elsa.codelab.cz (localhost [127.0.0.1]) by elsa.codelab.cz (Postfix) with ESMTP id 9480328469; Wed, 23 Nov 2016 22:00:24 +0100 (CET) Received: from illbsd.quip.test (ip-86-49-16-209.net.upcbroadband.cz [86.49.16.209]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by elsa.codelab.cz (Postfix) with ESMTPSA id 534B528470; Wed, 23 Nov 2016 22:00:23 +0100 (CET) Subject: Re: Need some further understanding of MariaDB/MySQL on ZFS To: =?UTF-8?Q?Morgan_Wesstr=c3=b6m?= , freebsd-database@freebsd.org References: <5834C395.5080305@pp.dyndns.biz> <583554EE.8010304@quip.cz> <5835B6E9.9000004@pp.dyndns.biz> From: Miroslav Lachman <000.fbsd@quip.cz> Message-ID: <58360366.10609@quip.cz> Date: Wed, 23 Nov 2016 22:00:22 +0100 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:42.0) Gecko/20100101 Firefox/42.0 SeaMonkey/2.39 MIME-Version: 1.0 In-Reply-To: <5835B6E9.9000004@pp.dyndns.biz> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 23 Nov 2016 21:00:28 -0000 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 From owner-freebsd-database@freebsd.org Thu Nov 24 02:40:14 2016 Return-Path: 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 82EA5C5248B for ; Thu, 24 Nov 2016 02:40:14 +0000 (UTC) (envelope-from products@computerdistributors.co.za) Received: from mailman.ysv.freebsd.org (unknown [127.0.1.3]) by mx1.freebsd.org (Postfix) with ESMTP id 6D9B391C for ; Thu, 24 Nov 2016 02:40:14 +0000 (UTC) (envelope-from products@computerdistributors.co.za) Received: by mailman.ysv.freebsd.org (Postfix) id 6D090C5248A; Thu, 24 Nov 2016 02:40:14 +0000 (UTC) Delivered-To: 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 6CB04C52489 for ; Thu, 24 Nov 2016 02:40:14 +0000 (UTC) (envelope-from products@computerdistributors.co.za) Received: from furthermoreincsales.co.za (static-ip-188-138-82-156.inaddr.ip-pool.com [188.138.82.156]) by mx1.freebsd.org (Postfix) with ESMTP id 19C2E91B for ; Thu, 24 Nov 2016 02:40:12 +0000 (UTC) (envelope-from products@computerdistributors.co.za) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; s=mail; d=furthermoreincsales.co.za; h=Date:Message-ID:From:To:Subject:MIME-Version:Content-Type; i=postmaster@furthermoreincsales.co.za; bh=VF7OAsIoSjhUOvDa6a4W4Z7j598=; b=oGJ10D4pcd1Jd9WO0TSc/lxvLea5He7Kd5Cu/pp2Z9gWIOUf4IV1L6wo7ypPz5ncRmbK3uJhRnRH AqiPu++5SoSxCY6CPxuoCPp/kovw+s5pQ/E9jcozO9yMl38+6J4vyW6UTNfougUrZbzmxg+qqJiR eOFxD3d0a5xuVIqUJ2s= Received: from Wearable (196.215.129.131) by furthermoreincsales.co.za id h6p9gs0001gq for ; Thu, 24 Nov 2016 03:40:11 +0100 (envelope-from ) Date: Thu, 24 Nov 2016 04:40:01 +0200 Message-ID: <201611244401826AMUNIQUEID@EMAILPC-PC> From: products@computerdistributors.co.za To: database@freebsd.org Subject: Wearable Imaging - Recording Sunglasses - SALE 20 % DISCOUNT Valid Till FRIDAY 25 NOVEMBER - R999 (WAS R1250) X-Mailer: AutoMSW (www.automsw.com) ID: 194315 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.23 X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 24 Nov 2016 02:40:14 -0000 WEARABLE IMAGING =96 ONLY R999 Recording Sunglasses = Sleek and elegant design high quality UV sunglasses with a built-in spy ca= mera recorder. Record live video with audio just by wearing your glasses. Never miss another moment. Store all you video on a SD Card and transfer to you PC with ease. Discrete recording =96 no one will know you are recording anything. User-friendly operation buttons for easy control. SPECS = Video Format: AVI Video Resolution: 720 x 480 Picture Format: JPEG Picture Resolution: 2560 x 1920 Built-in Memory: 4GB Frame Rate: 30fps Supporting System: Windows 2000 / ME / XP/ 7 / VISTA USB jack: for data transfer and charging Battery: Built-in high capacity lithium battery Color: Black Net Weight: 69g / 2.43 oz Dimension (L x W): 170 x 160 mm / 6.69 x 6.30 inch USB Cable Length: 59cm / 23.23 inch Contents: 1 x 4GB DVR Eyewear 1 x USB Cable 1 x English Manual 1 x Protective Box 1 x Cleaning Cloth Email us today for more information or to purchase or call us on 021 903 0= 501 Please call us if you do not get a response to your email within 2hrs, as = sometimes the emails do not reach us. Brand new sealed in box Delivery to your door via courier or collection can be arranged. Why am I receiving this message? 1. =A0You subscribed on one of our many related websites 2. =A0A friend has forwarded you this message 3. =A0You have had previous communications with one of our linked websites= . =A0 Eg. You have requested quotes/bookings/info regarding related products fro= m us How do I Unsubscribe? Reply to this e-mail with the word "Unsubscribe"