• 41 Posts
  • 14 Comments
Joined 1 year ago
cake
Cake day: June 8th, 2023

help-circle










  • Hi, many thanks for the suggestions.

    There’s been a few notable events recently, and I like to keep important news up for a couple of weeks.

    I’ve now cleaned up those that are no longer relevant however. So this should no longer be as problematic.

    I think the general Welcome and Rules posts are always going to be relevant to new users, however I would like to be able to get rid of them for older users.

    I may have a look into a solution that will allow me to do this. But, not sure how successful I’ll be on that front!



  • From what I gather, the way it works is that once a user here has interacted with a remote community at least once, and subscribed to it, from then on, all activity that happens in that community is then automatically pulled across and stored inside this instance also.

    So if I subscribed to the “technology” community on “lemmy.world”, every post and comment, edit and deletion and I believe even votes and such made afterwards will then be synchronised across to this instance.

    Checking the database however, it actually seems that the post and comment data etc isn’t too large.

    The majority of the storage is actually taken by the “Activity” table.

    From what I can see, this table is used to basically store a log of everything the server has been told about. The actual contents are taken out into other tables. (Which are only a couple of hundred MB, rather than 20GB!)

    Lemmy does have an automatic cleanup of this table, but it only removes content older than 6 months.

    Since we only started in June, we’ve got an entire 4 months more data to go, and by the way things are going, that’s liable to total to potentially hundreds of gigabytes of data.

    The activity table had more data in it from the last 2 weeks than it did for the entire month and a half preceeding! (12 million activity records in 2 weeks, compared to only 11 million between the start of June and 2 weeks ago)




  • Hi Steve, Many thanks for this.

    The storage required for lemmy is indeed quite significant!

    I have no doubt further optimisations could be done there, but at present it’s an unfortunate truth that lemmy likes its storage!

    So far it’s eaten 21GB of database space in less than 2 months, and again, that’s all text!

    I’m a software developer and my largest production database I’ve ever had has only been around 100GB after around 15 years of usage.

    Posts and messages from hundreds of thousands of users globally just take a lot of space I guess haha! (Though it would be nice if lemmy only cached remote posts for say, a day or a week, and then wiped the content from its local cache and called out to the remote server thereafter)

    I’m very averse to asking for donations! I don’t want anyone to have to pay to access CompuVerse, and donations, whilst greatly appreciated would feel wrong to take. Plus there’s then further complications regarding how to receive said donations, any taxes involved etc. etc. which I quite frankly can’t be bothered to deal with haha!

    I really do want to avoid taking donations if at all possible :)














  • This is a good question, I’m not actually sure to be honest with you.

    So far I’ve heard nothing about the main project receiving any sort of threats, and even the Steam page wasn’t officially DMCAd or the like. It was more of a threat saying they WOULD officially DMCA if the project wasn’t taken down.

    It’s very interesting that it was played like this rather than just officially issuing a DMCA takedown request. Almost like they weren’t 100% convinced the official DMCA would actually hold up?