Post by @stefano
Last night, the VPS load monitoring for this instance showed a progressive increase. On one hand, we were expecting it, as the instance grows. On the other, it was higher than anticipated.
Upon investigating, we realised there was an inefficiency linked to two missing DB views, which was generating a mountain of queries whenever a federated activity arrived. Simply creating them was enough: the CPU load upon the arrival of each status dropped from 80% for two seconds to 0.50% for a fraction of a second.
Enjoy the speed 😃
3 boosts
22 likes
fd0@fd0
John-Mark Gurney@encthenet@flyovercountry.social
Tim Chase@gumnos@bsd.cafe
Lynx@Lynx@ohai.social
Ferrebam again@ferrebam
tim132@tim132@bsd.cafe
Nigel@nigel
Leonardo Taccari@iamleot@mastodon.sdf.org
Jeroen Wiert Pluimers@wiert@mastodon.social
bugbear@bugbear@indiepocalypse.social
daisE 🌈@daisE@sfba.social
Alex Schroeder@alex@social.alexschroeder.ch
/home/rqm@rqm@exquisite.social
Major Incident 🇪🇺@major@det.social
Whatisgoingon@themipper@mastodon.social
Leonieke@leonieke@squilla.vitaulium.eu
Jess Robinson@castaway@fosstodon.org
Neil Batchelor@nbwpuk@infosec.exchange
^. .^ Paul Wilde@paul@notnull.space
epn4littlefedi@epn4littlefedi
fasnix@fasnix
uoou@uoou@fedi.friendo.monster
@farooqkz@bsd.cafe no, this VPS is just a small FreeBSD VPS. The Raspberry PI instance is the @stefano@rpi0w.stefanomarinelli.it 's one. That was affected, too, but on a smaller scale as it's...smaller and one user.
@stefano@littleone.littlefedi.social @stefano@rpi0w.stefanomarinelli.it
Noted. I would be interested in a benchmark on RPi0 or Allwinner H3(NanoPi/Orange Pi) and compare different kernels. Also, is there a specific reason you run NetBSD on the tiny cheap SBCs rather than FreeBSD? AFAIK, all these boards also have got FreeBSD support.
@farooqkz@bsd.cafe @stefano@rpi0w.stefanomarinelli.it FreeBSD will drop support for armv6 and armv7 quite soon, while NetBSD will continue to support them for a long time. I think NetBSD is more suitable, for those kinds of boards.
I have some of them running FreeBSD, too, and they're doing fine. Armv7 is also supported by OpenBSD.
Benchmarks are planned, and this is here for a specific reason 😉
@stefano@littleone.littlefedi.social @stefano@rpi0w.stefanomarinelli.it
ah yeah. Didn't consider it. I wish #AmlogicA311D had #FreeBSD support. I have a #LibreComputer Alta
@epn4littlefedi thanks. this is why we're testing with real users before releasing the code: to iron out those issues. We won't find all of them, but still...