this post was submitted on 02 Aug 2023
295 points (98.7% liked)

Lemmy NSFW

11926 readers
3 users here now

Updates about lemmynsfw.com

founded 1 year ago
MODERATORS
 

Hey yall, just wanted to chime in with a quick update on why we were down and have gone down a few times these past few days.

So... for those who don't know a bit on the backend way of how lemmy works right now, it's a lil more than a mess. Lemmy itself uses very little computing resources, you could probably run a decent instance on a toaster (I wouldn't suggest it though) but the problem that arises rapidly is the way photos are managed. The photo database downloads images both that are uploaded and federated. There is an option to disable caching for federated NSFW posts by unchecking enable NSFW within the instance admin panel. That's the only option related disabling federated images as of right now.

You see where I'm going with this, with this instance being as large as it is? Our photo database has been filling up pretty rapidly. We are attempting to troubleshoot solutions to prevent caching all federated content. Unfortunately as our backend team is attempting to figure that out, our pictures database just keeps ballooning more and more.

We have deleted some stuff in hopes to give more time, but we unfortunately have no choice but to migrate to object storage ASAP. Tomorrow there will likely be downtime as we migrate things over, and unfortunately there is no telling how long that will take.

Thank you for being patient and understanding while we navigate this. If you want to see updates to our status when we go down, check out our mastodon page here or come to our matrix public operations channel for updates (link in the sidebar.)

Things should work today though. Emphasis on should.

We are working on open collective still, but hosting this instance does cost money. If you are able to, donations are greatly appreciated. Especially as we will have to factor in object storage into our costs now.

you are viewing a single comment's thread
view the rest of the comments
[–] monkofapathy@lemmynsfw.com 64 points 1 year ago (10 children)

Yeahhhhh you don’t want to store images in a database. That will kill the database in a hurry. Store references to object storage.

[–] gavi@lemmynsfw.com 41 points 1 year ago (9 children)

It's ironic cause object storage for pictrs is a relatively new feature

[–] Innocent_Bystander@lemmynsfw.com 5 points 1 year ago (2 children)

You haven't clarified yet as to whether or not you were storing the actual image data in the database....

[–] gavi@lemmynsfw.com 2 points 1 year ago (1 children)

That’s how Lemmy does so by default. I wish I was kidding 🙃

I'm not sure how it still surprises me that someone could be THAT stupid. Yes it's called a "data"base, but it's for storing meta data, and short text data, not images/video/PDFs. Fucking carpenters always using a hammer for any job and plumber using a crescent as a hammer. Insane.

[–] Anafabula@discuss.tchncs.de 1 points 1 year ago

Lemmy uses pict-rs for image storage, which can store on the filesystem or object storage (filesystem is the default) and Lemmy's default config doesn't seem to change that

load more comments (6 replies)
load more comments (6 replies)