-

2025-02-11 11:48:24

Hubzilla Support Forum

adminsforum@hubzilla.org

Hiker wrote the following post Tue, 11 Feb 2025 11:48:34 +0100

Are there any tools to maintain the database? It is getting bigger and bigger...

- - -

2025-02-11 13:12:30

Harald Eilertsen

harald@hub.volse.no

@Hiker Which DB engine? Note that databases will normally not shrink their storage even when purging records, but they provide tools for reclaiming storage (essentially copying the data to new files, but without the gaps in the original data files.) See the docs for your database for how to do that.

2025-02-11 13:31:09

Mark Nowiasz

buckaroo@hub.netzgemeinde.eu

If you use MySQL (including all the different flavours, like mariadb, percona, whatever) you can try running mysqloptimize -v -A. This is a safe operation, the database won't go offline. But it could take some time, I usually do this once a week, and it takes at my site (140 GB DB) about 1h, so it's wise running it in a tmux/screen session. But you need some addtional disk space to perform this, so if you are very low on disk space this might not work.

2025-02-11 19:28:58

Hiker

hiker@fedhub.ch

I thought that Hubzilla has own tools to optimize the database - how long eg posts are store before deleted.