Nextcloud seems busy, reached pm.max_children

CMDren commented 1 year ago

Describe the bug

Nextcloud becomes slow when I view photos. Warnings in php8.2

Context

Hardware: VPS bought online Netcup Root-Server, AMD EPYC 7702, 6 Cores, 16GB DDR4 RAM,
YunoHost version: 11.2.5
I have access to my server: Through SSH | through the webadmin
Are you in a special context or did you perform some particular tweaking on your YunoHost instance?: no

Steps to reproduce

I have a large number of photos in my Nextcloud instance, about 50,000. When I scroll through the pictures in the photo app, my server seems to have problems. In general, I find Nextcloud to be very slow on my end.

Expected behavior

No idea

Logs

[23-Oct-2023 21:39:22] WARNING: [pool nextcloud] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 8 children, there are 0 idle, and 20 total children [23-Oct-2023 21:39:23] WARNING: [pool nextcloud] server reached pm.max_children setting (24), consider raising it [23-Oct-2023 21:41:33] WARNING: [pool nextcloud] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 8 children, there are 0 idle, and 19 total children [23-Oct-2023 21:41:34] WARNING: [pool nextcloud] server reached pm.max_children setting (24), consider raising it [23-Oct-2023 21:42:06] WARNING: [pool nextcloud] server reached pm.max_children setting (24), consider raising it [23-Oct-2023 21:44:22] WARNING: [pool nextcloud] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 8 children, there are 0 idle, and 19 total children [23-Oct-2023 21:44:23] WARNING: [pool nextcloud] server reached pm.max_children setting (24), consider raising it [23-Oct-2023 21:44:59] WARNING: [pool nextcloud] server reached pm.max_children setting (24), consider raising it

zamentur commented 1 year ago

Here an answer in french: https://forum.chatons.org/t/processus-php-fpm-bloques-par-des-requetes-en-base-de-donnees/5464 (sorry i have not so much time to make an english answer here)

alexAubin commented 4 months ago

Closing due to lack of feedback, see also similar discussion in https://github.com/YunoHost-Apps/nextcloud_ynh/issues/625

YunoHost-Apps / nextcloud_ynh