Re: Dual / Single CPU

[Mike Wexler]

Todd Burke wrote:

so mysql can take full advantage of the dual cpu w/out a recompile?

Mysql create a separate thread for each connection. So a single 
connection won't use more than one CPU. If you have lots of active 
connections, then yes, it will take advantage of the dual cpu without 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]