Skip to main content

It's mostly not the posts. Please have got a look at your biggest tables. Then we can check, which value is responsible.

Looks like you are storing the avatar pictures in the database. You can disable this via the admin setting "Cache contact avatars" in the "Performance" section. This will lead to slower page load, since the avatar pictures then need to be fetched from the remote contacts.

Also you can select this command to check for deprecated tables that aren't in use anymore:
bin/console dbstructure drop

With an additional -e you can then delete these tables, if it looks plausible for you.

Thanks for the hint, @Michael Vogel !!! I did not find the setting in the Web GUI, but in the /friendica/static/settings.config.php, I changed to:
---
cache_contact_avatar => false,
---
You need to set this in the frontend. The values in that config file are only used as a default. They are then later stored in the database.
@Michael Vogel I was looking for the settings in the frontend GUI (Settings and Admin section 1 x 1) but cannot find the parameters. Could they be hidden? I'm using the RC version of Friendica..
It's all at /admin/site. Much is in the "Performance" section.
#4 #1 #2 #3

You will have to fix the permissions in the specified folder.

BTW: i wouldn't call "German" exotic 😁

Worked!!! I created the needed directory and chmod -R to www-data:www-data. Now, my settings should result in regular cleaning of the DB, and I also set the max. image size to 5 MiB. I'll observe the server next few days.
Thanks to @Michael Vogel and the @Friendica Support !!
Well, compared to my daily driver (self-made), configured for Colemak (German, English, and Spanish) and Steno, any standard keyboard is exotic 😉.
Thanks again, @Michael Vogel !
I could not find the setting in the GUI, but in /static/settings.config.php I changed to 'cache_contact_avatar' => false,
Excelent, @MiKlo:~/citizen4.eu$💙💛 :
I set 'dbclean' => false, 'dbclean-expire-days' => 14, 'dbclean-expire-unclaimed' => 14, and 'dbclean_expire_conversation' => 14,