What is the maximum number of cores?

Hello, I am doing a stress test using a 96 cores cpu, but Percona 5.7 only uses 48 cores which have a 100% consumption. Are there any settings to change this behavior?

Does any version of mysql support more than 48 cores?

If you’re hitting a limit at 48 it’s likely to be something other than Percona Server for MySQL that’s causing it e.g. configuration, IO…

Although this article by Peter Zaitsev is about MySQL 8.0, it could be a useful read about benchmarking and might give you some insights into your test scenarios. https://www.percona.com/blog/2016/12/02/make-mysql-8-0-better-better-benchmarking/

This might be useful too https://www.percona.com/blog/2016/03/17/percona-server-5-7-performance-improvements/

There’s also an offsite discussion here that could help: https://dba.stackexchange.com/questions/5666/possible-to-make-mysql-use-more-than-one-core

Take a look at those, and if you have a follow up question after considering what they say in those, please don’t hesitate to return… Though we can’t analyze your specific environment but we can answer generally applicable questions e.g. about configuration parameters and such.

Hope this helps?