Centos 7 X operating system
Two hosts, respectively, 5.6 installation, one of them and upgrade from 5.6 to 8.0.11
Use the TOP command to see
In version 5.6 is basically CPU is not more than 10%

After upgrading to 8, the server CPU is a very strange, so long as has the SQL to come in, instantly soared to 150% - 180%, then quickly fall into 10% less than

Does mysql after upgrading to 8 more fully use the CPU?

Want to know whether the mysql after upgrading to 8 what related configuration is optimized to need

I know is that the mysql upgrade to 8 cancelled query_cache_size and query_cache_type these two configuration, is it because the SQL results in no cache, cause the CPU usage is too high, could you please tell me is there any way to solve the

CPU always jumped to 180% in the mind very worried, thank you