Eric Bono

2 months ago

Eric Bono
2 months ago

Looks like I picked the wrong week to start using Friendica.

Crashes across all interfaces, takes forever to load. Maybe, if you collapsed all comments by default, just maybe it wouldn't be crunching so hard. Bluesky integration fails completely. Oh well, seemed perfect for me, in the abstract. I learned quite a lot about the potential. Think I just need to make Mastodon my one stop-shop instead.

@helpers @admins

#Friendica #Fediverse

This entry was edited (2 months ago)

in reply to Eric Bono

JB Carroll

in reply to Eric Bono 2 months ago from RaccoonForFriendica

@Eric Bono @Friendica Admins @Friendica Support

A lot of it is database bottlenecks or unoptimized databases. I'd dedicate as much buffer pool to memory for MariaDB as I could. Running Redis and tuning the php pool helps too.

@Friendica Support @Friendica Admins @Eric Bono

in reply to JB Carroll

Eric Bono

in reply to JB Carroll 2 months ago

@jbcarroll Yeah, it has been bogged down for days now. I wish I understood what you're saying there. Wish I could just report it as a ticket or the like. If someone were able to clear the pipes, so to speak, I'd keep trying. But really, I think I just need to find maybe a mastodon instance with more character limit, etc. (I think Friendica has more image and video capacity too. . .)

@JB Carroll

in reply to Eric Bono

Thomas

in reply to Eric Bono 2 months ago from RaccoonForFriendica

@Eric Bono
friendica.world often has to contend with outages. I think the instance has grown too large too quickly.

@Eric Bono

in reply to Thomas

Eric Bono

in reply to Thomas 2 months ago

@cantences Seems exactly like the issue. I'll keep checking it out for future use. Thanks for your input. Very much appreciated.

I'd try a different instance but nothing seemed workable, not above 95 health in the directory. Mostly non-English instances. No way of knowing which are fastest...

@Thomas

This entry was edited (2 months ago)

in reply to Eric Bono

Thomas

in reply to Eric Bono 2 months ago

@Eric Bono
you can try anonsys.net/

@Eric Bono

in reply to Eric Bono

fe di

in reply to Eric Bono 2 months ago

@Eric Bono
I use only friendica and had never any problem.
But i use it as own server-instance.
So i would recomend the best way to enter the fediverse is by using own server-instances. This is also the best way in the intentioan of the fediverse. big servers attracting masses of users into their instance are more of the kind of damaging the idea of the fediverse in mimikying the big commercial things.
And bluesky is not a real supporter of the fediverse, it is onyl another centralized alternative of centrlatized alternatives..

@Eric Bono

in reply to Eric Bono

wilhelm

in reply to Eric Bono 2 months ago

there is an issue tracking the performance trouble with friendica.world: github.com/friendica/friendica/issues/14947
It has been addressed in github.com/friendica/friendica/pull/14974
The patch is not yet live on friendica.world though.

Query tuning: NOT IN

Bug Description There are queries using 'NOT IN' which are performing badly when the tables have millions of rows. Steps to Reproduce explain SELECT `uri-id` FROM `post` WHERE (NOT `uri-id` IN (SEL...

^{ruudschilders (GitHub)}