9

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.

you are viewing a single comment's thread
view the rest of the comments
[-] RoundSparrow@sh.itjust.works 2 points 1 year ago* (last edited 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?

[-] seahorse@midwest.social 4 points 1 year ago

It's fixed. Was an inefficient database query.

[-] RoundSparrow@sh.itjust.works 3 points 1 year ago

Did you hand-modify lemmy_server? is there a code change/pull request to share?

Thank you.

[-] seahorse@midwest.social 2 points 1 year ago

I manually modified the activity table. I'll find the migration that didn't run.

this post was submitted on 21 Dec 2022
9 points (90.9% liked)

main

1335 readers
1 users here now

Default community for midwest.social. Post questions about the instance or questions you want to ask other users here.

founded 3 years ago
MODERATORS