@knuthollund maybe other !gnusocial admins could check one their instances whether they have those slow queries, too.
Because I wonder why this seems to affect only quitter.no (apart from also quitter.se which is currently down), _even though_ quitter.no has already such powerful hardware like SSD, 12 GB RAM and the whole database kept in memory. I would expect there are at least some less powerful instances around, but I'm still still havent found other instances affected by this #every-few-minutes-unresponsive-for30-seconds-issue.
This is my new home in the #fediverse, due to quitter.se being constantly on the fritz for the past few months. Looking forward to a more long term test of #Mastodon after being on #GNUSocial + #Qvitter for a couple of years.
Because: Some 3 weeks ago I told @knuthollund on #IRC about the issue and he said he would have a look. Soon after that the problem was completely gone and quitter.no worked flawlessly for at least the rest of the day! And moreover: quitter.se also worked flawlessly! But later it turned out @knuthollund didn't actually do anything at that point, not even restart anything.)
So I think that something on the fediverse network must have changed within those couple of hours. I think the cause of the problem is somewhere in the internet and that cause did stop its weird behaviour against quitter.se and quitter.no just for a while. Too bad the problem came back the next day.
I think one could check the logs of the webserver or use wireshark to look out for weird/excessive traffic. !gnusocial
@lakwnikos Regarding the "not-responding database server every few minutes" phenomenon I really wonder what the cause of it could be.
1) I think only quitter.se and quitter.no are affected. I did some research and asked on IRC but couldn't find any other instance with this problem yet
@hannes Can we, the users, help to save quitter.se? Maybe some more people would make regular monthly donations now. (SEPA bank transfer is free of charge within the EU by law so EU people can even donate small amounts like 3 € per month automatically without any fees.)
And maybe there are other admins who can help with the technical problems.
Maybe you actually don't need a hardware upgrade now. Because: quitter.NO has exactly the same issue with "not-responding database server every few minutes". And quitter.no already runs on powerful hardware (SSD disk, 12 GB RAM and the whole database kept in memory) AND has a smaller number of users.
@hannes Can we, the users, help to save quitter.se? Maybe some more people would make regular monthly donations now. (SEPA bank transfer is free of charge within the EU by law so EU people can even donate small amounts like 3 € per month automatically without any fees.)
And maybe there are other admins who can help with the technical problems.
Maybe you actually don't need a hardware upgrade now. Because: quitter.NO has exactly the same issue with "not-responding database server every few minutes". And quitter.no already runs on powerful hardware (SSD disk, 12 GB RAM and the whole database kept in memory) AND has a smaller number of users.
I want to add https://octodon.social/@cwebber to my gnusocial account. How to do it !gnusocial this is a stupid question I know because I have a solution but My solution is so complicated that I am asking if I am doing well
Genau da habe ich ein Problem, denn dieses "Abholen, wo sich Nutzer befinden" hat bis dato nur Verschlimmbesserungen in jedweder Form hervorgebracht. Auch beispielsweise dazu, dass die dezentralen Systeme allerlei API-Anbindungen zu proprietären Systemen geschaffen haben.
So beispielsweise #GNU-social oder #Mastodon mit Videos seitens #YouTube. Ich bin dafür, dass der Nutzer sich mit dem befasst was zu finden ist und dann kreativ erkundet. Nicht aber immer nur den gleichen Bedienkontext erwartet und auch bekommt. Und so ist auch die Abhängigkeit von #Google für mich absolut kritisch zu betrachten.