But, going with what you provided...
You have big tables, so you will want lots of RAM. That means a 64bit system like Opteron, Itanium or PowerPC based (ok and Xeon). PowerPC would mean running Linux or AIX, OSX won't really take advantage of 64bit until 10.4.
If your queries are going to be scanning big chunks of the tables, the data won't be cached, so you want very fast disks setup in a RAID. SCSI or Fibrechannel would be good.
Are you going to be having lots of simultaneous queries or sequential big queries? Opteron will give you better throughput, but Xeon will be better at multitasking (i.e. simultaneous queries). Opteron has it's own memory controller, so if you have a lot of calculations you'll be doing in RAM, that would be an excellent chip because of it's bandwidth between CPU and RAM.
If money is no object, a Power5 (PowerPC) based system can scale pretty high, going well beyond dual or quad processors in a single box.
On Jan 23, 2005, at 12:12 PM, why me wrote:
We are looking for buying a new server for running MySQL database. The database is around 50-70G and individual tables run to 5 - 15 GB. There wont be any frequent updates instead we need maximum select performance. There will be multiple table joins to perform our query. I hope your experience will help us find a suitable server for our need. Information on what hardware to use including how many computers, processor, ram, hard drive spec would be helpful. Budget is not a constrain but performance (select) need to be high. I have heard MySQL is the best for fast and large selects, but is it worth looking at other database like Oracle?
Thanks TM
__________________________________ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. http://info.mail.yahoo.com/mail_250
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- 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]
