Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Grumpy Posted September 7, 2012 Posted September 7, 2012 Yeah, is your forum running 3.2? I did the test on 3.3.4.
PeterUK Posted September 7, 2012 Author Posted September 7, 2012 Interesting, I take it you made sure a post was made in between each time you tried to run the query? Otherwise it would be stored in the query cache and run very quickly, producing skewed results.
Real Hal9000 Posted September 8, 2012 Posted September 8, 2012 This patch really did the trick on our site !!! Thanks Peter
PeterUK Posted September 10, 2012 Author Posted September 10, 2012 Here's the previously staff-only Tracker issue which now seems to be open to the public. This contains what I presume will be the official fix for the problem. Ultimately, it's exactly the same way I did it, using a nested subquery to grab the posts first, so if you've already implemented my solution I personally wouldn't bother changing to this one unless you really want to, it will be done when you upgrade to 3.4 anyway. http://community.invisionpower.com/resources/bugs.html/_/ip-board/big-topics-i-mean-big-topics-r36577
Lauren3 Posted September 20, 2012 Posted September 20, 2012 I've just applied that patch, hope it will help us because we are dealing with serious downtimes. Tech support think it's a 3rd party issue, but it occurs even on Performance Mode. Using 3.3.4 Thanks Peter for your help!
Lauren3 Posted September 20, 2012 Posted September 20, 2012 No more MySQL query flood since this patch has been applied. It's amazing, we were dealing with that issue for several weeks, thanks again Peter!
Lauren3 Posted September 24, 2012 Posted September 24, 2012 Our board is now fast, even on heavy traffic, this patch should be "officialized"
Rimi Posted September 24, 2012 Posted September 24, 2012 Our board is now fast, even on heavy traffic, this patch should be "officialized"There's already an official patch posted in the tracker. No file edits required.
Luis Manson Posted September 24, 2012 Posted September 24, 2012 Where can I found it? i think its: http://community.invisionpower.com/resources/bugs.html/_/ip-board/big-topics-i-mean-big-topics-r36577
Rimi Posted September 24, 2012 Posted September 24, 2012 There's supposed to be an attachment on the bug report but it's gone.
Mikey B Posted September 24, 2012 Posted September 24, 2012 There's supposed to be an attachment on the bug report but it's gone.and it's back. :rofl:
Lauren3 Posted December 10, 2012 Posted December 10, 2012 After updating to 3.4, it seems that this problem is back again!!
FabioPaz Posted December 10, 2012 Posted December 10, 2012 After updating to 3.4, it seems that this problem is back again!! Have you downloaded this patch ?
Lauren3 Posted December 10, 2012 Posted December 10, 2012 no, I haven't seen that. very appreciate, thanks Fabio!
Lauren3 Posted January 8, 2013 Posted January 8, 2013 Still have this issue with 3.4.1, is there a patch ?
PeterUK Posted January 13, 2013 Author Posted January 13, 2013 Still have this issue with 3.4.1, is there a patch ? This issue is fixed with the 3.4 series so if you have a problem with speeds you should open a ticket because it's not this issue. :smile:
Recommended Posts
Archived
This topic is now archived and is closed to further replies.