So let's see how this works out:
This setting should delete all public posts from other server with no user on my server owning them after 90 (??) days, that's the first setting.
The second setting should expire all external posts owned by some user locally.
I think #Friendica picked up to work on the cleanup and expiry this last hours, I can see 2000 open task in the queue.
I did this because the database was getting bigger and bigger an I heard other server do this as well, so when I read that my database is bigger than other public server database I started thinking.
#support
// clean up the database
$a->config['system']['dbclean'] = true;
$a->config['system']['dbclean-expire-days'] = 600;
This setting should delete all public posts from other server with no user on my server owning them after 90 (??) days, that's the first setting.
The second setting should expire all external posts owned by some user locally.
I think #Friendica picked up to work on the cleanup and expiry this last hours, I can see 2000 open task in the queue.
I did this because the database was getting bigger and bigger an I heard other server do this as well, so when I read that my database is bigger than other public server database I started thinking.
#support
Dieser Beitrag wurde bearbeitet. (vor 2 Wochen)
6 Personen mögen das
utzer vor 2 Wochen
utzer vor 2 Wochen
I see it deletes batches of 1000 items.
From the log, a grep of "DBClean.php":
2018-04-10T03:52:13Z@wrk5acc308c562dd5.40710157 [NORMAL]:DBClean.php:334:removeOrphans Done deleting 1000 conversations. Last created: 2017-05-02 18:37:31
2018-04-10T03:52:18Z@wrk5acc34f2d9aff9.63383735 [NORMAL]:DBClean.php:318:removeOrphans Deleting old conversations. Last created: 2017-05-02 18:37:31
2018-04-10T03:52:21Z@wrk5acc34f2d9aff9.63383735 [NORMAL]:DBClean.php:324:removeOrphans found old conversations: 1000
utzer vor 2 Wochen
utzer vor 2 Wochen
Also I think the DB will shink much more from its current 35 GB for 2,75 years.
utzer vor 2 Wochen
Impressive, who did program the cleanup anyway? @Michael Vogel were you involved? Thanks for that feature.
utzer vor 2 Wochen
That 6 days account for about 100 MB, very roughly.
Michael Vogel vor 1 Woche
utzer vor 1 Woche
The main part of the feedback is "it works well, just activate the function and wait for it to finish".
utzer vor 2 Wochen
®ℹ️©µ@®🇩 vor 2 Wochen
utzer vor 2 Wochen
utzer vor 2 Wochen
®ℹ️©µ@®🇩 vor 2 Wochen
utzer vor 1 Woche
Done deleting 1000 conversations. Last created: 2017-07-20 12:54:39
It is going on and on and on... I am still impressed by this process.
utzer vor 1 Woche
I did not yet optimize anything manually.
utzer vor 7 Tage
utzer vor 6 Tage
Ingo Jürgensmann vor 6 Tage
utzer vor 6 Tage