Submitted 1 year ago by youpie@lemmy.emphisia.nl to selfhosted@lemmy.world
My lemmy instance seems to be using a lot of storage, I am the only one using it and for like 10 minutes a day. it’s currently using about 122 gb, after about 3 months of usage
~/l/volumes> sudo du -d 1 -h . 47G ./pictrs 75G ./postgres 0 ./lemmy-ui 122G .
seeing the usage of other ppl this seems really big? Am i doing someting wrong?
You used one of these subscribe to all community scripts, no? Otherwise it is hard to reach these figures as a single user instance.
However for the memory, I also have a hard time understanding why it eats up all ram. I am currently restarting the Lemmy backend twice a day to prevent the database from using all the memory and the system subsequently running out of memory. It definitely looks like some sort of memory leak, but not all instances seem effected. I already tried a few things to fine-tune the database and pool size etc. but it doesn’t seem to help.
oh I used like a tool to speed up federation, maybe that caused it? it was called lcs maybe that caused it?
yes, mostly. This tool basically instructs your lemmy instance to try and fetch the entire Lemmyverse and mirror it on your server.
I don’t remember which update it was but newer versions of Lemmy use significantly less database storage.
It reduced it shortly, but the activity table is still (unecessarily) caching most of the lemmyverse for 3 months AFAIK.
Our database went from 30GB or so down to 7GB with that update, but now it it back to 30GB or so. I even did a full database vaccuum lately, but it only shaved off 2-3GB or so.
If my understanding is correct, then the activity table probably doesn’t need to store more than a week or so, instead of the current 3 months. But this is something hard-coded in Lemmy and can’t be easily configured.
It’s all the images being cached from other servers. If you haven’t uploaded any images to your instance, you can just delete the content of the pictrs folder.
This will also delete all the user and community avatars though, as sadly Lemmy does not distinguish these from other images.
Wasn’t it a single user instance?
And if i did upload images on my instance haha
Then you would also have to delete those images. Unfortunately, there’s no easy way to delete the cache of images that pictrs stores :(
pnutzh4x0r@lemmy.ndlug.org 1 year ago
Could be what communities you are subscribed to. I run a small instance with about 3ish users, and here are my stats after about 3 months as well:
What version of lemmy are you using? A recent update also introduced some space savings in the database (I think).
youpie@lemmy.emphisia.nl 1 year ago
how do i check what version i am using?
walden@sub.wetshaving.social 1 year ago
If viewing in a web browser, scroll to the bottom of the page. It’ll say something like “BE: 0.18.5”.