2024-07-17 10:30:22
2024-07-15 06:37:02
2024-07-15 06:36:29
5006609
I have a pretty nasty performance hole here when calling up profiles (https://loma.ml/contact/1759872/conversations).
wandzeitung.xyz
Datenbank: 7.293/0, Netzwerk: 0, Darstellung: 0.08, Sitzung: 0, I/O: 0, Sonstiges: 0.2, Gesamt: 7.57
Class-Init: 0.014, Boot: 0.112, Init: 0, Inhalt: 7.436, Sonstiges: 0.01, Gesamt: 7.571
norden.social
Datenbank: 81.404/0, Netzwerk: 0, Darstellung: 0.29, Sitzung: 0, I/O: 0.01, Sonstiges: 0.4, Gesamt: 82.1
Class-Init: 0.011, Boot: 0.111, Init: 0, Inhalt: 81.964, Sonstiges: 0.018, Gesamt: 82.104
dragonscave.space
Datenbank: 5.398/0.001, Netzwerk: 0, Darstellung: 0.19, Sitzung: 0, I/O: 0, Sonstiges: 0.14, Gesamt: 5.73
Class-Init: 0.019, Boot: 0.139, Init: 0, Inhalt: 5.561, Sonstiges: 0.009, Gesamt: 5.727
troet.cafe
Datenbank: 7.735/0, Netzwerk: 0, Darstellung: 0.09, Sitzung: 0, I/O: 0, Sonstiges: 0.24, Gesamt: 8.07
Class-Init: 0.013, Boot: 0.118, Init: 0, Inhalt: 7.929, Sonstiges: 0.012, Gesamt: 8.072
bildung.social
Datenbank: 74.778/0, Netzwerk: 0, Darstellung: 0.54, Sitzung: 0, I/O: 0.02, Sonstiges: 0.83, Gesamt: 76.16
Class-Init: 0.014, Boot: 0.147, Init: 0, Inhalt: 75.985, Sonstiges: 0.016, Gesamt: 76.162
mastodon.social
Datenbank: 1.495/0.004, Netzwerk: 0, Darstellung: 0.73, Sitzung: 0, I/O: 0, Sonstiges: 0.3, Gesamt: 2.53
Class-Init: 0.01, Boot: 0.108, Init: 0, Inhalt: 2.402, Sonstiges: 0.013, Gesamt: 2.533
chaos.social
Datenbank: 17.931/0.002, Netzwerk: 0, Darstellung: 0.62, Sitzung: 0, I/O: 0.01, Sonstiges: 0.54, Gesamt: 19.11
Class-Init: 0.01, Boot: 0.098, Init: 0, Inhalt: 18.993, Sonstiges: 0.014, Gesamt: 19.115
pod.geraspora.de
Datenbank: 124.232/0, Netzwerk: 0, Darstellung: 0.19, Sitzung: 0, I/O: 0.01, Sonstiges: 0.27, Gesamt: 124.7
Class-Init: 0.011, Boot: 0.115, Init: 0, Inhalt: 124.565, Sonstiges: 0.017, Gesamt: 124.707
darmstadt.social
Datenbank: 35.051/0, Netzwerk: 0, Darstellung: 0.26, Sitzung: 0, I/O: 0.01, Sonstiges: 0.48, Gesamt: 35.8
Class-Init: 0.01, Boot: 0.134, Init: 0, Inhalt: 35.647, Sonstiges: 0.013, Gesamt: 35.804
wandering.shop
Datenbank: 3.628/0.003, Netzwerk: 0, Darstellung: 0.5, Sitzung: 0, I/O: 0, Sonstiges: 0.23, Gesamt: 4.37
Class-Init: 0.015, Boot: 0.126, Init: 0, Inhalt: 4.221, Sonstiges: 0.011, Gesamt: 4.373
pleroma-in.ouda.space
Datenbank: 5.317/0.01, Netzwerk: 0, Darstellung: 1.61, Sitzung: 0, I/O: 0.01, Sonstiges: 0.61, Gesamt: 7.56
Class-Init: 0.011, Boot: 0.107, Init: 0, Inhalt: 7.433, Sonstiges: 0.014, Gesamt: 7.565
norden.social
Datenbank: 4.117/0.002, Netzwerk: 0, Darstellung: 0.33, Sitzung: 0, I/O: 0, Sonstiges: 0.16, Gesamt: 4.61
Class-Init: 0.01, Boot: 0.114, Init: 0, Inhalt: 4.472, Sonstiges: 0.012, Gesamt: 4.607
mstdn.jp
Datenbank: 0.386/0, Netzwerk: 0, Darstellung: 0.02, Sitzung: 0, I/O: 0, Sonstiges: 0.04, Gesamt: 0.45
Class-Init: 0.014, Boot: 0.113, Init: 0, Inhalt: 0.315, Sonstiges: 0.009, Gesamt: 0.452
anonsys.net
Datenbank: 49.93/0, Netzwerk: 0, Darstellung: 0.06, Sitzung: 0, I/O: 0, Sonstiges: 0.04, Gesamt: 50.03
Class-Init: 0.011, Boot: 0.114, Init: 0, Inhalt: 49.895, Sonstiges: 0.01, Gesamt: 50.03
threads.net
Datenbank: 2.943/0, Netzwerk: 0, Darstellung: 0.06, Sitzung: 0, I/O: 0, Sonstiges: 0.11, Gesamt: 3.12
Class-Init: 0.014, Boot: 0.135, Init: 0, Inhalt: 2.959, Sonstiges: 0.009, Gesamt: 3.116
subversive.zone
Datenbank: 10.836/0.001, Netzwerk: 0, Darstellung: 0.31, Sitzung: 0, I/O: 0.01, Sonstiges: 0.43, Gesamt: 11.58
Class-Init: 0.011, Boot: 0.121, Init: 0, Inhalt: 11.437, Sonstiges: 0.017, Gesamt: 11.586
squeet.me
Datenbank: 295.424/0, Netzwerk: 0, Darstellung: 0.13, Sitzung: 0, I/O: 0, Sonstiges: 0.05, Gesamt: 295.6
Class-Init: 0.012, Boot: 0.115, Init: 0, Inhalt: 295.466, Sonstiges: 0.011, Gesamt: 295.603The problem first occurred with the pull of the issue https://github.com/friendica/friendica/pull/14258 and seems to be getting worse and worse since then. Side effect: posts from Tumblr and Bluesky are no longer being fetched.
The server has 64 GB/ram with 14 CPU. The my.cnf (link) is fine from my point of view. But maybe I have a major error in there that is causing the problem in the first place.
The FPM settings are as follows:
pm = dynamic
pm.max_children = 403
pm.start_servers = 100
pm.min_spare_servers = 100
pm.max_spare_servers = 302
pm.max_requests = 1000
Who has a tip on how I can solve the problem?
Lo, thar be cookies on this site to keep track of your login. By clicking 'okay', you are CONSENTING to this.
Michael Vogel
in reply to Matthias • • •Matthias
in reply to Michael Vogel • • •Michael Vogel
in reply to Matthias • • •Matthias
in reply to Michael Vogel • • •That is already clear. Some of the changes in the RC are very far-reaching. Until then, the system ran very reliably and quickly. So what do I need to do to cope with the changes?
In any case, my last changes were unsuccessful. Hence the question to the community
my.cnf
Matthias
in reply to Matthias • • •I have made changes, some of which have been successful. However, these are server-dependent. If a profile is fully loaded on one server within 2-3 seconds, another server takes up to 30 seconds or more. This is confusing
https://mecp.de/caxifuyaya.makefile
Matthias
in reply to Matthias • • •The system responds better but not yet as it should. The poor performance of Friendica or Diaspora systems is noticeable. There the calls still take an extremely long time. Bluesky and tumblr are still asleep.
I am grateful for any advice on how I can change this
... show moreThe system responds better but not yet as it should. The poor performance of Friendica or Diaspora systems is noticeable. There the calls still take an extremely long time. Bluesky and tumblr are still asleep.
I am grateful for any advice on how I can change this