Lemmy Support

4926 readers

6 users here now

Support / questions about Lemmy.

founded 6 years ago

MODERATORS

submitted 2 years ago by ablackcatstail@lemmy.goblackcat.com to c/lemmy_support@lemmy.ml

8 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 7 comments

sorted by: hot top controversial new old

[–] SeeJayEmm@lemmy.procrastinati.org 5 points 2 years 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 2 years ago (1 children)

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

[–] SeeJayEmm@lemmy.procrastinati.org 4 points 2 years ago

[–] Nugget@lemm.ee 4 points 2 years 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

[–] ablackcatstail@lemmy.goblackcat.com 1 points 2 years ago

Thank you!