@Christian Kalkhoff I had it, too, until I have changed some mysql conf value to some 6GB if I remember correctly. I can't remember the name of that value but I can look it up when I am back at the PC.

Hey Christian, could you activate the "rendertime" addon on your node? It will display time sinks at the bottom of the pages shown (to the admin user). Please activate the "Show callstack" option in the addon settings (in the admin panel) and set the minimal time to 0.01 seconds. This will limit the noise as only things that take longer then 0.01 seconds are shown.

@Tobias Nice, those stick out:

Tag::populateFromItem (3248)
Media::getByURIId (3280)

Compared to the network feed the stack trace is also way more complex

@Christian Kalkhoff just in case: it was innodb_buffer_pool_size

@xy.. Thanks, that helped... all the places that were "fast" before, so friendica is now really fast but for the profile posts. Thank you anyway!

I now run #mariadb with

--optimizer-use-condition-selectivity=1 --optimizer-switch='rowid_filter=off' --innodb-buffer-pool-size=6G --query-cache-size=64M --max-heap-table-size=64M --tmp-table-size=64M

That helps a lot overall, but the personal page is still about 8 to 10 times slower than everything else.