Author Topic: PHP-FPM high CPU and Mysqld  (Read 7080 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
PHP-FPM high CPU and Mysqld
« 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


Offline
*
Re: PHP-FPM high CPU and Mysqld
« Reply #2 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 ?

Offline
*****
Re: PHP-FPM high CPU and Mysqld
« Reply #3 on: May 31, 2019, 12:22:25 PM »
You need checking SQL queries (mysqladmin pr) and ask the website developer to optimize it
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: PHP-FPM high CPU and Mysqld
« Reply #4 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?!

Offline
***
Re: PHP-FPM high CPU and Mysqld
« Reply #5 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.

Offline
*****
Re: PHP-FPM high CPU and Mysqld
« Reply #6 on: June 01, 2019, 09:59:07 AM »
@leebrimlow
the command: mysqladmin pr will show to you the queries at the moment.
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services