Skip to main content

@Friendica Support My #friendica instance is running for about 1 year now and the database has grown to 9.9GB. I found out about the remote items today and set the threshold to 20 days. After running the worker some 100 MB were gone from the database, but after running OPTIMIZE TABLE it is back on 9.9GB.

My instance has only one user. What can be the reason for such a lot of used space?
How did you run the worker?
It seems to be doing most cleanup at mignight.
It is run every 10 minutes by cron, so I started it on the command line. It took a reasonable time to return, the next direct call came back in seconds.

But if there is something like sub worker jobs that are not run every time, I will wait until tomorrow.

Thanks for the hint.
The cleaning of remote items is done as a background task that runs with a low priority. It runs in small chunks. So expect it to last several days. However, I wouldn't do 14 days, discussion threads can last longer as that - I suggest something like 6 months.