PHP-FPM high CPU and Mysqld

[leebrimlow]

can you please help me to know what is the best configuration for php-fpm and mysql .

My VPS specs:

Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz
Ram : 8 G
Disk: 150 G SSD

Apache version: Apache/2.4.39
PHP version: 5.6.21
MySQL version: 10.1.40-MariaDB

i have only one user

i attached a photo of live monitor , where there was only 30 visitor on my sites at the same time , and the stats doesn't change if they are 30 or 300 .

Photo : https://imgur.com/4Nn3TIL

[Sandeep]

hi you can lower the load by using memcached or redis
for wordpress tutorial :
https://www.mysterydata.com/configure-and-speedup-wordpress-with-memcached-on-php-7/
https://www.mysterydata.com/speedup-wordpress-decrease-server-load-redis-cache-cwp-centos-webpanel/

[leebrimlow]

unfortunately nothing changed, is it normal that mysqld time looks like that in the photo : https://imgur.com/NmEa9mr


i have these performance issues in PhpMyAdmin Advisor in this photo : https://imgur.com/Lj7Yoqm

i fix them but when i restart Mysql every thing became the same. how can i make these changes to still in mysql settings ?

[Igor S.]

You need checking SQL queries (mysqladmin pr) and ask the website developer to optimize it

[leebrimlow]

i am using wordpress , and publishing posts nearly one post every five minutes.

how can i check SQL queries (mysqladmin pr) please?!

[adamjedgar]

 Why are you still running php 5.6 and not upgrading to php 7.3?

That memcached plugin I note had php7 in its url.

[Igor S.]

@leebrimlow
the command: mysqladmin pr will show to you the queries at the moment.