Thanks for your reply Brent. It was really useful. Looks like Opteron would be a good choice since there wont be several multiple queries at the same time but instead we will be happy if the single query runs fast. You had mentioned adding more RAM would help, how much RAM would be ideal ? Does the operating system and MySQL will be able to utilize all the RAM available? Regarding hard drives you mentioned SCSI drives in RAID set up, I was looking at 15000 rpm scsi drives (thats what the max rpm i could find), does these has to be in RAID 0 setup ? if so how many drives do you think would be good. Our data will not exceed 75 - 100 Gig.
Thanks again Karthik --- Brent Baisley <[EMAIL PROTECTED]> wrote: > Tough question since a lot of performance is > dependent on how you > structure your queries, your database design and > indexing. > 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 > > __________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
