From owner-freebsd-amd64@FreeBSD.ORG Sun Mar 7 16:32:08 2004 Return-Path: Delivered-To: freebsd-amd64@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id CF7A116A4CE for ; Sun, 7 Mar 2004 16:32:08 -0800 (PST) Received: from ojoink.com (unknown [216.65.123.180]) by mx1.FreeBSD.org (Postfix) with ESMTP id ADE7443D39 for ; Sun, 7 Mar 2004 16:32:08 -0800 (PST) (envelope-from amd64list@jpgsworld.com) Received: (qmail 871 invoked by uid 89); 8 Mar 2004 00:31:01 -0000 Received: from unknown (HELO MAINBX.jpgsworld.com) (amd64list@jpgsworld.com@67.172.167.223) by host180.ojoink.com with SMTP; 8 Mar 2004 00:31:01 -0000 Message-Id: <5.2.0.9.2.20040307162901.04125088@mail.ojoink.com> X-Sender: amd64list@jpgsworld.com@mail.ojoink.com X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9 Date: Sun, 07 Mar 2004 16:32:03 -0800 To: freebsd-amd64@freebsd.org From: JG In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Subject: RE: Best way to compile Mysql 4.1.x with Linuxthreads support on AMD64? X-BeenThere: freebsd-amd64@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting FreeBSD to the AMD64 platform List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 08 Mar 2004 00:32:08 -0000 At 07:43 AM 3/7/2004 -0500, you wrote: > >> I'm just not sure what the best way to compile it is. > >> How do you compile Mysql on AMD64? > >Kris Kennaway: > > cd /usr/ports/databases/mysql-server41-server; make > >As I recall, I just downloaded the current MySQL 4.1 sources from mysql.com >and built them. > >Running rock-solid for over a month in production use now: dual Opteron 242 >on a Tyan K8S Pro. I may have to try that next, as the port is still semi-broken: After installing mysql41-server from ports with SKIP_DNS_CHECK=yes and it won't start up... My mysql log output: 040307 15:22:33 mysqld started 040307 15:22:34 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 040307 15:22:34 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43634. InnoDB: Doing recovery: scanned up to log sequence number 0 43634 040307 15:22:34 InnoDB: Flushing modified pages from the buffer pool... 040307 15:22:34 InnoDB: Started; log sequence number 0 43634 040307 15:22:34 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 040307 15:22:34 mysqld ended I've looked on google a bit for this & it sounds like the system tables aren't being fully created or something. What a mess this is so far... but I'm very curious how this AMD64 Mysql box on FreeBSDwill stack up against Linux - so I will continue on till I get it all working - and then report the various benchmarks.