On 04/21/2010 02:21 PM, Tom Worster wrote: > I'd go with the 4G 4-core server. If you're running apache and a sensible > OS, the extra cores can be helpful. So, unless you know you have a need for > very large key buffers, 4G should leave the OS plenty for FS cache. > > Not that I actually have a clue. I really just wanted to be the first to > answer the original question. >
Actually, Perrin already answered the question :) And now for my 2c. All other things being equal, I would opt for a more ram over a faster CPU. The extra ram can be used to reduce the load on the CPU through judicious caching and whatnot, but if I needed more CPU cycles to serve 60K pages, I'd be worried about how many more requests it would take to saturate the new CPU. In other words, I would gamble that extra ram would be sufficient. If I'm wrong, I'd have to address the underlying problem, but at least I would have more ram to work with when doing so. That being said, what does 4G vs. 8G comes to what/mo for a dedicated server? Say $30/g *4g * 1.25%(profit) = $150. And assuming a 12 month payback on the hardware, that would be $12.50ish/month more for the extra ram? -r -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org