Page 1 of 1

High CPU usage of mysql

PostPosted:01 Jul 2018 15:53
by vpssim82
Hi VPSSIM,

how to fix high cpu usage because of mysql?

I'm using the last version of vpmsim
left is Contabo - 14 wp site
CPU: six cores
Intel® Xeon® E5-2620v3, E5-2630v4 or 4114 processor
24 GB RAM (guaranteed)
600 GB disk space (100% SSD)
100% SSD disk space

right is Nocix - 16 wp site
Dual Xeon 5520 240GB SSD Preconfig
2.26GHz - 2 processors
8 Cores / 16 threads
24GB DDR3
240GB SSD

Please help..

here is the screenshot : http://i.prntscr.com/fIrCfQQpSlGyPfKHw4yi7A.png

thank you

Re: High CPU usage of mysql

PostPosted:01 Jul 2018 16:24
by nguyenoanh
Wordpress blog using much cpu so that you need to use wordpress cache for them like wp super cahce or wp fastest cache.

Re: High CPU usage of mysql

PostPosted:01 Jul 2018 19:18
by vpssim82
Hi vpssim

All my site using wp super cache or wprocket, is there suggestion for me to optimize the mysql?

Re: High CPU usage of mysql

PostPosted:02 Jul 2018 14:27
by nguyenoanh
Increase RAM for Zend Opcache and do not use plugins you do not need them because PHP-FPM use to much CPU for 1 process.
And you can use MySQLTuner to optimize mysql.

Re: High CPU usage of mysql

PostPosted:10 Aug 2018 10:56
by ikankoi
did you use mysql query cache already @vpssim82 ?