From owner-freebsd-ports@FreeBSD.ORG Tue Sep 16 19:08:00 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 B85C7106567D for ; Tue, 16 Sep 2008 19:08:00 +0000 (UTC) (envelope-from jdc@koitsu.dyndns.org) Received: from QMTA07.emeryville.ca.mail.comcast.net (qmta07.emeryville.ca.mail.comcast.net [76.96.30.64]) by mx1.freebsd.org (Postfix) with ESMTP id 9E4668FC2B for ; Tue, 16 Sep 2008 19:08:00 +0000 (UTC) (envelope-from jdc@koitsu.dyndns.org) Received: from OMTA03.emeryville.ca.mail.comcast.net ([76.96.30.27]) by QMTA07.emeryville.ca.mail.comcast.net with comcast id FNa71a0020b6N64A7X80Hj; Tue, 16 Sep 2008 19:08:00 +0000 Received: from koitsu.dyndns.org ([67.180.253.227]) by OMTA03.emeryville.ca.mail.comcast.net with comcast id FX7z1a0034v8bD78PX7zRK; Tue, 16 Sep 2008 19:07:59 +0000 X-Authority-Analysis: v=1.0 c=1 a=ieiUEHTuAmsA:10 a=0OlRnyv5FcYA:10 a=QycZ5dHgAAAA:8 a=GY1SmDZg4kCR5MyjZx0A:9 a=6VrSTo_BG1lhnAgEzU0A:7 a=2Q3Nnk14UkmX5Af5-7qQu9pCfnUA:4 a=EoioJ0NPDVgA:10 a=LY0hPdMaydYA:10 Received: by icarus.home.lan (Postfix, from userid 1000) id 01E5C17B81A; Tue, 16 Sep 2008 12:07:59 -0700 (PDT) Date: Tue, 16 Sep 2008 12:07:58 -0700 From: Jeremy Chadwick To: Morgan =?iso-8859-1?Q?Wesstr=F6m?= Message-ID: <20080916190758.GA71693@icarus.home.lan> References: <48D0000E.9050709@pp.dyndns.biz> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <48D0000E.9050709@pp.dyndns.biz> User-Agent: Mutt/1.5.18 (2008-05-17) Cc: freebsd-ports@freebsd.org Subject: Re: 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 19:08:00 -0000 On Tue, Sep 16, 2008 at 08:50:54PM +0200, Morgan Wesström wrote: > 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'm wondering why you're asking MySQL-specific questions on freebsd-ports. Questions I didn't answer should be punted to the MySQL folks, they're quite helpful. > I realized today actually that there are different storage engines > available for MySQL and that InnoDB seems to be preferred so I naturally First and foremost: I don't know where you got the idea that InnoDB is preferred. Whoever told you that is flat out wrong. You need to spend some more time reading up on the pros/cons to all of the MySQL storage engine types. InnoDB happens to be one of the most horrendous ones to deal with from an administrative point of view. It's always great when the InnoDB part is out of sync with /var/db/mysql/database/whatever.*, which can often happen during replication errors or bugs. My advice to people is to avoid InnoDB unless you *specifically* have engineered an application that will make use of it. MyISAM is a lot easier to deal with. > 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" Ignore that. I can tell you're flailing around with config files. :-) You can look at the compile-time defaults of InnoDB by using "SHOW VARIABLES", and performance using "SHOW STATUS". Please read the MySQL docs. > _First question:_ > Is InnoDB enabled by default regardless of the settings in my.cnf and > how can I verify it? It's enabled by default. Look at ports/databases/mysql51-server/Makefile; see WITHOUT_INNODB? If that's set (e.g. make WITHOUT_INNODB=true, or WITHOUT_INNODB=true in your /etc/make.conf), then the InnoDB storage engine will not be included. You can also disable InnoDB at runtime using mysqld --skip-innodb. If InnoDB stats are seen in "SHOW STATUS", then InnoDB is enabled. You can also try creating a table using the InnoDB storage engine type. The CREATE TABLE will fail if the engine is disabled or unavailable. > _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? None of what you've described (I snipped the portions out) are specific to the FreeBSD port. They are purely configuration issues, and are with MySQL. You should discuss your issues with the MySQL people. Cheers! -- | Jeremy Chadwick jdc at parodius.com | | Parodius Networking http://www.parodius.com/ | | UNIX Systems Administrator Mountain View, CA, USA | | Making life hard for others since 1977. PGP: 4BD6C0CB |