Open a3linux opened 1 year ago
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.
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.
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.
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.