MySQL consuming a lot of CPU I’m having trouble with a new server. I installed the optimized configuration for Ubuntu server with EasyEngine of VirtuBox.

When migrating my website with template newspaper, the CPU consumption is very high.

Here is a mysql tuner report.







MySQL tuner result:



I have a database with more than 400 thousand posts. My server is:


Intel Core i7-6700K CPU
HDD 250 GB SSD
RAM 16 GB DDR4-2133 PC4-17000


with easyengine + rediscache + wordpress.

With little access the consumption of CPU is a load average: 7.56, 3.43, 4.81.

Thank you in advance for your attention.
Use persistent connections, cpu will drop dramatically. Then check slow queries.