|
|
Joined: Mar 2007
Posts: 285 Likes: 1
Enthusiast
|
|
Enthusiast
Joined: Mar 2007
Posts: 285 Likes: 1 |
Hello All, Happy New Year! (Running ver. 7.5.6p2) I get the following errors every day, any help would be appreciated. Script: /home1/electrm4/public_html/forums/scripts/postlist.inc.php - Line: 511
select t1.TOPIC_ID,t1.POST_ID,t2.USER_DISPLAY_NAME,t1.TOPIC_CREATED_TIME,t1.TOPIC_LAST_REPLY_TIME,t1.TOPIC_SUBJECT,
t1.TOPIC_STATUS,t1.TOPIC_IS_APPROVED,t1.TOPIC_ICON,t1.TOPIC_VIEWS,t1.TOPIC_REPLIES,t1.TOPIC_TOTAL_RATES,
t1.TOPIC_RATING,t3.USER_NAME_COLOR,t2.USER_MEMBERSHIP_LEVEL,t1.USER_ID,t1.TOPIC_IS_STICKY,t1.TOPIC_LAST_POSTER_ID,
t1.TOPIC_LAST_POSTER_NAME,t1.TOPIC_LAST_POST_ID,t1.TOPIC_IS_EVENT,t1.TOPIC_HAS_FILE,t1.TOPIC_HAS_POLL,t1.TOPIC_POSTER_NAME,t1.TOPIC_THUMBNAIL,t4.POST_BODY,t3.USER_GROUP_IMAGES
from ubbt_TOPICS as t1
left join ubbt_USERS as t2 on t1.USER_ID = t2.USER_ID
left join ubbt_USER_PROFILE as t3 on t1.USER_ID = t3.USER_ID
left join ubbt_POSTS as t4 on t1.POST_ID = t4.POST_ID
where t1.FORUM_ID = 1
and t1.TOPIC_IS_STICKY = '0'
AND t1.TOPIC_IS_APPROVED = '1'
ORDER BY t1.TOPIC_LAST_REPLY_TIME desc
LIMIT 9280, 21
- Lost connection to MySQL server during query
|
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
How're the resources on your server during peak hours? - Lost connection to MySQL server during query
|
|
|
|
|
Joined: Mar 2007
Posts: 285 Likes: 1
Enthusiast
|
|
Enthusiast
Joined: Mar 2007
Posts: 285 Likes: 1 |
How're the resources on your server during peak hours? It's a shared server, I don't really know any details. There are no other errors logged at the time. What is going on during this request? What are the limit numbers referring to?
|
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
it's a standard forum list query that is inefficient as all heck. showflat has the same problem with very LONG topics.. ( lots of posts ) you have a forum that has a HUGE number of topics in it and someone selected a page that is large. hence the starting LIMIT number. you have 2 choices, really. upgrade your hosting... prune old topics. 
|
|
|
|
|
Joined: Mar 2007
Posts: 285 Likes: 1
Enthusiast
|
|
Enthusiast
Joined: Mar 2007
Posts: 285 Likes: 1 |
I've been meaning to ask..... when is a good time, or when do you need to archive?
I have a little over 204k posts in almost 22k threads, going back 10 years. Would archiving help performance?
|
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
that's a medium forum and can run quite well on the proper hosting platform. 
|
|
|
|
|
Joined: Mar 2007
Posts: 285 Likes: 1
Enthusiast
|
|
Enthusiast
Joined: Mar 2007
Posts: 285 Likes: 1 |
that's a medium forum and can run quite well on the proper hosting platform. SD, I'm confused, what did you mean by prior response about a HUGE number of topics and suggestion to prune? Would Archiving help the current situation?
|
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
sure.. moving stuff OUT of highly trafficked forums to less frequented ones does help. but 'pruning' is actually deleting topics that are old/stale/of no use anymore
|
|
|
|
|
Joined: Mar 2007
Posts: 285 Likes: 1
Enthusiast
|
|
Enthusiast
Joined: Mar 2007
Posts: 285 Likes: 1 |
Sorry, I didn't realize there wasn't an Archive option.
I optimized tables and things seem to move quicker, but still get the occasional error.
Hypothetically, if a forum had close to 10,000 threads, would creating subforums under it, and moving a good portion of threads out of the main forum help to cut down on these errors?
a little? a lot?
Bill
Last edited by ECNet; 01/20/2013 11:39 AM. Reason: spelling
|
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
that's like asking 'how big is a ball of string?'
it's all relative to what hosting package you have.
if your hosting package is a shared/cheaper one, you will be fighting resource issues as you grow.
ideally, you get big enough where the board revenue supports a VPS or dedicated solution.
one thing that helps is to change the default age on a forum.
don't set it up to 'From all dates', but instead to '3 months'. that way less threads are in the mix, everytime they display the default forum view.
the new/unread indicator can be turned off to save resources too.
|
|
|
|
|
Joined: Mar 2007
Posts: 285 Likes: 1
Enthusiast
|
|
Enthusiast
Joined: Mar 2007
Posts: 285 Likes: 1 |
the new/unread indicator can be turned off to save resources too. Where can I find this setting? Bill
|
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
There are two settings, both found at:
CP => Display Options => General => Primary Tab
"Forum Summary Options" => "Show total # of unread posts per forum"
"Forum Display Options" => Show total # of unread replies in topics"
|
|
|
|
|
Joined: Mar 2007
Posts: 285 Likes: 1
Enthusiast
|
|
Enthusiast
Joined: Mar 2007
Posts: 285 Likes: 1 |
There are two settings, both found at:
CP => Display Options => General => Primary Tab
"Forum Summary Options" => "Show total # of unread posts per forum"
"Forum Display Options" => Show total # of unread replies in topics" sorry for the late reply... I did have thiose settings disabled, I thought there was something else. I've migrated the forum to a VPS host, so new issues... Thanks
|
|
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
|
|
|
3 members (Geoff, Gizmo, 1 invisible),
634
guests, and
178
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
