Xeon mysql performance

[kwerk]

Does anyone know how these 2 CPUs would compare on a dedicated mysqld server?

Xeon Quadcore E3-1270 v2 3.5ghz
8M cache
4 cores, 8 threads

vs

Dual CPU six-core Xeon E5-2620 2ghz
15M cache
2x 6 cores, 12 threads

The first is what i currently use and it is nearly maxed out on the CPU. The second set up would cost 3x the price, but I want to know how much better it would work as a database server.

If the first was running at say 75% cpu load what would the equivalent percent be on the second set up?

 

[kwerk]

If you're not maxing out the E3-1270 why would you need a dual Xeon setup?

Your question is probably far too specific for anyone to give you an accurate answer.

It is maxing out the E3 during peak time.

 

[kwerk]

Well I was wondering if it's as simple as 8x 3.5ghz vs 24 x 2ghz. I'm not up to speed on cores and threads and everything. No disk access is involved. The db queries would be spread over the cores/threads. So if now 8x 3.5G threads hit 80% on all of them, on the new one 24x 2G threads would hit 50% at the same load, roughly speaking?

This is what it looks like half of the time

Cpu0  : 59.7%us,  0.3%sy,  0.0%ni, 37.6%id,  2.3%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu1  : 75.9%us,  0.3%sy,  0.0%ni, 23.4%id,  0.3%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu2  : 70.3%us,  0.7%sy,  0.0%ni, 26.3%id,  2.3%wa,  0.0%hi,  0.3%si,  0.0%st
Cpu3  : 74.5%us,  0.7%sy,  0.0%ni, 24.2%id,  0.0%wa,  0.0%hi,  0.7%si,  0.0%st
Cpu4  : 52.2%us,  0.3%sy,  0.0%ni, 47.5%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu5  : 69.3%us,  0.3%sy,  0.0%ni, 29.3%id,  1.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu6  : 68.8%us,  0.7%sy,  0.0%ni, 30.2%id,  0.0%wa,  0.0%hi,  0.3%si,  0.0%st
Cpu7  : 67.9%us,  0.7%sy,  0.0%ni, 31.1%id,  0.0%wa,  0.0%hi,  0.3%si,  0.0%st