DamonT Posted August 3, 2019 Posted August 3, 2019 Hi, my site works on newest version of forum (but this problem was visible earlier too). Loading of Unread Content stream is slow - especially on my admin account (it is much faster on test user account). The page with stream is slow regardless of how much content there is. This is the screen from openning page with Unread Content strem in case that there is no unread content: And there the same stream if I click "Mark site read" ealier: It works much faster, but after several visits there is same problem with slow loading. I don't understant why there is such different - there was no unread content in both cases... The page speed is low if there is some unread content too. I am using PHP 7.3 and Redis for datastore, cache, sessions and topic views. The forum is not big - there is no more than 100 new post per day. Any idea what should I check?
Joel R Posted August 4, 2019 Posted August 4, 2019 Do you have any plugins that hook into / add items to the Activity Stream? Are you loading items from any third party apps? You shouldn't see a noticeable difference in loading speed of the streams.
marklcfc Posted August 4, 2019 Posted August 4, 2019 I've had an issue for over two years where it is slow where there is a page of unread topics at most. (so not long after marking as read). But soon as the topics increase and Load more activity works, meaning there are 2 pages, the first page becomes fast, but then the second page is slow (when clicking load more). etc. And so on, so when there are 3 lots of pages, 1 and 2 are fast, 3rd becomes slow. Basically have you found it loads fast when there is an extra page of unread topics / Does it just load slow on the first lot of unread topics? Desperate for a solution but given up hope, I found elasticsearch fixes it but creates other problems.
DamonT Posted August 4, 2019 Author Posted August 4, 2019 21 minutes ago, Joel R said: Do you have any plugins that hook into / add items to the Activity Stream? Are you loading items from any third party apps? No, I don't have anything like this. Is there any way to debug this issue? What can I check?
bfarber Posted August 5, 2019 Posted August 5, 2019 19 hours ago, DamonT said: No, I don't have anything like this. Is there any way to debug this issue? What can I check? Ask your host to (temporarily) enable MySQL slow query logging, then after they've confirmed it is enabled visit your unread content stream to trigger the issue (and capture the query that is being ran), and then you can ask your host to shut off slow query logging. With the logged query/queries, submit a ticket.
DamonT Posted August 5, 2019 Author Posted August 5, 2019 @bfarber ok, we will do it. How we should specify long mysql query in this case? Do you think that we should see something with 1 second setting?
DamonT Posted August 6, 2019 Author Posted August 6, 2019 Fun fact... I made my own stream with identical setting as default Unread Stream and it works fast. Only default Unread Stream is slow. Tested on the same account. Do you have any idea why new one is faster? Default vs my new stream which is fast:
bfarber Posted August 6, 2019 Posted August 6, 2019 7 hours ago, DamonT said: Do you have any idea why new one is faster? Not without looking at your site through a ticket. On 8/5/2019 at 9:16 AM, DamonT said: Do you think that we should see something with 1 second setting? Maybe 5 seconds? How long does the query take to run? I'm not sure we're going to be able to look into too many queries taking 1 second to run. "Slow" is of course subjective.
DamonT Posted August 6, 2019 Author Posted August 6, 2019 Ok, I sent ticket and Marc told me that I have to change some tables to INNODB. I made this change and I am doing some test right now 🙂
Recommended Posts
Archived
This topic is now archived and is closed to further replies.