MySQL consuming a lot of CPU

MySQLsysdba

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.

enter image description here

enter image description here

enter image description here

MySQL tuner result:

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.

Best Answer

Use persistent connections, cpu will drop dramatically. Then check slow queries.

Related Question