#1 edit the pho-fpm conf file
nano /etc/php/7.3/fpm/pool.d/www.conf
uncoment
pm.status /status
check for sytax errors & restart php fpm
sudo php7.3-fpm -t && sudo systemctl restart php7.3-fpm
#2 edit nginx default conf add this code
$ sudo nano /etc/nginx/conf.d/default.conf
location ~ ^/(status|ping)$ {
allow 127.0.0.1;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
fastcgi_index index.php;
include fastcgi_params;
#fastcgi_pass 127.0.0.1:9000;
fastcgi_pass unix:/var/run/php7.3-fpm.sock;
}
#3 restart nginx
$ sudo systemctl restart nginx
#4 check status page
ipadreess/status
domain/status
json,xml options ailabel to pull the data
#5 understanding php-fpm status page report
| pool | www |
|---|---|
| process manager | dynamic |
| start time | 14/Jul/2020:16:12:35 +0000 |
| start since | 43224 |
| accepted conn | 3384 |
| listen queue | 0 |
| max listen queue | 0 |
| listen queue len | 0 |
| idle processes | 2 |
| active processes | 1 |
| total processes | 3 |
| max active processes | 3 |
| max children reached | 0 |
| slow requests | 0 |
| pid | state | start time | start since | requests | request duration | request method | request uri | content length | user | script | last request cpu | last request memory |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12540 | Running | 15/Jul/2020:00:54:34 +0000 | 11905 | 325 | 173 | GET | /status?html&full | 0 | – | – | 0.00 | 0 |
| 14105 | Idle | 15/Jul/2020:02:36:26 +0000 | 5793 | 173 | 12818 | GET | /sqlc/js/get_image.js.php?theme=pmahomme&v=4.6.6deb5 | 0 | – | /var/www/html/sqlc/js/get_image.js.php | 78.02 | 2097152 |
| 16025 | Idle | 15/Jul/2020:03:40:03 +0000 | 1976 | 120 | 50279 | GET | /sqlc/js/messages.php?lang=en&db=&token=47acdd548eed288b1cfbbd1045c9c8c5&v=4.6.6deb5 | 0 | – | /var/www/html/sqlc/js/messages.php | 39.78 | 2097152 |
maxchidren reached
how many times php-fpm reached its limit.
if reached you can increase child process limits.
by cost memory.
max active processes:
total 5 severs.
3 process reached per seconds.(3 concurrent request per second)
most of wp pages servered by fastcgi cache nginx. or clouflare proxy.
mysql connections per seconds should higher than php-fpm max children per second.
also monitor nginxconnections per second With nginx stub status module (not in core)
#6 enable slow request in php-fpm
edit www.conf
threshold should be 1sec
slow query log path
un coment all
restart or reload php fpm
then you see slow queries in php fpm status page.