Grumpy Posted September 7, 2012 Share Posted September 7, 2012 Yeah, is your forum running 3.2? I did the test on 3.3.4. Link to comment Share on other sites More sharing options...
PeterUK Posted September 7, 2012 Author Share 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. Link to comment Share on other sites More sharing options...
Real Hal9000 Posted September 8, 2012 Share Posted September 8, 2012 This patch really did the trick on our site !!! Thanks Peter Link to comment Share on other sites More sharing options...
PeterUK Posted September 10, 2012 Author Share 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 Link to comment Share on other sites More sharing options...
Lauren3 Posted September 20, 2012 Share 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! Link to comment Share on other sites More sharing options...
Guest Ae9803 Posted September 20, 2012 Share Posted September 20, 2012 I have tried it as well. Link to comment Share on other sites More sharing options...
Lauren3 Posted September 20, 2012 Share 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! Link to comment Share on other sites More sharing options...
Lauren3 Posted September 24, 2012 Share Posted September 24, 2012 Our board is now fast, even on heavy traffic, this patch should be "officialized" Link to comment Share on other sites More sharing options...
Rimi Posted September 24, 2012 Share 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. Link to comment Share on other sites More sharing options...
Lauren3 Posted September 24, 2012 Share Posted September 24, 2012 Where can I found it? Link to comment Share on other sites More sharing options...
Luis Manson Posted September 24, 2012 Share 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 Link to comment Share on other sites More sharing options...
Rimi Posted September 24, 2012 Share Posted September 24, 2012 There's supposed to be an attachment on the bug report but it's gone. Link to comment Share on other sites More sharing options...
Mikey B Posted September 24, 2012 Share Posted September 24, 2012 There's supposed to be an attachment on the bug report but it's gone.and it's back. :rofl: Link to comment Share on other sites More sharing options...
Lauren3 Posted December 10, 2012 Share Posted December 10, 2012 After updating to 3.4, it seems that this problem is back again!! Link to comment Share on other sites More sharing options...
FabioPaz Posted December 10, 2012 Share Posted December 10, 2012 After updating to 3.4, it seems that this problem is back again!! Have you downloaded this patch ? Link to comment Share on other sites More sharing options...
Lauren3 Posted December 10, 2012 Share Posted December 10, 2012 no, I haven't seen that. very appreciate, thanks Fabio! Link to comment Share on other sites More sharing options...
Lauren3 Posted January 8, 2013 Share Posted January 8, 2013 Still have this issue with 3.4.1, is there a patch ? Link to comment Share on other sites More sharing options...
PeterUK Posted January 13, 2013 Author Share 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: Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.