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.
We use MySQL (exclusively InnoDB) on G5 XServes.
What switches should be set for compiling? I only need the Innodb storage
engine.
The MySQL installer or the MySQL binary without the GUI installer work very well. However, when we tried to increase memory assigned to InnoDB (specifically innodb_buffer_pool_size) we were unable to get past 1,536 MB (1.5 GB).
We then did a custom build using:
CC=gcc CFLAGS="-O3 -fno-omit-frame-pointer -mcpu=970 -mtune=970 -mpowerpc64 -mpowerpc-gpopt" CXX=gcc CXXFLAGS="-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mcpu=970 -mtune=970 -mpowerpc64 -mpowerpc-gpopt" ./configure --prefix=/usr/local/mysql --with-extra-charsets=complex --enable-thread-safe-client --enable-local-infile --disable-shared --with-innodb
This allowed us to startup MySQL fine with 2,048 MB assigned to innodb_buffer_pool_size (as someone else said it will take waiting for OS X 10.4 to get really large memory allocations to a single process).
This worked fine for the most part, but after the server had run for a couple of months (this is a reasonably large data set...110 GB, 247 qps, 70% of the queries are inserts/deletes/updates) we ran into a crash that appeared to be related to InnoDB actually using all of that memory. MySQL support looked into it and suggested that OS X is currently limited to 1.8GB in a single chunk.
At that point we reduced innodb_buffer_pool_size to 1.7 GB and the machine has been running almost 100 days without issue.
At this point the custom compile is only getting us about 200 MB extra for InnoDB, so I don't know if it's really worth it. However, it's been just as stable as the MySQL build was (we basically took the config command from MySQL's site and added Apple's suggested G5 switches) so there seems to be no harm.
Which is the best compiler to use for MySQL on an Apple machine?
We used gcc 3.3 that comes with the current developer tools/XTools.
Good luck, Ware Adams
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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
