Best way to compile Mysql 4.1.x with Linuxthreads support on AMD64?

[JG]

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.