One of my clients needs to upgrade their current server (P4 3.0 with HT, 1GB RAM) to either a P4 3.4Ghz (w/ HT) or a Dual Xeon 2.4 - Both of the upgrade configurations have 2GB RAM. Which of the 2 upgrade options would be better for a server with a considerable amount of MySQL usage?
Why is he upgrading from the P4 3.0GHZ w/HT? If it's because of cpu usage, I don't think upping it up 400MHz would make it too much of a difference as he continues to grow. I would advise him to take the Dual Xeon 2.4GHz.
Well, since people seem to be recommending different solutions, perhaps you can tell us what the problem is, that is urging your customer to consider an upgrade? Are they running into problems with memory, CPU, load, etc.?
The issue is with the load for the most part. I know that a SCSI would be better than the IDE that's in there right now, but we're aiming for as little downtime as possible. The decision was made already - Dual Xeon 2.4. The extra kick is worth the price difference.