The mysql documentation says that mysql performs far better for heavy queries using 64bit. I assume, also, that the new memory limits also help if you allow mysql to take advantage of them, as I have read in some recent ML entries. (which is not 8GB, btw,but 16GB according to the tech docs... 2GB sticks are just not really 'normal' yet.)
I am trying to move a client with a very heavy load off a current linux box (Dual Athlon, Dual U160) to use a Dual G5 2Ghz as a primary server (3G currently, 5G shortly), using the linux box as a backup&slave machine and for offloading mail and other services, and providing a hot rollover function. His site produces huge amounts of load currently, mostly due to large amounts of queries/page and large amounts of concurrent users.
Some info I found below, and I was wondering what would be the best config to try to compile mysql with to produce the best results.
http://developer.apple.com/technotes/tn/tn2087.html ... "Take advantage of the full precision hardware square root
The G5 has a full-precision hardware square root implementation. If your code executes square root, check for the availability of the hardware square root in the G5 and execute code calling the instruction directly (e.g. __fsqrt()) instead of calling the sqrt() routine. (Use __fsqrts() for single-precision.) You can use the GCC compiler flags-mpowerpc-gpopt and -mpowerpc64 to transform sqrt() function calls directly into the PPC sqrt instruction.
Align hot code for maximum instruction dispatch
Alignment of code in memory is a more significant factor for performance on the G5 than on the G4. The G5 fetches instructions in aligned 32 byte blocks. Therefore, it is often profitable to align hot loops, branches, or branch targets to fetch boundaries. GCC 3.3 offers the following flags to align code: -falign-functions=32, -falign-labels=32,-falign-loops=32, -falign-jumps=32. Additionally, you may need to specify -falign-[functions, labels, loops, jumps]-max-skip=[15,31] to get the desired alignment."
...
I assume that adding -mpowerpc-gpopt and -mpowerpc64 to the gcc compiler will generally format the code towards the g5 and 64bit.. then again, I do not know much about compiling past using configure and make ;)
I need it to be the fastest model, using the least resources but be stable... able to handle as many requests/sec as possible. Sort of a "High Performance" fork of the Apache2/php/mysql set. Mysql being the most important. ;)
-- Adam Goldstein White Wolf Networks http://whitewlf.net
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
