Ed, I don't recall that being an issue, though you will likely need to tweak the values of your my.cnf file (thread_concurrency for example) to ensure you're taking advantage of all the cores.
This is highly dependent on your situation - but as you increase number of CPUs, where you may start to see an issue is with the other subsystems on your host, such as disk and network. This is really more an issue if you're serving many different kinds of data from the same physical server - with lots of CPUs, you have the power to crunch, but your disks and network may not be able to keep the CPUs fed. To generalize (a lot), 8 CPUs and highly varied databases could introduce this as a problem for you - in this situation I would really load it up on RAM and have some very fast disks (good guidelines for database servers anyway). If you are setting up more of a single-purpose database server, then you can take advantage of multiple CPUs serving from the same cached data. Pretty general but hopefully helpful. Another thoughts would be to buy 2 smaller physical servers instead of 1 big one, and use MySQL replication for redundancy and backups. Could do load-balancing as well but that can be tricky. Dan On 8/11/06, Ed Pauley II <[EMAIL PROTECTED]> wrote:
It seems like I once read that you don't get any performance gains in MySQL when you go above 4 CPUs per server. Is this correct? I was considering a 4 dual-core CPU machine. Should I go with a 2 dual-core machine instead? Thanks! -- Ed Pauley II -- 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]
