From owner-freebsd-ports@FreeBSD.ORG Tue Sep 16 18:50:58 2008 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 2FCE7106567C for ; Tue, 16 Sep 2008 18:50:58 +0000 (UTC) (envelope-from freebsd-ports@pp.dyndns.biz) Received: from proxy1.bredband.net (proxy1.bredband.net [195.54.101.71]) by mx1.freebsd.org (Postfix) with ESMTP id DD9A98FC24 for ; Tue, 16 Sep 2008 18:50:57 +0000 (UTC) (envelope-from freebsd-ports@pp.dyndns.biz) Received: from ironport.bredband.com (195.54.101.120) by proxy1.bredband.net (7.3.127) id 4811823A0256AD7A for freebsd-ports@freebsd.org; Tue, 16 Sep 2008 20:50:56 +0200 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AnIxALecz0hV4jrQPGdsb2JhbAAsgTeRHgEBAQEtp0CBZ4QZ Received: from c-d03ae255.107-1-64736c10.cust.bredbandsbolaget.se (HELO gatekeeper.pp.dyndns.biz) ([85.226.58.208]) by ironport1.bredband.com with ESMTP; 16 Sep 2008 20:50:56 +0200 Received: from [192.168.69.67] (phobos [192.168.69.67]) by gatekeeper.pp.dyndns.biz (8.14.2/8.14.2) with ESMTP id m8GIosUH096448 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Tue, 16 Sep 2008 20:50:55 +0200 (CEST) (envelope-from freebsd-ports@pp.dyndns.biz) Message-ID: <48D0000E.9050709@pp.dyndns.biz> Date: Tue, 16 Sep 2008 20:50:54 +0200 From: =?ISO-8859-1?Q?Morgan_Wesstr=F6m?= User-Agent: Thunderbird 2.0.0.16 (X11/20080805) MIME-Version: 1.0 To: freebsd-ports@freebsd.org Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: databases/mysql51-server and beginner's InnoDB questions X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 16 Sep 2008 18:50:58 -0000 # uname -a FreeBSD gatekeeper.pp.dyndns.biz 7.0-RELEASE-p4 FreeBSD 7.0-RELEASE-p4 #0: Thu Sep 4 10:58:01 CEST 2008 pp@gatekeeper.pp.dyndns.biz:/usr/obj/usr/src/sys/MYKERNEL amd64 # pkg_info | grep mysql-server mysql-server-5.1.26 Multithreaded SQL database (server) Dear list. I have a few questions regarding enabling InnoDB but I'm not an expert on MySQL so I'm not even sure I know how to ask them correctly. But the only way to learn is to ask and hope nobody is offended by stupid questions. :-) I realized today actually that there are different storage engines available for MySQL and that InnoDB seems to be preferred so I naturally wanted to use it. I can see with "show create table " that Mediawiki's tables for example are already created with ENGINE=InnoDB. But in my MySQL config file, which is simply a copy of my-large.cnf, there is a whole section for InnoDB that is commented out. It begins with: "# Uncomment the following if you are using InnoDB tables" _First question:_ Is InnoDB enabled by default regardless of the settings in my.cnf and how can I verify it? Assuming it wasn't enabled, despite the output from "show create table", I uncommented all the InnoDB options in my config and restarted MySQL and got the first error: "InnoDB: Error: log file /usr/local/var/db/mysql/ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 67108864 bytes!" I was able to work around this by changing innodb_log_file_size from the default 64M to 5M. _Second question:_ How can I increase the logfile size from it's original 5M to the 64M suggested in the config? Can I just delete the old logfile and have it recreated or will that break any of my databases? MySQL also complained about this: "[ERROR] /usr/local/libexec/mysqld: unknown variable 'innodb_log_arch_dir=/usr/local/var/db/mysql/'" After some googling I realized this was a deprecated variable and the reference to it in the config file should have been removed in 5.1.25. _Third question:_ Is this an issue with the FreeBSD port specifically? Should I report this to someone and how would I do that the correct way? Regards Morgan