Conversation

Notices

1. Embed this notice
    (mint@ryona.agency)'s status on Tuesday, 25-Jun-2024 04:10:55 JST 
   :niggainsane:
   Screenshot_20240624_221024.png
   • ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
      (mint@ryona.agency)'s status on Tuesday, 25-Jun-2024 04:12:34 JST 

     in reply to
     Nigga has more posts than my whole two year old instance.
   • Embed this notice
      (mint@ryona.agency)'s status on Tuesday, 25-Jun-2024 04:18:44 JST 

     in reply to
     Also my idea of purging botposts to decrease size and improve performance might be a bit far-fetched, don't know how to properly amass them considering some people put bot tag on their actual account for whatever reason. Plus I'd want to keep the posts that were interacted with. Anyway, here's all activities, not just Create; standalone relays survived the previous purge.
     Screenshot_20240624_221700.png
   • Embed this notice
     franzhime (franz@ryona.agency)'s status on Tuesday, 25-Jun-2024 04:31:43 JST franzhime

     in reply to
     @mint are those post counts?
   • Embed this notice
      (mint@ryona.agency)'s status on Tuesday, 25-Jun-2024 04:31:43 JST 

     in reply to

     • franzhime
     @franz First screenshot is amount of Create activities (that correspond to posts, yes), second is amount of all activities, including likes/reposts/profile updates/etc.
   • Embed this notice
     franzhime (franz@ryona.agency)'s status on Tuesday, 25-Jun-2024 04:33:59 JST franzhime

     in reply to
     @mint that makes a lot more sense. at first I was like wow that’s a lot of posts.
      likes this.
   • Embed this notice
      (mint@ryona.agency)'s status on Tuesday, 25-Jun-2024 04:44:46 JST 

     in reply to
     29028731 total activities, I somehow misremembered it as being in hundreds of millions. 4074011 are from Service actors, so about 14%, not nearly as much as 1/3 that were taken up by announces from relays.
   • Embed this notice
      (mint@ryona.agency)'s status on Tuesday, 25-Jun-2024 05:03:20 JST 

     in reply to
     Anyway, purged 5% more total activities, that being dangling announces from standalone relays.
   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Tuesday, 25-Jun-2024 05:09:06 JST Lina Inver?e

     in reply to
     @mint :satsukicroquette:
      likes this.
   • Embed this notice
      (mint@ryona.agency)'s status on Tuesday, 25-Jun-2024 05:21:27 JST 

     in reply to
     Ok, why the fuck there are two replies counts, one of which always stays at zero and other only appears when there's at least one reply.
     Screenshot_20240624_231837.png
   • Embed this notice
     Pleroma-tan (kirby@lab.nyanide.com)'s status on Tuesday, 25-Jun-2024 05:24:52 JST Pleroma-tan

     in reply to

     @mint and I'm on the list. I am now a massive dork one of the elites

   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Tuesday, 25-Jun-2024 05:32:09 JST Lina Inver?e

     in reply to
     @mint is it me
   • Embed this notice
      (mint@ryona.agency)'s status on Tuesday, 25-Jun-2024 05:42:15 JST 

     in reply to

     • Lina Inver?e
     @lina You're fifth, but yes, you still got more posts than my whole instance. Either way, I think I might be able to trim around 5% more activities without losing anything of value.
     Lina Inver?e likes this.
   • Embed this notice
     Lina Inver?e (lina@eientei.org)'s status on Tuesday, 25-Jun-2024 05:43:52 JST Lina Inver?e

     in reply to
     @mint the ryukofag has gone insane
      likes this.
   • Embed this notice
      (mint@ryona.agency)'s status on Tuesday, 25-Jun-2024 05:54:26 JST 

     in reply to
     Doing it live, without the replica session mode might've not been the brightest idea.
     Screenshot_20240624_235327.png
   • Embed this notice
     Pleroma-tan (kirby@lab.nyanide.com)'s status on Tuesday, 25-Jun-2024 05:55:36 JST Pleroma-tan

     in reply to
     @mint oh is that why it took a bit to load the website
   • Embed this notice
      (mint@ryona.agency)'s status on Tuesday, 25-Jun-2024 06:03:39 JST 

     in reply to

     • Pleroma-tan
     @kirby It's done now, but I plan to go through two more instance, plus also prune orphaned activities after that.
     Pleroma-tan likes this.
   • Embed this notice
      (mint@ryona.agency)'s status on Tuesday, 25-Jun-2024 06:04:54 JST 

     in reply to

     • Pleroma-tan
     @kirby And also vacuum. Can't forget about vacuum, but I'll go to sleep at that point and wake up when it's done.
     Pleroma-tan likes this.
   • Embed this notice
      (mint@ryona.agency)'s status on Tuesday, 25-Jun-2024 07:40:02 JST 

     in reply to
     Autovacuum kicked in, hopefully won't be an issue. Phoenix dashboard reports estimated size of objects table at 15986416, which should be 18% smaller than before trimming the fat. Counting orphaned activities takes a while.
   • Embed this notice
      (mint@ryona.agency)'s status on Tuesday, 25-Jun-2024 07:40:15 JST 

     in reply to
     >hopefully won't be an issue
     It was, federation somehow halted. Counting orphaned activities still hasn't finished after 2200 seconds, which I assume was caused by it. Now it kicked in again, so I'll just stop pleromer for a second and try doing this with replica.
   • Embed this notice
      (mint@ryona.agency)'s status on Tuesday, 25-Jun-2024 07:43:19 JST 

     in reply to
     Autovacuum defeated with kill -9. Instance is spazzing out, running count again.
   • Embed this notice
      (mint@ryona.agency)'s status on Tuesday, 25-Jun-2024 16:22:58 JST 

     in reply to
     It's morning and the orphan activity cleanup is still running.
     ✙ dcc :pedomustdie: :phear_slackware: likes this.
   • Embed this notice
      (mint@ryona.agency)'s status on Tuesday, 25-Jun-2024 21:18:40 JST 

     in reply to
     Still running. FWIW, compressed SQL dump that was made by a cron job decreased in size from 9.3 gigs to 8.1.
     The MILF Messiah likes this.
   • Embed this notice
      (mint@ryona.agency)'s status on Wednesday, 26-Jun-2024 06:54:29 JST 

     in reply to
     Still running, hopefully it's going to be done tomorrow. Federation with nicecrew seems to be broken likely due to those dangling activities after pruning which might be confusing pleromer; either way it should be resolved after the orphan cleanup is done, maybe also a restart.