Say I have two servers, both with the same RAID 10 SSD HDD, 128GB Ram, etc.. I'm trying to figure out which server to get. There is a significant price difference between these two following setups, and I dont want to be paying about double the price for resources that may not be used by MySQL or would be technically a downgrade?
Server 1: Single Proc Intel Xeon E3-1270 v3 @ 3.50GHz with a Single Thread PassMark score of 2212
Server 2: Quad Core Intel Xeon E5-4650 @ 2.70GHz with a Single Thread PassMark score of 1483
Now the 4650 is significantly more expensive CPU because its a Quad Processor Octocore vs the 1270 which is Single Processor Quad Core. My gut tells me Server 2 is way way more powerful, but when looking at the performance of a Single Thread, Server 1 is actually significantly better.
That has me wondering, for MySQL performance should I be looking at only the single threaded performance, ie. chose Server 1 for a win-win? Or am I looking at this the wrong way?
EDIT: Additional info (which would be equal between Server 1 and 2)
1) CentOS 7 64Bit
2) One very large DB
3) Database is almost exclusively MyISAM