Skip to main content
!Friendica Support

Hi.

Since last update of #PHP8.4, I'm struggling with poor #performance of my instance on a #RasPi5 .
PHP/nginx workers already adjusted (PHP5, NGINX4).
504 errors where gone since that, but performance, very well after reboot, builds up and is very bad after some time.
So I guess, i've to adjust my #mariadb config.
Any hints for a RasPi5 with 8GB RAM?
Thanks in advance.
#mariadb #Performance #PHP8.4 #RasPi5
Tealk
@Lasse Gismo (Friendica Antifa) do you have very long loading times every now and then?

If so, I also have this problem quite often; in the php logs I then find
[14-Jul-2026 18:00:07] WARNING: [pool www] child 482997, script '/var/www/friendica/index.php' (request: "GET /index.php?pagename=/robots.txt&") execution timed out (60.203109 sec), terminating
[14-Jul-2026 18:00:07] WARNING: [pool www] child 482997 exited on signal 15 (SIGTERM) after 5760.302560 seconds from start
[14-Jul-2026 18:00:07] NOTICE: [pool www] child 489578 started
Lasse Gismo (Friendica Antifa)
@Tealk

825 requests for "robots.txt" during 17 hours on a single user instance seems to be not so much and "gotosocial" seems not to be the bad guy here.
Well - I'm following around 1000 accounts...
Tealk
@Lasse Gismo (Friendica Antifa) my performance problems have been resolved since I put a robots.txt in the webroot.
Lasse Gismo (Friendica Antifa)
@Tealk
Which entries are in there?
Tealk
@Lasse Gismo (Friendica Antifa) it’s more about the fact that a file exists, otherwise Friendica probably generates one dynamically; if I understood the code correctly.
My file is more of a joke: https://friendica.rollenspiel.monster/robots.txt
tom s
@Tealk @Lasse Gismo (Friendica Antifa) Really nice idea, but broken robots dont know about this.
Look at his log: "GET /index.php?pagename=/robots.txt&"
So you need a rewrite rule or alias too for your webserver.
Tobias
@Lasse Gismo (Friendica Antifa) not DB related, but I remembered that I had once performance issues when I had a unclean PHP setup with php8.0-fpm and php8.2-fpm (or something like that) running on my raspi and I was all the time optimizing the pool that was not in use for some reason.

How large is you DB in file size? It needs to be managed in RAM next to PHP and the other things running. I am kind of aggressive deleting uninteresting / unclaimed content on my node.
Lasse Gismo (Friendica Antifa)
@Tobias
It's currently 9 GB, and I delete everything older than 30 days, except for my posts.
Tobias
@Lasse Gismo (Friendica Antifa) with "unclaimed items" (stuff that is arriving via relay servers) I am deleting those after 1 day, but rest should be fine.

Do you have the rendertime addon on? How long is the time for the "Database" section?

The "mysql tuner" perl script / tool can give some hinds of what to enhance with the mysql settings. With mytop you can see if there are long running tasks on the DB (that should also be logged but at the moment I don't remember how to do that 😅). Which might help to identify the bottleneck.
⇧