!Hubzilla Support Forum
+ I want to shrink my database. I know one of the methods of doing this is to set an expiry on posts. I know my original content, starred posts etc will be kept, but my question is how should I see this happen.
If I set an amount in days, is this triggered at my next cron job? If I go from 0 (unlimited) to n days and the difference is a large number, is it best to do this in smaller chunks so I don't cripple my server?
I also know that the DB won't necessarily free up all the reclaimed space, so how do I intelligently reclaim using the VACUUM command in mysql.
Thanks in advance.