Conversation

Notices

1. Embed this notice
   SuperDicq (superdicq@minidisc.tokyo)'s status on Friday, 07-Jun-2024 22:12:15 JST SuperDicq

   Had to nuke the queue. Could be missing some interactions of the past 13 hours.
   
   Also CDROM is fucked and refuses to process activities at the moment so I also gotta get on that.
   
   I'm really running into IO issues. My instances have really grown too much to be able to run HDDs anymore. SSDs are gonna be required to fix things longterm which means I gotta spend money and do a migration.
   
   Any tips on how to lower IO usage for Akomma/postgress are very much appreciated for now.

   • Embed this notice
     narcolepsy and alcoholism :flag: (hj@shigusegubu.club)'s status on Friday, 07-Jun-2024 22:17:04 JST narcolepsy and alcoholism :flag:

     in reply to
     @SuperDicq get better disks
   • Embed this notice
     SuperDicq (superdicq@minidisc.tokyo)'s status on Friday, 07-Jun-2024 22:17:23 JST SuperDicq

     in reply to

     • narcolepsy and alcoholism :flag:

     @hj@shigusegubu.club Yeah as I said that's an issue because that costs money and takes time to migrate.

     narcolepsy and alcoholism :flag: likes this.
   • Embed this notice
     narcolepsy and alcoholism :flag: (hj@shigusegubu.club)'s status on Friday, 07-Jun-2024 22:18:24 JST narcolepsy and alcoholism :flag:

     in reply to
     @SuperDicq besides a ramdisk (which is dangerous) i don't think you can do anything, really.
   • Embed this notice
     SuperDicq (superdicq@minidisc.tokyo)'s status on Friday, 07-Jun-2024 22:19:55 JST SuperDicq

     in reply to

     • narcolepsy and alcoholism :flag:

     @hj@shigusegubu.club You think my 5 year old Pleroma/Akkoma database with over 1200 users still fits inside RAM?

   • Embed this notice
     narcolepsy and alcoholism :flag: (hj@shigusegubu.club)'s status on Friday, 07-Jun-2024 22:22:35 JST narcolepsy and alcoholism :flag:

     in reply to
     @SuperDicq with compression, maybe, but not really.
   • Embed this notice
     Xeon² (izaya@social.shadowkat.net)'s status on Friday, 07-Jun-2024 22:23:41 JST Xeon²

     in reply to
     @SuperDicq moving the postgres WAL onto SSD would be cheaper than going full SSD and should help somewhat, as I understand it
   • Embed this notice
     SuperDicq (superdicq@minidisc.tokyo)'s status on Friday, 07-Jun-2024 22:23:41 JST SuperDicq

     in reply to

     • Xeon²

     @izaya@social.shadowkat.net Yes if only my server still had unused SATA slots that I could just hook an SSD into.
     
     I really have to replace everything with SSDs with my setup or it's a no go.

   • Embed this notice
     SuperDicq (superdicq@minidisc.tokyo)'s status on Friday, 07-Jun-2024 22:36:01 JST SuperDicq

     in reply to

     I also nuked the oban queue on CDROM, seems to work (for now).

   • Embed this notice
     Xeon² (izaya@social.shadowkat.net)'s status on Saturday, 08-Jun-2024 03:55:53 JST Xeon²

     in reply to
     @SuperDicq mmmh if you're all out that puts you in a spot
     glglgl
   • Embed this notice
     SuperDicq (superdicq@minidisc.tokyo)'s status on Saturday, 08-Jun-2024 03:55:53 JST SuperDicq

     in reply to

     • Xeon²

     @izaya@social.shadowkat.net Funny things about my disk usage is that because of the Postgres crap running constantly even my torrents downloads are now capped at around 20 MB/s.

   • Embed this notice
     SuperDicq (superdicq@minidisc.tokyo)'s status on Saturday, 08-Jun-2024 03:56:28 JST SuperDicq

     in reply to

     • Xeon²

     @izaya@social.shadowkat.net I PAID FOR THE WHOLE DRIVE IM USING THE WHOLE DRIVE

   • Embed this notice
     narcolepsy and alcoholism :flag: (hj@shigusegubu.club)'s status on Saturday, 08-Jun-2024 03:57:17 JST narcolepsy and alcoholism :flag:

     in reply to

     • Xeon²
     @SuperDicq @izaya Ryan gosling when Ryan stopling walks into the scene
   • Embed this notice
     SuperDicq (superdicq@minidisc.tokyo)'s status on Saturday, 08-Jun-2024 04:08:51 JST SuperDicq

     in reply to

     • Mario 🔒

     @mario@don.tbully.me I'll upgrade to SSDs eventually

   • Embed this notice
     Mario 🔒 (mario@don.tbully.me)'s status on Saturday, 08-Jun-2024 04:08:53 JST Mario 🔒

     in reply to
     @SuperDicq fast access databases on HDDs do not work well.
     Look at your I/O timings, that's what killed contrapointsfan.club
   • Embed this notice
     SuperDicq (superdicq@minidisc.tokyo)'s status on Saturday, 08-Jun-2024 04:11:52 JST SuperDicq

     in reply to

     • Mario 🔒

     @mario@don.tbully.me Restarts don't do shit to me. I just have to the nuke the queue table whenever it gets constipated.

   • Embed this notice
     Mario 🔒 (mario@don.tbully.me)'s status on Saturday, 08-Jun-2024 04:11:53 JST Mario 🔒

     in reply to
     @SuperDicq in the meantime, hourly restarts of pleroma helped me :blobcathappy: