Hey,
1. We just installed a very large MySQL installation on a dual opteron 2ghz system with 16GB of memory and it -flies-. That's pretty subjective, so check:
http://www6.tomshardware.com/cpu/20030422/opteron-17.html http://www.infoworld.com/article/04/09/17/38FE64shootout2_1.html
Definately, go Opteron.
2. A 32-bit Linux distribution (ie, 32-bit kernel) is pretty much like running an Athlon XP processor (save for the perfformance increases of the Opteron chip). You don't get any 64-bit advantages. You definitely need a 64-bit kernel and 64-bit libraries to take advantage of the Opteron processor.
That said, 64-bit kernels come with 32-bit libraries usually, so you don't lose backwards compatibility, but simply gain 64-bit computing. Also, generally, 64-bit binaries compiled specifically for the opteron are faster than 32-bit code executed on the same opteron CPU.
64-bit Linux is pretty much everywhere. SuSE and RedHat ship a stable 64-bit distribution, though Debian 3.1 works great as well (i personally use Debian).
Once you have a 64-bit system setup, skies the limit, RAM wise.
Hope it helps,
Dylan
On 15-Dec-04, at 5:54 AM, Andreas Ahlenstorf wrote:
Hi!
It seems that I need to buy a 64bit server and have some questions regarding the two architectures from AMD (Opteron) and Intel (Xeon with EM64T).
Am I right if I say an Opteron based server is the better choice for MySQL because of the more advanced and faster bus system?
Is there anywhere a good benchmark out there where I could see the performance differences between the different architectures (PIII, P4, Xeon, Opteron etc.) when running MySQL?
How much memory could MySQL use on a 64 bit system running a 32 bit Linux distribution? Can I run MySQL in "64 bit mode"?
Thank you for your help!
Regards, A.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
smime.p7s
Description: S/MIME cryptographic signature
