Search

This is an automated archive made by the Lemmit Bot.

The original was posted on /r/soccer by /u/timdeking on 2023-10-25 13:45:06.

UEFA handed out two additional fines: One €26K fine for people standing on the stairs and another €8K fine for lighting two flares in the crowd.

Hello,

In the last 24 hours my instance has been experiencing spikes in CPU usage. During these spikes, the instance is unreachable.

The spikes are not correlated with an increase in bandwidth use. They are strongly correlated with IOPS spikes, specifically with read operations.

Analysis of htop during these spikes shows /app/lemmy and the postgres database UPDATE operation as the potential culprits, with the postgres UPDATE being my main suspicion.

Looking through the postgres logs at the time of these spikes, I think that this block may be associated with these spikes:

::: spoiler spoiler

 undefined

    


2023-06-19 14:28:51.137 UTC [1908] STATEMENT:  SELECT "comment"."id", "comment"."creator_id", "comment"."post_id", "comment"."content", "comment"."rem