From 492fc5c42aaedbedd7f3523c6f0a35e2847142a4 Mon Sep 17 00:00:00 2001 From: H-Shay Date: Thu, 2 Dec 2021 17:46:48 +0000 Subject: deploy: 49e1356ee3d5d72929c91f778b3a231726c1413c --- .../administration/database_maintenance_tools.html | 20 ++++---------------- 1 file changed, 4 insertions(+), 16 deletions(-) (limited to 'develop/usage/administration/database_maintenance_tools.html') diff --git a/develop/usage/administration/database_maintenance_tools.html b/develop/usage/administration/database_maintenance_tools.html index f9e86c1bc6..807ce194bf 100644 --- a/develop/usage/administration/database_maintenance_tools.html +++ b/develop/usage/administration/database_maintenance_tools.html @@ -186,26 +186,14 @@

List of useful tools and scripts for maintenance Synapse database:

Purge Remote Media API

The purge remote media API allows server admins to purge old cached remote media.

-

Purge local media

-

There is no purge API for local media because you may be the only one with a copy. If you are sure you want to delete local media you could use something like the following to delete media that hasn't been accessed in a while.

-
find /path/to/synapse/media_store/local_content -atime +365 -delete
-find /path/to/synapse/media_store/local_thumbnails -atime +365 -delete
-
-

This will delete media that hasn't been accessed in 365 days.

-

Warning, check noatime flag: You also have to double-check that the filesystem where synapse's media store don't have noatime flag. Check it with mount, noatime is something that is usually enabled by default to reduce read-write operations in the filesystem for a feature is not so demanded.

+

Purge Local Media API

+

This API deletes the local media from the disk of your own server.

Purge History API

The purge history API allows server admins to purge historic events from their database, reclaiming disk space.

-

synapse_janitor.sql

- -

Cleans a synapse Postgres database of deleted messages and abandoned rooms.

synapse-compress-state

Tool for compressing (deduplicating) state_groups_state table.

-

SQL for analyzing Synapse PostgreSQL database stats

-

Some easy SQL that reports useful stat about Matrix Synapse database.

+

SQL for analyzing Synapse PostgreSQL database stats

+

Some easy SQL that reports useful stats about your Synapse database.

-- cgit 1.5.1