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

[Mark Sergeant]

On Mon, 2004-03-08 at 10:32, JG wrote:
> 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.
> 
> 

There is a known bug with mysql4.x, amd64 and innodb. If you can avoid
using innodb then you shouldn't have any problems.


> 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.
> 
> 
> 
> _______________________________________________
> freebsd-amd64 at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-amd64
> To unsubscribe, send any mail to "freebsd-amd64-unsubscribe at freebsd.org"
-- 
Mark Sergeant <msergeant at snsonline.net>
SNSOnline Technical Services
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: This is a digitally signed message part
Url : http://lists.freebsd.org/pipermail/freebsd-amd64/attachments/20040308/ea44d5e8/attachment.bin