We are planning to use this server for storing MySQL database for our game and website (which runs phpBB forums and several other modules). We won't be hosting Apache or php web content itself on this server for now. Though later on during peak load, we can consider using this server as our load balance client and it can host php content or at least static content.
Server FSB Cache (MB) Cache Type RAM (GB)
Core i5 Quad Core I5-750 2.66GHz 4.8 GT/s 8 L3 8
Core i7 Quad Core I7-860 2.8GHz 2.5 GT/s 8 L3 8
2x Xeon Quad Core E5506 2.13GHz 4.8 GT/s 4 L3 4
2x Xeon Quad Core E5506 2.13GHz 4.8 GT/s 4 L3 8
Xeon Quad Core E5405 2.0 GHz 1333 MHz 8 L2 8
Xeon Quad Core E5405 2.0 GHz 1333 MHz 8 L2 12
Xeon Quad Core E5405 2.0 GHz 1333 MHz 8 L2 16
Xeon Quad Core E5410 2.33 GHz 1333 MHz 8 L2 8
Xeon Quad Core E5410 2.33 GHz 1333 MHz 8 L2 12
Xeon Quad Core E5410 2.33 GHz 1333 MHz 8 L2 16
Xeon Quad Core X3440 2.53GHz 2.5 GT/s 8 L3 8
Somewhere I read that performance of Core i7 - 860 is almost equal to 4x Intel Xeon MP 7040 and higher than 2 x Intel Xeon 5150/5000P . So that means Core i7 is much better than Xeon ? But internet search shows posts from forums which suggests Xeon is specially built for servers and better. So thats little confusing.
So please suggest technically which option is much better for above mentioned requirements. Looking forward for your reply.
If the server is going to be running continuously, go with a server processor.
If the server needs to be fast, but just for a few hours per day, you can use a Core processor instead.
The above information is my own opinion, not Intel's, and doesn't imply any warranty or anything like that. Just what I've found after years of usage.