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...
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...
like this
Pekka Kurki
in reply to Ruud • •skribe likes this.
Ruud
in reply to Pekka Kurki • •like this
Evo, phle and Pekka Kurki like this.
Daniel de Kay
in reply to Ruud • • •@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
in reply to Daniel de Kay • •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.
Daniel de Kay likes this.
Daniel de Kay
in reply to Ruud • • •@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
like this
Ruud and Dietmar Höhmann like this.
Ruud
in reply to Daniel de Kay • •like this
Dietmar Höhmann and Nathan like this.
Daniel de Kay
in reply to Ruud • • •