@Hubzilla Support Forum
I've run my own Hubzilla instance since 2019, but I'm having some problems lately. I think most of it is caused by an overloaded machine, so cleaning stuff up is my first port of call.
My database has grown to 25GB, and I'd like to make it a lot smaller. I'm the only user on my hub, so it shouldn't need to be this big.
I notice I have items in it that date back to 2017, 2 years before I started this hub. I thought I had configured it to expire old stuff, but it turns out I hadn't. So I changed it to 2 years, everything older than 2 year can be removed. Running the Cron.php doesn't help, so I looked at its source and noticed that it selects the items to remove by expiry date.
I think I can simply set an expiry date on items that were created over 2 years ago and then run Cron.php, but before I destroy my instance, I'd like to hear your opinion first.
If that's indeed the way to go, do I set an expiry date on records in "item", or are there other things that need attention too?