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]
