The high CPU issue that is causing midwest.social to slow way down and timeout on HTTP requests is still a mystery to me. But, it seems to do it less often and for less time now.

Here is CPU usage over 24 hours:

It’s a bunch of SELECT statements in Postgres that all seem to fire at one time and take a while to complete as a batch. I’ve inspected the logs and haven’t seen anything unusual. Just stuff federating and posts receiving upvotes.

  •  pelotron   ( @pelotron@midwest.social ) 
    2•10 months ago

    Any updates on server stability lately? I’ve been having a lot of connectivity issues the last couple days, and just saw this post on lemmy.world that was pretty interesting.

    @seahorse@midwest.social have you been dealing with performance problems like this?

    (side note, how do you embed a link to another instance that will let midwest.social users stay logged on?)