At this moment, friendica.world is not stable. You can experience 504 or 503 errors, or just be unable to load the site.
This is being worked on. We'll keep track of the currently known issues in this post.
Database query tuning
One of the main issues at the moment is the database hanging with many inefficient queries running for minutes or even hours. Most of them are using an inefficient 'NOT IN' or similar construction. We've created an issue for that here: https://github.com/friendica/friendica/issues/14947
Also we've created an issue for many updates to a key-value table: https://github.com/friendica/friendica/issues/14948
Update 30-06-2025
The beforementioned issues were closed, we'll upgrade to 2025.07-RC in order to get the latest fixes and do troubleshooting from there. We'll send the slow qeury logs to the devs.
@ruud @convene_depth It's one of my servers. The active users there are a lot of news bot accounts, besides some users. AFAIK the server runs quiet stable, but I had to tweak the database a lot to make it work.
Also there are some tweaks in the setting (like reducing the number of delivery retrials) to make the system work faster.
Maybe after I upgraded to the RC we could schedule some time to go over your tweaks together?
@ruud We can try. I will be on the HOA until Saturday. Because of that I'm not sure how available I will be in that time.
Continuing this on Matrix.