Author Topic: PHP-FPM high CPU and Mysqld  (Read 255 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
*****

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

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.