Which processor is more productive for Linux, Nginx+Php-fpm, Mysql server?

Question

PHP

Actually, the question is, other things being equal, which of the following options will give the highest performance for a loaded LNMP server:
2x Intel Xeon E5620
AMD FX-8350
Intel Xeon E3-1230
If you believe www.passmark.com , then the performance will decrease in the same order as indicated processors. However, common sense dictates that passmark "raccoons" have little correlation with LNMP server performance.
The nature of the load is a lot of requests to nginx + php, constant multiple INSERTs in MYSQL, and periodic (but much less often than INSERTs), complex selects with joins. We believe that the disk subsystem and the amount of RAM are sufficient so as not to be a bottleneck.

Answer 1

I think it's better to use 2x Intel Xeon E5620 - in a larger number of CPU cores it's easier to shove a bunch of Apache\Nzhdinks threads that occur under heavy load. And using the desktop FX-8350 is generally a risky exercise - I don’t think that with this stone you can use ECC memory - and important things are not done without ECC.

Answer 2

You'll hit the disk anyway =)

Answer 3

Still, IMHO, no matter what the disk subsystem is, mysql will still bump into it with large insert volumes.
And I would initially think in this direction in terms of performance, i.e. I would think, for example, of two servers cheaper than one expensive one.
The nature of the load is generally incomprehensible, requests to nginx + php are also different, so it's not clear what you are doing there.

Answer 4

Whoever has more cores will give more.

Answer 5

What is worth it now? Focus on the number of physical cores when choosing! Collect statistics, balance
If you don't run into IO now, something is wrong ... M.b. software RAID, strong compression, or does everything work in one thread?