Skip to main content

!Friendica Admins

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.603

The 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?

in reply to Matthias

Michael Vogel
Michael Vogel
• •
Please Enable the callstack in Rendertime, so that we can see which queries are causing this.
in reply to Michael Vogel

Matthias
Matthias
• • 
social.tchncs.de
===
Datenbank: 91.379/0, Netzwerk: 0, Darstellung: 0.54, Sitzung: 0, I/O: 0.01, Sonstiges: 0.28, Gesamt: 92.2
Class-Init: 0.011, Boot: 0.122, Init: 0, Inhalt: 92.059, Sonstiges: 0.013, Gesamt: 92.206

Database Read:
DBA::p (1691), Contact::getThreadsFromId (123), Conversations::content (250), BaseModule::run (682): 77.281
DBA::p (1052), Conversation::getEmojis (864), Conversation::addChildren (559), Conversation::render (1699): 4.999
Post::select (888), Conversation::addChildren (559), Conversation::render (1699), Contact::getThreadsFromId (123): 1.79
Post::select (899), Conversation::addChildren (559), Conversation::render (1699), Contact::getThreadsFromId (123): 2.595
DBA::selectToArray (812), Media::getByURIId (3385), Item::prepareBody (464), Post::getTemplateData (204): 0.551
DBA::select (557), Tag::populateFromItem (3353), Item::prepareBody (464), Post::getTemplateData (655): 1.252
DBA::selectToArray (812), Media::getByURIId (3385), Item::prepareBody (464), Post::getTemplateData (655): 0.719

Database Write:

Cache Read:

Cache Write:

Network:

Rendering:


mastodon.social
===
Datenbank: 57.838/0, Netzwerk: 0, Darstellung: 0.25, Sitzung: 0, I/O: 0.01, Sonstiges: 0.52, Gesamt: 58.61
Class-Init: 0.011, Boot: 0.098, Init: 0, Inhalt: 58.495, Sonstiges: 0.013, Gesamt: 58.616

Database Read:
DBA::p (1691), Contact::getThreadsFromId (123), Conversations::content (250), BaseModule::run (682): 53.576
DBA::p (1052), Conversation::getEmojis (864), Conversation::addChildren (559), Conversation::render (1699): 1.192
Post::select (888), Conversation::addChildren (559), Conversation::render (1699), Contact::getThreadsFromId (123): 0.658
Post::select (899), Conversation::addChildren (559), Conversation::render (1699), Contact::getThreadsFromId (123): 1.004

Database Write:

Cache Read:

Cache Write:

Network:

Rendering:


chaos.social
===
Datenbank: 13.346/0.004, Netzwerk: 0, Darstellung: 0.64, Sitzung: 0, I/O: 0, Sonstiges: 0.27, Gesamt: 14.26
Class-Init: 0.012, Boot: 0.092, Init: 0, Inhalt: 14.149, Sonstiges: 0.011, Gesamt: 14.263

Database Read:
DBA::p (1691), Contact::getThreadsFromId (123), Conversations::content (250), BaseModule::run (682): 6.214
DBA::p (1052), Conversation::getEmojis (864), Conversation::addChildren (559), Conversation::render (1699): 2.899
Post::select (888), Conversation::addChildren (559), Conversation::render (1699), Contact::getThreadsFromId (123): 0.763
Post::select (899), Conversation::addChildren (559), Conversation::render (1699), Contact::getThreadsFromId (123): 0.74
DBA::select (557), Tag::populateFromItem (3353), Item::prepareBody (464), Post::getTemplateData (204): 0.599
DBA::selectToArray (812), Media::getByURIId (3385), Item::prepareBody (464), Post::getTemplateData (204): 0.598
DBA::select (557), Tag::populateFromItem (3353), Item::prepareBody (464), Post::getTemplateData (655): 0.535

Database Write:

Cache Read:

Cache Write:

Network:

Rendering:
BBCode::convert (1283), BBCode::convertForUriId (3300), Item::putInCache (3431), Item::prepareBody (464): 0.515
Support Translate

radiosocial.de
===
Datenbank: 7.63/0.005, Netzwerk: 0, Darstellung: 0.92, Sitzung: 0, I/O: 0.01, Sonstiges: 0.38, Gesamt: 8.94
Class-Init: 0.012, Boot: 0.128, Init: 0, Inhalt: 8.79, Sonstiges: 0.012, Gesamt: 8.942

Database Read:
DBA::p (1691), Contact::getThreadsFromId (123), Conversations::content (250), BaseModule::run (682): 2.017
DBA::p (1052), Conversation::getEmojis (864), Conversation::addChildren (559), Conversation::render (1699): 1.336
Post::select (899), Conversation::addChildren (559), Conversation::render (1699), Contact::getThreadsFromId (123): 1.113
DBA::select (557), Tag::populateFromItem (3353), Item::prepareBody (464), Post::getTemplateData (655): 0.625
DBA::selectToArray (812), Media::getByURIId (3385), Item::prepareBody (464), Post::getTemplateData (655): 0.576

Database Write:

Cache Read:

Cache Write:

Network:

Rendering:
BBCode::convert (1283), BBCode::convertForUriId (3300), Item::putInCache (3431), Item::prepareBody (464): 0.769
Support Translate
in reply to Matthias

Michael Vogel
Michael Vogel
• •
That looks like your database configuration might need some tweaks, since there are calls there that shouldn't take significant time at all.
in reply to Michael Vogel

Matthias
Matthias
• •

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

in reply to Matthias

Matthias
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

in reply to Matthias

Matthias
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

social.vivaldi.net
---
Datenbank: 4.05/0.002, Netzwerk: 0, Darstellung: 0.45, Sitzung: 0, I/O: 0, Sonstiges: 0.23, Gesamt: 4.73
Class-Init: 0.011, Boot: 0.091, Init: 0, Inhalt: 4.621, Sonstiges: 0.009, Gesamt: 4.733

Database Read:
DBA::p (1691), Contact::getThreadsFromId (123), Conversations::content (250), BaseModule::run (682): 0.716
DBA::p (1052), Conversation::getEmojis (864), Conversation::addChildren (559), Conversation::render (1699): 2.076

Database Write:

Cache Read:

Cache Write:

Network:

Rendering:


social.bund.de
---
Datenbank: 0.43/0, Netzwerk: 0, Darstellung: 0.1, Sitzung: 0, I/O: 0, Sonstiges: 0.19, Gesamt: 0.73
Class-Init: 0.01, Boot: 0.093, Init: 0, Inhalt: 0.613, Sonstiges: 0.011, Gesamt: 0.728

Database Read:

Database Write:

Cache Read:

Cache Write:

Network:

Rendering:


botsin.space
---
Datenbank: 2.749/0, Netzwerk: 0, Darstellung: 0.08, Sitzung: 0, I/O: 0, Sonstiges: 0.04, Gesamt: 2.87
Class-Init: 0.01, Boot: 0.103, Init: 0, Inhalt: 2.746, Sonstiges: 0.012, Gesamt: 2.871

Database Read:
DBA::p (1691), Contact::getThreadsFromId (123), Conversations::content (250), BaseModule::run (682): 0.91

Database Write:

Cache Read:

Cache Write:

Network:

Rendering:


mastodon.social
---
Datenbank: 0.997/0, Netzwerk: 0, Darstellung: 0.08, Sitzung: 0, I/O: 0, Sonstiges: 0.12, Gesamt: 1.2
Class-Init: 0.012, Boot: 0.091, Init: 0, Inhalt: 1.087, Sonstiges: 0.011, Gesamt: 1.201

Database Read:

Database Write:

Cache Read:

Cache Write:

Network:

Rendering:

squeet.me
---
Datenbank: 103.854/0, Netzwerk: 0, Darstellung: 0.05, Sitzung: 0, I/O: 0, Sonstiges: 0.12, Gesamt: 104.02
Class-Init: 0.009, Boot: 0.1, Init: 0, Inhalt: 103.905, Sonstiges: 0.011, Gesamt: 104.025

Database Read:
DBA::p (1691), Contact::getThreadsFromId (123), Conversations::content (250), BaseModule::run (682): 103.59

Database Write:

Cache Read:

Cache Write:

Network:

Rendering:


threads.net
---
Datenbank: 0.456/0, Netzwerk: 0, Darstellung: 0.03, Sitzung: 0, I/O: 0, Sonstiges: 0.04, Gesamt: 0.53
Class-Init: 0.011, Boot: 0.12, Init: 0, Inhalt: 0.389, Sonstiges: 0.01, Gesamt: 0.53

Database Read:

Database Write:

Cache Read:

Cache Write:

Network:

Rendering:

diasp.org
---
Datenbank: 31.622/0, Netzwerk: 0, Darstellung: 0.08, Sitzung: 0, I/O: 0, Sonstiges: 0.11, Gesamt: 31.81
Class-Init: 0.01, Boot: 0.135, Init: 0, Inhalt: 31.657, Sonstiges: 0.01, Gesamt: 31.811

Database Read:
DBA::p (1691), Contact::getThreadsFromId (123), Conversations::content (250), BaseModule::run (682): 31.265

Database Write:

Cache Read:

Cache Write:

Network:

Rendering:
⇧