grafspeek
the poast matrix server has stored state events from the matrix HQ room since March 2021. a state event is a funny thing, you see matrix stores information about everybody it comes across. if you join matrix HQ on the poast matrix server it's now tracking the online/offline status of everybody (40K+ users) in the room as well as all their device information, their joins, parts, their name changes, avatar changes. and this persists across room versions. multiply thousands of people 24/7 hours a day opening the app, closing the app, changing their profile picture whatever. our matrix server, despite the channel not being on our server, tracks and stores all that information.
but graf, the server software suite should come with adminitration tools baked in to help administrators deal with this knowing that it's a massive bloat and uncontrollable. a-ha see, thats where you're wrong kid. they even know its so bad it's got it's own label for issues on their github
https://github.com/element-hq/synapse/labels/A-Disk-Space
i've been wrangling this fucking database since the beginning of the year, and the end is in sight but this one specific room has more than 4.8 billion (with a 🅱️) state events. all of that orphaned data since we have no users in that room.
is it retarded design? absolutely. even the developers say "yep, thats the current state of things"
anime graf mays 🛰️🪐 /
npub1k7…082aq
2024-07-19 03:54:12
in reply to nevent1q…7dyf
Author Public Key
npub1k7nhatxzadxe7c60zqy23zqg7844w8dfpj5qwmcj3xp47x7s3stqm082aqPublished at
2024-07-19 03:54:12Event JSON
{
"id": "c56337f764c611a04ecbd9c638147b5067be5c9ded8b156abb939a281675fed9",
"pubkey": "b7a77eacc2eb4d9f634f1008a88808f1eb571da90ca8076f1289835f1bd08c16",
"created_at": 1721361252,
"kind": 1,
"tags": [
[
"p",
"60dc60fbad51cfdedebff54feb0c5a37b98d21666400eb7a968940acf6ef73f1"
],
[
"e",
"5bdb2e027f67e75986ea5f8e074b0810969ba0c26a0a60be92cd2b9a6ab62988",
"",
"reply"
],
[
"e",
"ffae6912639907c2ffb2d58de12eed6e9405456350ec2ceb6b333e9c5fb3f28c",
"",
"root"
],
[
"p",
"b7a77eacc2eb4d9f634f1008a88808f1eb571da90ca8076f1289835f1bd08c16"
],
[
"proxy",
"https://poa.st/objects/dff2d2b9-d9cf-4eb2-ac86-2010bf05b56a",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://poa.st/objects/dff2d2b9-d9cf-4eb2-ac86-2010bf05b56a",
"pink.momostr"
],
[
"-"
]
],
"content": "grafspeek\n\nthe poast matrix server has stored state events from the matrix HQ room since March 2021. a state event is a funny thing, you see matrix stores information about everybody it comes across. if you join matrix HQ on the poast matrix server it's now tracking the online/offline status of everybody (40K+ users) in the room as well as all their device information, their joins, parts, their name changes, avatar changes. and this persists across room versions. multiply thousands of people 24/7 hours a day opening the app, closing the app, changing their profile picture whatever. our matrix server, despite the channel not being on our server, tracks and stores all that information.\n\nbut graf, the server software suite should come with adminitration tools baked in to help administrators deal with this knowing that it's a massive bloat and uncontrollable. a-ha see, thats where you're wrong kid. they even know its so bad it's got it's own label for issues on their github\n\nhttps://github.com/element-hq/synapse/labels/A-Disk-Space\n\ni've been wrangling this fucking database since the beginning of the year, and the end is in sight but this one specific room has more than 4.8 billion (with a 🅱️) state events. all of that orphaned data since we have no users in that room.\n\nis it retarded design? absolutely. even the developers say \"yep, thats the current state of things\"",
"sig": "13491b9e584362feebb6e0b9029ce930225e976fa72d7df27d2445fce6fff5d6f1135ea6b7b69b32d06d47eb84732dee49cc32aba20cfd3a85d47770431697ea"
}