Date: Sun, 07 Mar 2004 16:32:03 -0800 From: JG <amd64list@jpgsworld.com> To: freebsd-amd64@freebsd.org Subject: RE: Best way to compile Mysql 4.1.x with Linuxthreads support on AMD64? Message-ID: <5.2.0.9.2.20040307162901.04125088@mail.ojoink.com> In-Reply-To: <B1D77424948FD611A3B80000C0109EEF024FB986@SYNCRO>
next in thread | previous in thread | raw e-mail | index | archive | help
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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?5.2.0.9.2.20040307162901.04125088>