Test new php-fpm parameters to avoid warning

[a3linux]

10-Jul-2023 22:29:46] WARNING: [pool www] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 32 children, there are 2 idle, and 30 total children

Warning message from php-rpm

try to increase the pm settings,

The current settings of conf/nextcloud-app/www.conf

pm = dynamic
pm.max_children = 64
pm.start_servers = 5
pm.min_spare_servers = 5
pm.max_spare_servers = 16

Recommendation,

pm = dynamic
pm.max_children = 80
pm.start_servers = 20
pm.min_spare_servers = 20
pm.max_spare_servers = 64

For 4GB memory of nextcloudapp container.

[a3linux]

Please also be aware of postgres max_connection when increasing the max_children in Nextcloud.

Nextcloud has another config item dbpersistent => 'true' can be tuning the Database connections.

[a3linux]

postgres official docker image supports CMD -c max_connections=200 to increase the max_connections
in docker compose file,

...
command: -c max_connections=200
...

The default max_connections=100.

docker exec -it homecloud_postgres psql -U postgres -c "show max_connections;"
to check.

Tune this with above Nextcloud configurations.

[a3linux]

How to test tuning?

Try to load folder with huge files in Nextcloud and observe the performance.

Try to move or delete huge files and folders from Nextcloud, observe the performance.