From eaed07aa18ac9a135ffc31b9ca61a71dd54f3e02 Mon Sep 17 00:00:00 2001 From: DMRobertson Date: Tue, 29 Nov 2022 12:32:57 +0000 Subject: deploy: 8c5b8e6d40b28bd134326a8063992cdfeef7b60d --- .../administration/database_maintenance_tools.html | 201 +++++++++++++++++++++ 1 file changed, 201 insertions(+) create mode 100644 v1.73/usage/administration/database_maintenance_tools.html (limited to 'v1.73/usage/administration/database_maintenance_tools.html') diff --git a/v1.73/usage/administration/database_maintenance_tools.html b/v1.73/usage/administration/database_maintenance_tools.html new file mode 100644 index 0000000000..1636d7239d --- /dev/null +++ b/v1.73/usage/administration/database_maintenance_tools.html @@ -0,0 +1,201 @@ + + + + + + Database Maintenance Tools - Synapse + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
+ +
+ + + + + + + +
+
+ +
+ +
+ +

This blog post by Victor Berger explains how to use many of the tools listed on this page: https://levans.fr/shrink-synapse-database.html

+

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 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-compress-state

+

Tool for compressing (deduplicating) state_groups_state table.

+

SQL for analyzing Synapse PostgreSQL database stats

+

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

+ +
+ + +
+
+ + + +
+ + + + + + + + + + + + + \ No newline at end of file -- cgit 1.5.1