Idea-ahead

Marc, the problem is that the server configuration has not been changed and there have been no problems for many months. These started literally a few hours after the forum update to 4.7.19. There are currently no processes running in the background (e.g. backup).

For example, now for the past several minutes the forum has been running very slowly. https://www.psxextreme.info/

Oh, that's interesting, because I thought you might have fixed something. After logging into our panel, the problem disappeared. We didn't try to do anything.

Jim, everything is OK now. About 1-2 hours after my report I saw this in the dashboard: "This account was created when you recently contacted Invision Community Support so that our team could use it. If the issue has been resolved, you should delete this account." So apparently someone from your group logged in and something was fixed because the issue has gone away.

After the last forum update (4.7.19) on my server, there was a problem with a SQL query that takes a very long time to execute. It is most visible in large topics with more than 500 replies. Increasing the amount of RAM or CPU does not help much. /psxekstrema::psxmoder::IPS\Content_Item::_comments:2166/ SELECT forums_posts., author., author_pfields.* FROM ibf_forums_posts AS forums_posts LEFT JOIN ibf_core_members AS author ON author.member_id = forums_posts.author_id LEFT JOIN ibf_core_pfields_content AS author_pfields ON author_pfields.member_id=author.member_id WHERE forums_posts.topic_id=112736 AND (forums_posts.queued IN(0,2)) ORDER BY post_date asc LIMIT 0,25