-

Tue, 13 Apr 2021 09:46:39 +0200

adminsforum@hubzilla.org

RockyIII wrote the following post Tue, 13 Apr 2021 09:46:38 +0200

How to optimize the HZ DB ?

Loading of pages are getting slow and also getting "504 Gateway Time-out" Errors
Could someone explain to me how I could optimize the HZ DB in a safe way ? THANKS

show all 7 comments

Tue, 13 Apr 2021 09:48:50 +0200

RockyIII

rocky3@im.allmendenetz.de

Can i do it like this : #^https://www.siteground.com/kb/how_to_optimize_a_mysql_database/ ??

Tue, 13 Apr 2021 10:15:50 +0200

oRx-Qx pirateradio

michal@node9.org

If you run PHP with FPM check number of processes - max children, if you are not running out of them. If so, things get slow because requests are waiting for a free process and eventually thow timeout.

Tue, 13 Apr 2021 11:31:56 +0200

RockyIII

rocky3@im.allmendenetz.de

thanks...

need more help with that.. how do I set max children in /etc/php/fpm/pool.d/www.conf right ?

in the nginx error log I read:

upstream timed out (110: Connection timed out) while reading response header from upstream,

Tue, 13 Apr 2021 11:47:16 +0200

RockyIII

rocky3@im.allmendenetz.de

also see now in /var/log/php7.3-fpm.log

WARNING: [pool hubzilla] server reached pm.max_children setting (5), consider raising it

so to what number i should raise it???

Tue, 13 Apr 2021 12:19:50 +0200

RockyIII

rocky3@im.allmendenetz.de

Thanks...

found this also :
https://chrismoore.ca/2018/10/finding-the-correct-pm-max-children-settings-for-php-fpm/

Tue, 13 Apr 2021 14:40:17 +0200

Marshall Sutherland

dwatney@hub.farthinghalearms.com

I've been experiencing slowness on my hub, too, in recent days. How many others have as well?

Tue, 13 Apr 2021 21:32:27 +0200

oRx-Qx pirateradio

michal@node9.org

I think for a small site like 5 simultaneously active people and 4GB RAM for Hubzilla

pm.max_children = 25
pm.start_servers = 6
pm.min_spare_servers = 6
pm.max_spare_servers = 18