this post was submitted on 13 Jul 2023
17 points (100.0% liked)

Lemmy Support

4652 readers
1 users here now

Support / questions about Lemmy.

Matrix Space: #lemmy-space

founded 5 years ago
MODERATORS
dessalines@lemmy.ml
17
Recommendations on instance maintenance? (lemmy.goblackcat.com)
submitted 1 year ago by ablackcatstail@lemmy.goblackcat.com to c/lemmy_support@lemmy.ml
10 comments fedilink hide all child comments
 

My database is already getting to the size of almost 1GB so it made me think about some questions I have regarding maintenance of my Lemmy instance:

  • What cleanup is recommended on the database?
  • What is the default length of time that pictrs holds onto its cached data and how to clear the cache?
  • Any other recommendations you can think of?
top 9 comments
sorted by: hot top controversial new old
[–] OutrageousUmpire@lemmy.world 6 points 1 year ago* (last edited 1 year ago) (1 children)

You can store media in object storage (S3) to save a lot of money, although I haven’t made the transition yet. https://lemmy.eus/comment/165512

[–] ablackcatstail@lemmy.goblackcat.com 4 points 1 year ago (1 children)

I am currently self-hosting my Lemmy instance out of my home and reverse-proxied over a WireGuard tunnel. I suppose I am not in immediate danger. Is it possible to use S3 storage with my current setup?

[–] OutrageousUmpire@lemmy.world 5 points 1 year ago (1 children)

Yes I don’t see any reason why not, but if you are hosting at home you likely have plenty of storage yourself and might not want to mess with configuring S3

[–] ablackcatstail@lemmy.goblackcat.com 4 points 1 year ago

I don't have plenty of storage. I will have to upgrade at some point.

[–] SeeJayEmm@lemmy.procrastinati.org 5 points 1 year ago (1 children)

The activity table is by far the largest. There's an open issue to reduce the cleanup time on it. I can find it later.

[–] ablackcatstail@lemmy.goblackcat.com 2 points 1 year ago (1 children)

Thank you! I would appreciate the help very much. Please take your time though.

[–] Nugget@lemm.ee 4 points 1 year ago (1 children)

There's a DELETE /internal/variants endpoint specified in the pictrs docs that might remove some extra data: https://crates.io/crates/pict-rs

load more comments
view more: next ›