It seems that I finally solved the problem. I added a new index for table posts. All these days I've been testing a new index and the problem has gone. I added an index for the next fields: parentid, topicid, status, private.
Hi Anton, Β Thank you for finding a solution using MySQL 5.6. Β I also am on a shared server so I can't upgrade to 5.7. Β I clicked on the screen shot you gave but could not follow it. Would you be able to provide a walk through to what you did? Β
Hi @antonm . Thank you for sharing your Solution for the Q & A Layout.Β I noticed the same "pagination issue" on the "Threaded Layout" as well and created a post.Β Robert is correct to have shared that it is a Database issue.Β πΒ
It's good that community members here can share solutions!Β Good luck and God bless you!