> so mysql can take full advantage of the dual cpu w/out a recompile? Your choice of OS will probably affect this as well.
Edward Dudlik Becoming Digital www.becomingdigital.com Did I help you? Want to show your thanks? www.amazon.com/o/registry/EGDXEBBWTYUU ----- Original Message ----- From: "Todd Burke" <[EMAIL PROTECTED]> To: "Mike Wexler" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, 30 June, 2003 18:00 Subject: Re: Dual / Single CPU so mysql can take full advantage of the dual cpu w/out a recompile? Thanks --Todd On Mon, 30 Jun 2003, Mike Wexler wrote: > > > Todd Burke wrote: > > >Which is the better option to host mysqld: > > > >MACHINE A: > > > > 2.4 GHz CPU > > 1024 MB Ram > > 2x 18 GB SCSI > > HDD RAID 1 > > > >MACHINE B: > > > > Dual Xeon > > 1.8 GHz CPU > > 1024 MB Ram > > 3x 18 GB SCSI > > HDD RAID 5 > > > > I would recommend using RAID 1 for MySQL not RAID 5. When doing lots of > random access it is generally faster. Otherwise it really depends on > your application mix. The first will probably be quicker if you > generally have one larger query backing things up. The latter will be > better if you generally have lots of queries going on. Although if you > are disk bound, it won't matter much. It really depends on your > application mix and the transaction load. If the machines aren't heavily > loaded, than it doesn't matter at all. If the machines are heavily > loaded, you might want to consider more RAM. > > > > >In other words will mysql benefit from the dual cpu? > > > >These boxes will be used mostly as readers (delayed inserts done thru > >replication). > > > >Thanks > >-- Todd > > > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]