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?
9 Comments
OutrageousUmpire@lemmy.world · 6 pts · 3y
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 pts · 3y
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 pts · 3y
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 pts · 3y
I don't have plenty of storage. I will have to upgrade at some point.
SeeJayEmm@lemmy.procrastinati.org · 5 pts · 3y
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 pts · 3y
Thank you! I would appreciate the help very much. Please take your time though.
SeeJayEmm@lemmy.procrastinati.org · 4 pts · 3y
https://github.com/LemmyNet/lemmy/issues/3103
Nugget@lemm.ee · 4 pts · 3y
There's a
DELETE /internal/variantsendpoint specified in the pictrs docs that might remove some extra data: https://crates.io/crates/pict-rsablackcatstail@lemmy.goblackcat.com · 1 pts · 3y
Thank you!