Control Web Panel

WebPanel => CentOS 7 Problems => Topic started by: leebrimlow on May 30, 2019, 09:33:39 AM

Title: PHP-FPM high CPU and Mysqld
Post by: leebrimlow on May 30, 2019, 09:33:39 AM

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

Title: Re: PHP-FPM high CPU and Mysqld
Post by: Sandeep on May 30, 2019, 08:21:36 PM

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/

Title: Re: PHP-FPM high CPU and Mysqld
Post by: leebrimlow on May 30, 2019, 08:51:57 PM

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 ?

Title: Re: PHP-FPM high CPU and Mysqld
Post by: Igor S. on May 31, 2019, 12:22:25 PM

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

Title: Re: PHP-FPM high CPU and Mysqld
Post by: leebrimlow on May 31, 2019, 12:50:41 PM

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

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

Title: Re: PHP-FPM high CPU and Mysqld
Post by: adamjedgar on May 31, 2019, 05:37:22 PM

 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.

Title: Re: PHP-FPM high CPU and Mysqld
Post by: Igor S. on June 01, 2019, 09:59:07 AM

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