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]