darkdrgn2k

https://github.com/tomeshnet/mesh-packages

Find which rooms have biggest `state_groups_state` `select count(*), room_id from state_groups_state group by room_id order by count(*) desc` ``` count | room_id ----------+--------------------------------------------------- 70989351 | !iEiJZbwrOzEkZNjsYf:matrix.org 36962954 | !YYtOqtdMtFNanKzfuQ:matrix.org 34975380...

Script to purge unused data # User MUST be server admin ``` # Get Token USERNAME="@username:tomesh.net" TOKEN=$(sudo -u postgres -i psql -d synapse -A -t -c "select token from access_tokens...

script to purge 3 years worth of data from all rooms ``` # Get Token USERNAME="@username:tomesh.net" TOKEN=$(sudo -u postgres -i psql -d synapse -A -t -c "select token from access_tokens...

Vacuuming vacuum full takes a long time `VACUUM ANALYZE` Should be enough Status of vaccume * Does not work on FULL backup ```` select * from pg_stat_progress_vacuum; ```` List all...

Synapse Debugging - Added promethus metrics https://github.com/matrix-org/synapse/blob/develop/docs/metrics-howto.md

IPFS site upload from existing running site. ``` wget \ --recursive \ --no-clobber \ --page-requisites \ --html-extension \ --convert-links \ --restrict-file-names=windows \ --domains tomesh.net \ --no-parent \ tomesh.net cd tomesh.net...