MySQL8 – more cores vs higher cpu frequency?

All we need is an easy explanation of the problem, so here it is.

Do you know any benchmarks which compare both cases? What is better?

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

First, look at your workload.

If you will have only one process running at a time, then only 1 core is used.

If you could have thousands of processes running "simultaneously", don’t. Don’t even benchmark more than 64 threads. Figure out how many your application will realistically receive, and limit the benchmarking to that. I’m not talking about threads that are sitting idle; they don’t count. Beyond about 64, MySQL stumbles over itself; throughput stalls; latency increases. Very few big production systems have more than a few dozen threads ever active (not Sleep) at the same time, even if they are cranking out thousands of ‘queries per second’.

In both scenarios, CPU clock speed is more important.

But, much more important than clock speed is optimizing the query and the schema, especially the indexes.

Also important: Disk speed. Use SSD for high traffic.

Amount of RAM — not useful to go past twice the size of the data.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply