If you do want to squeak out as much performance as you can, you should search on mysql G5 (or G4) compiler flags. This has been discussed before, but I'm not sure how much more performance you'll get over the default install.
http://archives.neohapsis.com/archives/mysql/2004-q2/0759.html
As for the compiler, you should probably just use the gcc compiler that comes with OS X, now shipping with v3.3 I think.
Keep in mind that you really won't be able to take advantage of the 64bit G5 until Apple ships Tiger in a few months. Tiger (10.4) is supposed to have pretty good support for 64 bit "faceless" applications like mysql. Which would mean you could assign more the 2GB for buffers and such. The current version (10.3) really only has some memory management routines tweaked for 64 bit.
On Feb 22, 2005, at 10:44 AM, Boyd E. Hemphill wrote:
I am considering the use of a new OS X machine with the Free BSD back end.
I would like answers to the following if anyone has the experience.
What switches should be set for compiling? I only need the Innodb storage
engine.
Which is the best compiler to use for MySQL on an Apple machine?
Best Regards,
Boyd E. Hemphill
WEST Project Manager
MySQL Certified Professional
[EMAIL PROTECTED]
Triand, Inc.
www.triand.com
O: (512) 248-2278 x 405
M: (512) 470-6146
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
