实时更新主题在高活动下冻结

[ljpp]

为了排除问题，我将服务器升级到了 8 个 vCore 和 32GB 内存。我将数据库缓冲区设置为 16GB，Unicorn 进程数设置为 16。其他调整已恢复默认。

不幸的是，这次升级效果甚微。即使是中等活跃度的讨论，也频繁出现卡顿。

现在的性能令人失望。我想我需要开始关注 Prometheus 等监控工具了。我有 95% 的把握认为，自 v2.3 版本以来，软件的性能严重倒退。

@Iceman 兄弟在九月份的评论基本被忽视了。他报告称，无论他投入什么硬件，卡顿问题都会发生？

Improving Instance Performance (Megatopics, Database Size and Extreme Load)

From my experience this is not directly solved by any current approach or has a linear solution. In fact, separating them in different machines is not an instant solution for that issue. We also experience heavy drops and “the site is extremely busy so you are seeing it as someone that isn’t logged in” messages when a big event happens (such as a game, like @ljpp said), and that drags down the whole site, not only the people inside that topic. So, I tried two different things, a separated setu…