Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
  #1  
Old 26 Feb 2007, 10:13
MikeWarner's Avatar
MikeWarner MikeWarner is offline
 
Join Date: Nov 2001
Large threads and server load?

I have noticed every now and then that my server load spikes. I have not come up with an explanation for it, although though this did cross my mind: I have around 30,000 users and over 3 million posts.

I have a thread with 45,000 post and 191,000 views. Would this alone cause a big load? Also, if say 500 people have posted to it and say half have email notification turned on, that would cause quite a few subscription emails to be sent out. Could this thread alone be the cause of my load problems.

I have noticed over the last 10 days that the server has been fine and spotted this morning that no posts to this thread have been made during this period. Coincidence? This thread have been going for ages and I don’t want to close it, but I know it will come back to life again soon. Could it really be the cause of server load spikes?

Also, would it be possible for me to run a sql command to unsubscribe all users from that thread?

Many thanks.

Mike

Also - another thought. Would it be possible to run a sql command to switch off global email notification for all users who have not visited the forum in x days?
__________________
No signature - please check back later

Last edited by MikeWarner : 26 Feb 2007 at 10:15. Reason: Automerged Doublepost
Reply With Quote
Comments
  #2  
Old 26 Feb 2007, 15:12
stamos2003's Avatar
stamos2003 stamos2003 is offline
 
Join Date: Nov 2003
Real name: Sven
there was a very good topic for that at vbulletins support forum but i couldn't find it now as I made a quick search. In there they where writing that topics shouldn't have over 3000 posts in order not to eat server ressource, especially mysql.

maybe I find it again and I will copy you the link here...
Reply With Quote
  #3  
Old 17 Mar 2007, 11:38
amcd amcd is offline
 
Join Date: Oct 2004
Large threads will certainly cause high load on the db. Enable the slow query log on your mysql.
__________________
eXBii.com - Indian community
no XB no fun know XB know fun !
Reply With Quote
  #4  
Old 16 Jul 2007, 12:34
Hornstar's Avatar
Hornstar Hornstar is offline
 
Join Date: Jun 2005
Real name: Matt
Then I guess the thread in my spam section (post count turned off) on my site where the members are trying to get to a million posts is a bad idea
Reply With Quote
Reply


Similar Mod
Mod Developer Type Replies Last Post
vBouncer: reduce server load by unsubscribing bouncing members from threads tamarian vBulletin 3.5 Add-ons 389 14 Jan 2013 09:06
vBouncer (PHP): reduce server load by unsubscribing bouncing members from threads tamarian vBulletin 3.0 Full Releases 160 15 Nov 2008 21:54

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 04:55.

Layout Options | Width: Wide Color: