By doing this the connections are all severed, the RAM is freed up, and it’s all good again.
Ah, neat! I didn’t think of that. You can limit the size of the connection pool in your lemmy config fwiw.
Nice, that looks like it’s doing a similar thing to my weird mess of SQL and Python that I did last year haha
Good luck for the migration :)
cronjob to restart the backend lemmy container
Fair enough, that’d work. I run my database in a different pod to lemmy (I run this all in kubernetes), and I cannot restart that pod without causing an outage for a bunch of other things like my personal website. I ended up just needing to tune my config to have a maximum RAM usage and then configuring k8s to request that much RAM for the DB pod, so it always has the resources it needs.
pictrs image cache is 250-300gb
oof :(
That’s what my custom lemmy patch was, it turned off pictrs caching. That’s now in lemmy as a config flag (currently a boolean but in 0.20 it will be on/off/proxy where the proxy option goes via your pictrs but does not cache). I then went back through mine and did a bunch of SQL to figure out which pictrs images I could safely delete and got my cache down to 3GB.
Interesting. I have some New Relic stuff setup with my cluster but most of that is just resource usage stuff. I ran out of RAM a while back so I’ve had to be a bit more restrictive about how many connections Lemmy can have to postgres db.
There’s no progress meter and so far it has taken 2 days 😱.
Uh oh. I considered updating to 0.5 as part of my 0.18.3-ish (I was running a custom fork I made with some image caching stuff that has since been merged in to real lemmy) -> 0.19.3 upgrade but I’m glad I didn’t.
Thanks for the heads up. Are you migrating to postgres for pictrs too, or sticking with sled?
These are pretty neat graphs! Is it sourced from the Prometheus logs?
Just updated to 0.19.3 but the DB migrations failed due to a permissions change I made a while back to my DB, so I had to spend a few hours in the SQL dungeons fixing things.
Yeah, I’m not justifying the annexation.
Technically only some of HK was under the lease, some was indefinitely controlled by the British. However, you’re still right because of the military force difference.
The web is built on hot linking hypermedia. It is more fragile obviously, but it distributes the bandwidth and storage load. If nobody hotlinked, then small forum admins/Lemmy admins/etc. have considerably more cost to bear.
As a compiler developer this speaks to me on a deep level lol
You need everyone else in the EU to agree to remove them. Poland and Hungary sort of protect each other from EU consequences.
ARM, but Apple has the most advanced ARM chips and macOS /The AS Platform has the best amd64 to arm64 translation layer.
I mean at that point you’re basically running macOS 😉
I couldn’t imagine buying any laptop other than a Mac because the performance to battery life ratio on everything else is awful. Plus if you want a UNIX system, it’s an easy buy.
After owning an Apple ARM laptop I’d never go back to anything else.
I don’t think there’s any malice here. Someone just forgot to put up a robots.txt on the bard website.
I don’t think the RF can count as a direct successor state when Ukraine was also a member of the USSR.
The UN has not resolved that the Russian Federation is the Soviet Union w.r.t. veto powers. It’s just been assumed. For the PRC there was an actual vote.
Ukraine legally has just as much of a right to the Soviet Union veto.
Couldn’t the general assembly just acknowledge that the RF does not inherit the Soviet Union veto? Same way that they stripped Taiwan of their veto. I don’t think that would require a security council vote.
Wow that website is cancer to load on mobile.
eh I use Linux on my desktop but macOS is a nicely polished UNIX operating system. It’s only locked down for average users, you can usually get away with a quick sudo or worst-case going into single user mode and disabling some system protections.
I definitely prefer using *nix operating systems, and macOS gives me that for portable computing. I’m still more productive on Linux, but it’s not too far apart.
Wow another coup in francophone Africa. I wonder if the regional democratic powers not intervening in Niger encouraged this.
I’ve used a number of different Linux distros (including Debian) on laptops over the years. Although most recently my XPS 15 was running Arch.