Lace...
I have a customer with this problem as well. Wordpress is just killing the CPU.
We had to move the database to a dedicated SQL server and leave http on another.
The SQL server is doing alright but the webserver is being killed with load.
For comparison:
WebServer Specs:
Xeon 3.4Ghz
4GB DDR RAM
73GB SCSI 10K
Database Server:
Core2Quad Q6600
2GB DDR2 RAM
250GB SATA2
he IS running wp-cache already and it IS working. While the database is handling the load, it still has rather high load.
http load is high on the webserver.
MySQL traffic between the web server and the db server does about 200Mbps. thats a lot of crappy sql traffic
Wordpress sux
