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.

  • RoundSparrow @ SJW
    link
    fedilink
    arrow-up
    2
    ·
    edit-2
    1 year ago

    Your image didn’t show up.

    Is it PostgreSQL process that is going high CPU, or the lemmy_server process, or lemmy-ui?

  • Green_Bay_Guy@lemmy.ml
    link
    fedilink
    arrow-up
    2
    ·
    1 year ago

    Yo, I’m a network engineer, also from the Midwest (Living in Vietnam). Do you have a discord or chat platform where I could be of any help?

  • Arindrew@midwest.social
    link
    fedilink
    arrow-up
    2
    ·
    1 year ago

    Has the influx of new members exacerbated this issue? I found this thread because I’m seeing a few ‘504 Gateway Timeout’ errors occasionally.

  • pelotron@midwest.social
    link
    fedilink
    arrow-up
    2
    ·
    edit-2
    1 year 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.

    @[email protected] 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?)

    • seahorse [Ohio]@midwest.socialOPM
      link
      fedilink
      arrow-up
      1
      ·
      1 year ago

      Unfortunately it still happens, just not nearly as often as it used to. Need to meet up with my database admin to get to the bottom of the issue.

    • Recreational Placebos@midwest.social
      link
      fedilink
      arrow-up
      1
      ·
      1 year ago

      I’ve been having timeout and 404 issues since I created my account last week. Typically can’t browse more than 5 minutes before I start getting timeouts, which can last for several minutes to several hours before anything loads again. Thought it was a gerboa issue at first, but I’m using a browser now and getting them too.

  • simsym@midwest.social
    link
    fedilink
    arrow-up
    1
    ·
    2 years ago

    Have you reached out to anyone else who runs a Lemmy server and seen if they are also experiencing this?

    Do you think it is a bottlekneck or just due to large updates from other servers?