friendica.world
Ruud
Ruud friendica (DFRN)
Friendica has some serious performance issues.
I have had to disable fulltext search and kill some processes, because the database was overloading the system and even crashing regularly. I;ll keep an eye on it if it settles down now...
Link to source
5
Pekka Kurki
Pekka Kurki friendica (DFRN)
Do you think this is a fundamental problem with large 1000+ users Friendica instances in general? Are Friendica servers just unable to handle the user count? Or is there something wrong with friendica.world itself for some reason or another?
Link to source
1
Ruud
Ruud friendica (DFRN)
I think it is the Friendica software which isn't capable of handling this many users, I will see if I can work with the developers to get that fixed.
Link to source
3
Daniel de Kay
Daniel de Kay • friendica

@Ruud @pekkakurki What is your server setup? RAM? CPU? Do you use a cache?

I have been searching for specs and requirements of Friendica servers, but so far not much has surfaced.

@Ruud @Pekka Kurki
Link to source
Ruud
Ruud friendica (DFRN)

It is 1 physical server with 64GB ram and 16 cpu threads
Tomorrow we plan on migrating the frontend (web) to separate VMs so the database will have this entire server for itself.

Then we can at least scale the frontend more easily, but the main issues are with the (Mariadb) database and the database and query design.

If there are more people that want to help out troubleshoot this, maybe mainly with Mariadb knowledge, feel free to contact me.

Link to source
1
Daniel de Kay
Daniel de Kay • friendica

@Ruud @pekkakurki Oh, wow, that sounds like there should be plenty of capacity for 1000s of users.

I have had ChatGPT write me a manual for #friendica admin since I am just getting started. There are some #MariaDB optimizations mentioned

Of course, you never know what ChatGPT does or if it is of any help.

chatgpt.com/share/682883f5-417…

#friendica #admin

#friendica #admin #mariadb #friendica admin @Ruud @Pekka Kurki
Link to source
2
Ruud
Ruud friendica (DFRN)
Yeah I use ChatGPT for suggestions as well, but you need to verify if it isn't nonsense (like in your link, it says Friendica supports PostgreSQL, which it doesn't)
Link to source
2
Daniel de Kay
Daniel de Kay • friendica
@Ruud @pekkakurki Is there an up-to-date admin manual somewhere that I miss, or just the wiki?
@Ruud @Pekka Kurki
Link to source