modify PHP-FPM config customization

taker18

taker18

Verified User
Joined
Oct 18, 2021
Messages
151
Location
USA
I have 64G ram Server 8 core, but my but i have one of my site is very large and heavy, and all the times the admin site is extremely sluggish

this is my PHP-FPM config customization

./data/users/admin/php/php-fpm83.conf​


  2. [admin]
  3. user = $pool
  4. group = $pool
  5. listen = /usr/local/php83/sockets/$pool.sock
  6. listen.owner = $pool
  7. listen.group = apache
  8. listen.mode = 660
  9. pm = ondemand
  10. pm.max_children = 10
  11. pm.process_idle_timeout = 20
  12. pm.max_requests = 500


    Now I am convinced that I shouldn't switch pm = Ondemand to Dynamic, it should stay the same as Ondemand ok fine.
    but what about the rest

    pm.max_children = 10
    pm.process_idle_timeout = 20
    pm.max_requests = 500

    in fact some recommendation to add
    pm.max_children = 60
    pm.start_servers = 6
    pm.min_spare_servers = 4
    pm.max_spare_servers = 10


    any recommendation I want to change pm.max_children = 60 (increase it more than the default 10)
    Thank you
 
this is my Top

Code: 
Top:
Tasks:
CPU(s):
KiB Mem:
KiB Swap:
21:16:48 up 251 days, 13:55, 0 users, load average: 0.32, 0.37, 0.36
320 total, 2 running, 318 sleeping, 0 stopped, 0 zombie
0.0 us, 0.4 sy, 0.0 ni, 99.6 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st
63707.6 total, 1821.3 free, 3795.3 used, 58809.0 buff/cache
32735.0 total, 32477.5 free, 257.5 used. 59912.3 avail Mem
 
taker18 said:
the admin site is extremely sluggish
Click to expand...

That can be caused by a bunch of reasons. You might enable slow logs in PHP-FPM and see what is causing issues. Common reasons:

1. too slow SQL queries
2. requests to remote services, sites
3. operations with images (re-sizing, converting, etc)
 
As has been mentioned there can be many causes for performance issues, withought knowing more about your site, possibly what framework it is running, it is hard to give specific recomendations.

But, I have found that slow PHP sites are often related more to other factors than just throwing more PHP processes at the problem.

1) Needing more memory for the php process. Can be increased in most cases by creating a ".user.ini" in the root of the website (in public_html) and set a specific memory limit say "memory_limit = 512M", example if your running WordPress with WooCommerce I would make that at least 1024M, don't forget to also edit the WordPress config memory limit also (define('WP_MEMORY_LIMIT', '512M');)

2) Mysql table optimisation, add missing indexes, etc.. If you have a really large database then it would be a good idea to do some optimization of Mysql itself, a tool like MySQLTuner can help with this ( https://github.com/major/MySQLTuner-perl ), as with any tool, only use what it says to change as a guide, double check what it is suggesting.

3) If there are a lot of files in the website that get loaded the speed of the file system can become a factor. Hopefully your running on NVMe drives where this is really not as much of an issue, but if your running on SATA SSD or spinning disks this can really help. If many files get opened on every page load the update of the file access time can become a factor on EXT4 file systems, you can adjust the fstab and add the option "lazytime" to delay writing out to disk the the last access times to reduce the amount of writes.

4) Check your Swappiness, personally I set mine to 1, so swapping doesn't happen untill i'm almost OOM. If swapping is occuring it will slow things down.

5) If running WordPress watch out the number of plugins that you use, try to keep it to a minimum. Some visual editors can cause performance issues (ie: Elementor), also increase the PHP memory limit more if you are using one it can help. If your not using a cache plugin it would be a good idea (Surge is a basic one that works well).

6) Almost forgot, if you have Resource Limits set for the user running the website, make sure they are high enough.

These are just some suggestions that may be able to help with performance. More information would be required to find and fix the exact root cause for your site(s).
 
7.) Check your logfiles and server-status (if apache) for malicious bot visits. We had issues with bot attacks not identifying as bots, but also normal bots.
 
Zhenyapan said:
Check your php-log is it asking to raise children count? because your TOP shows there no load at all
Click to expand...
well now I remember used to get that warning an email when i add some stages sites. but when I removed it it disappeared but now when i :
but today when I checked with
: sudo tail -n 50 /var/log/php-fpm83.log
came out with

[01-Nov-2025 13:30:49] WARNING: [pool admin] server reached max_children setting (10), consider raising it


[01-Nov-2025 14:19:23] WARNING: [pool admin] server reached max_children setting (10), consider raising it


[01-Nov-2025 16:26:09] WARNING: [pool admin] server reached max_children setting (10), consider raising it


[01-Nov-2025 18:36:27] WARNING: [pool admin] server reached max_children setting (10), consider raising it
Click to expand...


cjd said:
As has been mentioned there can be many causes for performance issues, withought knowing more about your site, possibly what framework it is running, it is hard to give specific recomendations.

But, I have found that slow PHP sites are often related more to other factors than just throwing more PHP processes at the problem.

1) Needing more memory for the php process. Can be increased in most cases by creating a ".user.ini" in the root of the website (in public_html) and set a specific memory limit say "memory_limit = 512M", example if your running WordPress with WooCommerce I would make that at least 1024M, don't forget to also edit the WordPress config memory limit also (define('WP_MEMORY_LIMIT', '512M');)
Click to expand...
I already have user.ini long time a go with enough researchers and added memory for front end and admin on wp-config.php as well.
cjd said:
2) Mysql table optimisation, add missing indexes, etc.. If you have a really large database then it would be a good idea to do some optimization of Mysql itself, a tool like MySQLTuner can help with this ( https://github.com/major/MySQLTuner-perl ), as with any tool, only use what it says to change as a guide, double check what it is suggesting.
Click to expand...
would be nice to use it for sure.
cjd said:
4) Check your Swappiness, personally I set mine to 1, so swapping doesn't happen untill i'm almost OOM. If swapping is occuring it will slow things down.

5) If running WordPress watch out the number of plugins that you use, try to keep it to a minimum. Some visual editors can cause performance issues (ie: Elementor), also increase the PHP memory limit more if you are using one it can help. If your not using a cache plugin it would be a good idea (Surge is a basic one that works well).
Click to expand...
I am using Litespeed Cache plugin
cjd said:
6) Almost forgot, if you have Resource Limits set for the user running the website, make sure they are high enough.
Click to expand...
no resources restriction, all the site are as admin they have full access to resources
Richard G said:
7.) Check your logfiles and server-status (if apache) for malicious bot visits. We had issues with bot attacks not identifying as bots, but also normal bots.
Click to expand...


used command : tail -n 100 /var/log/httpd/access_log


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /wp-admin/maint/maint.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /classwithtostring.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /dropdown.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /moon.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /0x.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /moon.php?p= HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /autoload_classmap.php?p= HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /inputs.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /default.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /fm.php?p= HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /fm.php?fm=true HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /about.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /file.php? HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /alfa.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /buy.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /themes/twentytwentytwo/index.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /wp-admin/js/wp-conflg.php?p= HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /wp-admin/wp-conflg.php?p= HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /wp-admin/css/wp-conflg.php?p= HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /manager.php?p= HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /js/fm.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /item.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /plugins/Cache/footer.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:38 -0500] "GET /404.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /mail.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /wp-content/plugins/index.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /sx.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /wp-admin/maint/admin.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /article.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /alfa.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /1.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /403.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /link.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /byp.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /bak.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /ini.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /ws.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /wp-trackback.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /.well-known/index.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /wp-includes/certificates/plugins.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /wp-content/themes/seotheme/mar.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /wp-admin/network/plugins.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /wp-admin/about.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /gmo.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /wp-includes/ID3/about.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /css/index.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /wp-admin/includes/xmrlpc.php?p= HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /wp-includes/SimplePie/wp-login.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /wp-content/themes/about.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /filemanager/dialog.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /wp-admin/maint/index.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /wp-includes/Requests/Text/admin.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /wp-includes/customize/about.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /index/function.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /uploads/autoload_classmap.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /wp-includes/css/dist/preferences/wp-login.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:39 -0500] "GET /wp-includes/style-engine/about.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /.well-known/acme-challenge/mariju.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /about/function.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /wp-includes/theme-compat/chosen.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /admin/function.php HTTP/1.1" 404 481 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /.well-known/acme-challenge/index.php HTTP/1.1" 404 248 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /css/colors/blue/index.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /wp-content/plugins/pwnd/as.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /wp-admin/setup-config.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /wp-admin/user/about.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /wp-admin/js/index.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /wp-content/upgrade/about.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /wp-includes/assets/index.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /wp-content/radio.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /wp-includes/fonts/index.php?p= HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /.well-known/gecko-litespeed.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /.well-known/admin.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /wp-content/admin.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /wp-content/plugins/admin.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /wp-content/themes/twentytwentytwo/index.php?p= HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /.well-known/log.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /class.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /bless.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /wp-includes/js/codemirror/index.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /wp-includes/block-patterns/index.php HTTP/1.1" 404 462 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /lock360.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /bge.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /ifm.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /thxt.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /kairolin.php HTTP/1.1" 404 210 "-" "-"


52.169.206.229 - - [01/Nov/2025:20:59:40 -0500] "GET /siln.php HTTP/1.1" 404 210 "-" "-"


94.74.191.2 - - [01/Nov/2025:21:00:13 -0500] "GET /cgi-bin/luci/;stok=/locale HTTP/1.1" 404 481 "-" "-"


45.157.54.29 - - [01/Nov/2025:21:02:03 -0500] "POST /xmlrpc.php HTTP/2.0" 404 138 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36"


45.157.54.29 - - [01/Nov/2025:21:02:03 -0500] "POST /xmlrpc.php HTTP/2.0" 404 138 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36"


2001:4ca0:108:42::24 - - [01/Nov/2025:21:02:22 -0500] "GET /robots.txt HTTP/2.0" 404 395 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.134 Safari/537.36"


188.116.22.80 - - [01/Nov/2025:21:09:49 -0500] "GET / HTTP/1.1" 200 3334 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0"


37.27.51.142 - - [01/Nov/2025:21:15:18 -0500] "GET /robots.txt HTTP/2.0" 404 395 "-" "Mozilla/5.0 (compatible; SERankingBacklinksBot/1.0; +https://seranking.com/backlinks-crawler)"


167.71.110.14 - - [01/Nov/2025:21:19:07 -0500] "SSTP_DUPLEX_POST /sra_{BA195980-CD49-458b-9E23-C84EE0ADCD75}/ HTTP/1.1" 400 3404 "-" "-"


34.229.46.27 - - [01/Nov/2025:21:26:46 -0500] "GET /robots.txt HTTP/2.0" 404 395 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36"


78.153.140.50 - - [01/Nov/2025:21:26:59 -0500] "GET /.env HTTP/1.1" 403 3427 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.5845.140 Safari/537.36"


78.153.140.50 - - [01/Nov/2025:21:26:59 -0500] "POST / HTTP/1.1" 200 3386 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.5845.140 Safari/537.36"


64.227.97.195 - - [01/Nov/2025:21:28:12 -0500] "" 400 394 "-" "-"


18.205.127.11 - - [01/Nov/2025:21:29:02 -0500] "GET / HTTP/2.0" 200 169 "-" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; Amazonbot/0.1; +https://developer.amazon.com/support/amazonbot) Chrome/119.0.6045.214 Safari/537.36"


20.29.23.198 - - [01/Nov/2025:21:31:46 -0500] "GET /manager/html HTTP/1.1" 404 462 "-" "Mozilla/5.0 zgrab/0.x"
 
zEitEr said:
That can be caused by a bunch of reasons. You might enable slow logs in PHP-FPM and see what is causing issues. Common reasons:

1. too slow SQL queries
Click to expand...
after adding the slow log file
nano /etc/my.cnf
slow_query_log = 1
slow_query_log_file = /var/lib/mysql/slow.log
long_query_time = 1
log_queries_not_using_indexes = 1
Click to expand...
Finally I GOt
.
with the Command : mysql -e "SHOW VARIABLES LIKE 'slow_query_log%';"
i got :
mysql: unknown variable 'slow_query_log=1'
mysql: unknown variable 'slow_query_log_file=/var/lib/mysql/slow.log'
mysql: unknown variable 'long_query_time=1'
mysql: unknown variable 'log_queries_not_using_indexes=1'
[root@server ~]# sudo tail -n 50 /var/lib/mysql/slow.log
# User@Host: admin_wp_domain_org[admin_wp_domain_org] @ localhost []
# Thread_id: 131 Schema: admin_wp_domain_org QC_hit: No
# Query_time: 0.000037 Lock_time: 0.000015 Rows_sent: 1 Rows_examined: 1
# Rows_affected: 0 Bytes_sent: 56
SET timestamp=1762052271;
SELECT 1 FROM m5rr3zocd_posts LIMIT 1;
# User@Host: admin_wp_domain_org[admin_wp_domain_org] @ localhost []
# Thread_id: 131 Schema: admin_wp_domain_org QC_hit: No
# Query_time: 0.000037 Lock_time: 0.000015 Rows_sent: 1 Rows_examined: 1
# Rows_affected: 0 Bytes_sent: 56
SET timestamp=1762052271;
SELECT 1 FROM m5rr3zocd_posts LIMIT 1;
# Time: 251101 21:57:52
# User@Host: admin_wp_domain_org[admin_wp_domain_org] @ localhost []
# Thread_id: 132 Schema: admin_wp_domain_org QC_hit: No
# Query_time: 0.000136 Lock_time: 0.000056 Rows_sent: 1 Rows_examined: 1
# Rows_affected: 0 Bytes_sent: 56
SET timestamp=1762052272;
SELECT 1 FROM m5rr3zocd_posts LIMIT 1;
# User@Host: admin_wp_domain_org[admin_wp_domain_org] @ localhost []
# Thread_id: 132 Schema: admin_wp_domain_org QC_hit: No
# Query_time: 0.000023 Lock_time: 0.000010 Rows_sent: 1 Rows_examined: 1
# Rows_affected: 0 Bytes_sent: 56
SET timestamp=1762052272;
SELECT 1 FROM m5rr3zocd_posts LIMIT 1;
# User@Host: admin_wp_domain_org[admin_wp_domain_org] @ localhost []
# Thread_id: 132 Schema: admin_wp_domain_org QC_hit: No
# Query_time: 0.000020 Lock_time: 0.000008 Rows_sent: 1 Rows_examined: 1
# Rows_affected: 0 Bytes_sent: 56
SET timestamp=1762052272;
SELECT 1 FROM m5rr3zocd_posts LIMIT 1;
# Time: 251101 21:57:53
# User@Host: admin_wp_domain_org[admin_wp_domain_org] @ localhost []
# Thread_id: 133 Schema: admin_wp_domain_org QC_hit: No
# Query_time: 0.000146 Lock_time: 0.000064 Rows_sent: 1 Rows_examined: 1
# Rows_affected: 0 Bytes_sent: 56
SET timestamp=1762052273;
SELECT 1 FROM m5rr3zocd_posts LIMIT 1;
# User@Host: admin_wp_domain_org[admin_wp_domain_org] @ localhost []
# Thread_id: 133 Schema: admin_wp_domain_org QC_hit: No
# Query_time: 0.000038 Lock_time: 0.000016 Rows_sent: 1 Rows_examined: 1
# Rows_affected: 0 Bytes_sent: 56
SET timestamp=1762052273;
SELECT 1 FROM m5rr3zocd_posts LIMIT 1;
# User@Host: admin_wp_domain_org[admin_wp_domain_org] @ localhost []
# Thread_id: 133 Schema: admin_wp_domain_org QC_hit: No
# Query_time: 0.000042 Lock_time: 0.000015 Rows_sent: 1 Rows_examined: 1
# Rows_affected: 0 Bytes_sent: 56
SET timestamp=1762052273;
SELECT 1 FROM m5rr3zocd_posts LIMIT 1;
with command : mysqldumpslow -s t -t 10 /var/lib/mysql/slow.log

i got

Reading mysql slow query log from /var/lib/mysql/slow.log
Count: 415 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=1.0 (415), Rows_examined=1.0 (415), Rows_affected=0.0 (0), admin_wp_domain_org[admin_wp_domain_org]@localhost
SELECT N FROM m5rr3zocd_posts LIMIT N

Count: 2 Time=0.01s (0s) Lock=0.00s (0s) Rows_sent=582.5 (1165), Rows_examined=698.5 (1397), Rows_affected=0.0 (0), admin_wp_domain4_com[admin_wp_domain4_com]@localhost
use `admin_wp_domain4_com`;
SET timestamp=N;
SELECT option_name, option_value FROM wp_options WHERE autoload IN ( 'S', 'S', 'S', 'S' )

Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=435.0 (435), Rows_affected=0.0 (0), admin_wp_domain2_org[admin_wp_domain2_org]@localhost
SELECT m.*, r.user_id, r.unread_count FROM `d78ht3hzd_bp_messages_messages` AS m LEFT JOIN `d78ht3hzd_bp_messages_recipients` AS r ON m.thread_id = r.thread_id LEFT JOIN `d78ht3hzd_bp_messages_meta` AS meta1 ON ( m.id = meta1.message_id AND meta1.meta_key = 'S' ) WHERE m.date_sent >= 'S' AND m.date_sent <= 'S' AND r.unread_count > N AND r.is_deleted = N AND m.sender_id != r.user_id AND r.is_hidden = N AND meta1.message_id IS NULL ORDER BY m.thread_id, m.id ASC

Count: 9 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=0.0 (0), Rows_affected=0.0 (0), admin_wp_domain2_org[admin_wp_domain2_org]@localhost
use `admin_wp_domain2_org`;
SET timestamp=N;
SELECT DISTINCT m.user_id FROM d78ht3hzd_bp_suspend s LEFT JOIN d78ht3hzd_bp_moderation m ON m.moderation_id = s.id WHERE s.item_type = 'S' AND s.item_id = N AND s.reported != N AND m.user_report != N

Count: 3 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=1817.0 (5451), Rows_examined=1817.0 (5451), Rows_affected=0.0 (0), admin_wp_domain5_com[admin_wp_domain5_com]@localhost
SELECT * FROM mcygnw0_track_user_activity

Count: 17 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=1.0 (17), Rows_examined=1.0 (17), Rows_affected=0.0 (0), admin_wp_domain_org[admin_wp_domain_org]@localhost
use `admin_wp_domain_org`;
SET timestamp=N;
SELECT N FROM m5rr3zocd_posts LIMIT N

Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=120.0 (120), Rows_examined=136.0 (136), Rows_affected=0.0 (0), admin_wp_domain3_org[admin_wp_domain3_org]@localhost
use `admin_wp_domain3_org`;
SET timestamp=N;
SELECT option_name, option_value FROM wp_options WHERE autoload IN ( 'S', 'S', 'S', 'S' )

Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=4.0 (4), Rows_affected=1.0 (1), admin_wp_domain4_com[admin_wp_domain4_com]@localhost
use `admin_wp_domain4_com`;
SET timestamp=N;
UPDATE wp_actionscheduler_actions t1 JOIN ( SELECT action_id from wp_actionscheduler_actions WHERE claim_id = N AND scheduled_date_gmt <= 'S' AND status='S' ORDER BY priority ASC, attempts ASC, scheduled_date_gmt ASC, action_id ASC LIMIT N FOR UPDATE SKIP LOCKED ) t2 ON t1.action_id = t2.action_id SET claim_id=N, last_attempt_gmt='S', last_attempt_local='S'

Count: 2 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=583.0 (1166), Rows_examined=699.0 (1398), Rows_affected=0.0 (0), admin_wp_domain4_com[admin_wp_domain4_com]@localhost
SELECT option_name, option_value FROM wp_options WHERE autoload IN ( 'S', 'S', 'S', 'S' )

Count: 4 Time=0.00s (0s) Lock=0.00s (0s) Rows_sent=0.0 (0), Rows_examined=16.0 (64), Rows_affected=0.0 (0), admin_wp_crm_domain5_com[admin_wp_crm_domain5_com]@localhost
use `admin_wp_crm_domain5_com`;
SET timestamp=N;
select * from `wp_fbs_metas` where `object_type` = 'S' and `key` = 'S' LIMIT N
Click to expand...
 
You must log in or register to reply here.
Back
Top