From owner-freebsd-database@FreeBSD.ORG Mon Sep 11 07:12:59 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 052A116A417 for ; Mon, 11 Sep 2006 07:12:59 +0000 (UTC) (envelope-from smithi@nimnet.asn.au) Received: from gaia.nimnet.asn.au (nimbin.lnk.telstra.net [139.130.45.143]) by mx1.FreeBSD.org (Postfix) with ESMTP id DE21143D5E for ; Mon, 11 Sep 2006 07:12:55 +0000 (GMT) (envelope-from smithi@nimnet.asn.au) Received: from localhost (smithi@localhost) by gaia.nimnet.asn.au (8.8.8/8.8.8R1.4) with SMTP id RAA21483; Mon, 11 Sep 2006 17:12:38 +1000 (EST) (envelope-from smithi@nimnet.asn.au) Date: Mon, 11 Sep 2006 17:12:37 +1000 (EST) From: Ian Smith To: Matt Hartzell In-Reply-To: <4504DB9B.4040602@getdts.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Cc: FreeBSD-Database Subject: Re: MySQL: show status problem. X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 11 Sep 2006 07:12:59 -0000 On Sun, 10 Sep 2006, Matt Hartzell wrote: > Is there a my.cnf in /usr/local/mysql ? How about a .my.cnf in your home > directory? > > Have you looked into the order that mysql processes the different config > files locations? Good questions. Just to add a bit .. > e.stewart@mac.com wrote: > > I've recently installed MySQL 5.0.24 on my FreeBSD by building mysql > > from the ports directory. > > > > It installed fine and I initialized mysql and secured up the root > > passwords. > > > > Because mysql is using /var/db/mysql as it's default data directory > > (and I wanted to use /usr/local/mysql instead), I moved the > > /var/db/mysql directory to /usr/local/mysql and then added the > > mysql_dbdir="/usr/local/mysql/" to the rc.conf file under > > mysql_enable="YES". That should be fine, but I also tend to add a symlink from /var/db/mysql to /usr/local/mysql just to be sure if 'something' assumes the default dir. Also I assume that mysql wasn't running when you moved its data? > > Everything seem was working fine. I can log in and use mysql. > > > > I then copied one of the example mysql configuration files to > > /usr/local/etc/my.cnf and then restarted mysql. MySQL starts up just > > fine but I can't run the "SHOW STATUS" command. It just sits there and > > acts like its doing something but never does. > > > > I know the problem is related to my my.cnf file because when I run > > mysql without that configuration file, show status works just fine. > > > > Below is the contents of my configuration file, any idea what might be > > screwing this up? I know very little, but did notice that you say InnoDB only .. > > #BEGIN CONFIG INFO > > #DESCR: 4GB RAM, InnoDB only, ACID, few connections, heavy queries > > #TYPE: SYSTEM > > #END CONFIG INFO > > > > # > > # This is a MySQL example config file for systems with 4GB of memory > > # running mostly MySQL using InnoDB only tables and performing complex > > # queries with few connections. > > # > > # You can copy this file to /etc/my.cnf to set global options, > > # mysql-data-dir/my.cnf to set server-specific options > > # (/var/db/mysql for this installation) or to > > # ~/.my.cnf to set user-specific options. .. but then have: > > # Table type which is used by default when creating new tables, if not > > # specified differently during the CREATE TABLE statement. > > default_table_type = MYISAM ? Cheers, Ian