My instance only has 387 users, but these queries plague mine as well, locking tables for very long times, causing huge stalls.
this post was submitted on 30 May 2025
1 points (100.0% liked)
Friendica.World status, support and issues
95 readers
1 users here now
This community is for status, support and issues on the Friendica.World instance
founded 1 month ago
MODERATORS
@Jerry In the RC/Develop there is the fix that changes one of the ugly queries. Also it contains a coding to prevent executing long queries when another long query is running.
Are there some other friendica based sites experiencing similar problems ?
Not really, there are no Friendica sites with this many users...
There is squeet.me with 4,6k users: https://fedi.wrm.sr/instance/squeet.me comparable to the 4k users of friendica.world.
Ah I didn't know that one, they only have 80 mnthly active users though. I'll see if I can contact them
@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.
Now that 2025.07RC is out had you considered updating to that?
Yeah, I might as well. Normally I'm reluctant to install RC's but it can't get much worse ;-)
Please give 2025-07RC a try as main dev was explicitly suggesting that.. And they were asking for Slowquery-log. Could you provide that after updating to RC?
Rooting for you! Friendica is by far my preferred way of accessing the Fediverse – and it seems .world is the largest European server on the whole platform, so I really need it to work, aaaaa
Thanks! We're doing our best. But we also need the github issues solved by the devs. Or others with programming skills
Commit is in: https://github.com/friendica/friendica/pull/14974
Yes I saw. Looks like they only addressed the example query I provided, and not all 'NOT IN' queries.. looks like I have to submit an issue for every query I find.
Do you have a test instance to check whether the recent change does help?
Yes we do, but it doesn't have the users.. so it can't really be compared.