unsure if this (the screenshot) is normal but the moment someone with a ton of followers replied to me all i could see for 10 seconds was the light of heaven. aka a white screen. i think i should increase the number of open connections now
Timeline
Post
Remote status
Context
2okay doubled the number of open postgres connections. hopefully 40 will be more than enough to handle any sort of natural cavalry that slams fanimations
@kirby I've noticed this too. When Mastodon sees your post for the first time, it starts making various queries, some of them are expensive (e.g. fetching replies). When hundreds of Mastodon servers do this at the same time, the instance may become unresponsive.
In my case, the bottleneck is likely the number of database connections in mitra's connection pool, which by default is proportional to the number of CPU cores. How many CPU cores do you have on your machine?
Replies
2
@silverpill @kirby It's the click of death, you can't really do much about it besides in-memory caching objects and actor representations. The load can easily go to 500 r/s for 30 seconds or more.