Synapse database maintenance tools

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.

Warning 1, 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.

Warning 2, what contents, the next command applies to local_content local_thumbnails remote_content remote_thumbnail (that are the subdirectories of media directory), remote content should use Purge History API, and maybe you want to delete just the local_content ?

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

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

I think this section is missing some coherence with the database structure