I’ve had a Lemmy instance running on a VPS with 100 GB of storage for a few months and it has filled up. I’ve been searching for ways to reduce the amount of storage used but so far I am coming up empty. Can anyone point me in the right direction?
Instead of using the hard drive for pictrs, I suggest using it’s S3 capabilities and migrating to bucket based storage. You’ll save way more money and keep the expensive VPS hard drive just doing text and DB things. I think I spend maybe a dollar a month in S3 storage.
bdonvr@thelemmy.club 11 months ago
Firstly move pict-rs to object storage. My instance’s pict-rs uses 130GB alone. I pay less than $2/mo to put it on Cloudflare R2. Backblaze B2 might be even cheaper. Instructions: crates.io/crates/pict-rs#filesystem-to-object-sto…
If that doesn’t help enough and you’re comfortable with SQL, you can purge the unnecessary entries in
received-activities
.Command:
delete from received_activity where published < NOW() - INTERVAL ‘3 days’;
Then do a
vacuum full received_activity;
to reclaim the space.This deleted 98 million entries for me and reduced my database size from 49GB to 20GB a week ago when ai started running out of space. No other effect as far as I can tell. Thanks @illecors@lemmy.cafe
TrinityTek@lemmy.world 11 months ago
Thank you, that SQL command looks like exactly what I’m after! I’m going to give that a shot. I appreciate the help!
MrRazamataz@lemmy.razbot.xyz 11 months ago
what is stored in
received_activity
? anything important? I mean obviously it’s something the instance has received from other instances but is this then stored somewhere else (like comments then stored elsewhere for eg)bdonvr@thelemmy.club 11 months ago
As far as I’ve been told it’s basically just a log of all received activities. Nothing references it.
Die4Ever@programming.dev 11 months ago
in v0.19.0 Lemmy will automatically delete entries over 7 days old
github.com/LemmyNet/lemmy/issues/4113
github.com/…/cb01427dcff14b3d88e30220695fc9797878…