phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

slow query on new large topics out of the blue after 10 yrs


 
Search this topic... | Search phpBB2 Discussion... | Search Box
Register or Login to Post    Index » phpBB2 Discussion  Previous TopicPrint TopicNext Topic
Author Message
webby
Board Member



Joined: 18 Aug 2009

Posts: 2



PostPosted: Thu Nov 14, 2013 7:33 pm 
Post subject: slow query on new large topics out of the blue after 10 yrs

I run a large phpbb2 forum. Online for 10 years.

Everything was running smoothly till the last couple days. All of sudden new topics that get larger than 825 replies or 55 pages cause a slowdown to the forum when members try to view the first page of the topic. Older topics that were started a week ago don't cause this issue even though they have more replies.

Here is the query that is slow -

| Query | 57 | Sending data | SELECT p.post_id
FROM phpbb_posts p
WHERE p.topic_id = 535366

So... old topics cause no slow queries. New topics with less than 825 replies cause no slow queries. New topics with greater than 825 replies cause slow queries when a member views the first page only.

We have almost no mods installed, but have made numerous tweaks for large forums.

I did a 'repair' on the database and still have the problem. Any ideas?
Back to top
JLA
Board Member



Joined: 30 Apr 2009

Posts: 451
Location: U.S.A


flag
PostPosted: Tue Dec 10, 2013 12:31 pm 
Post subject: Re: slow query on new large topics out of the blue after 10

Manually run the query with explain with the smaller amount and the larger amount to see which index is being used for each?
_________________
http://www.jlaforums.com
Back to top
Display posts from previous:   
Register or Login to Post    Index » phpBB2 Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 4 Hours
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0341 seconds using 17 queries. (SQL 0.0091 Parse 0.0004 Other 0.0246)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo