Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 05 Apr 2011, 19:31
kevcj's Avatar
kevcj kevcj is offline
 
Join Date: Mar 2007
Real name: Kevin
Does the Thread Views Updater cron job need to run?

Does the thread views updater cron job "really" need to be run?

Thread Views
This script updates thread views once per hour. This option is suggested for forums with large numbers of threads or users.
I have a forum on a dual quad core dedicated sever with 8 gigs of memory. When the thread views update script runs, the cpu usage spikes and the forum is non-responsive for maybe 20 minutes.

1,000 - 1,300+ people on the forum at any given time
Threads: 154,690
Posts: 2,558,499
Members: 51,124
Active Members: 9,312

The cron job was running every hour. During peak times (8pm - 10pm) the forum would become unresponsive. So I set the cron job to run once a day at 5am.

With 1,000 - 1,200 people on the forum, CPU is normally very low, say in the 2% range. Even at peak time CPU usage might go to the 4% range. Memory usage is usually around 16% - 23%, even during peak hours.

Looking at the post for today, there was not a single post made from 5:00am - around 5:35am, which is not normal.

This brings me to the question, does the thread views updater cron job need to run at all?

Or, is there something else going on that would cause problems with the updater and make the servercpu usage spike?

The thread views updater is the only cron job running in its time frame.
__________________
political forum
Reply With Quote
  #2  
Old 05 Apr 2011, 19:34
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
If that cron job is taking so long (how big is the threadviews table at any time that you look at it before the job is run?), then try setting it sooner, rather than later. It takes all the information from that table and enters it into the thread table. Have you looked at your error_logs to see if you are getting errors? Have you tried repairing/optimizing the table?
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 05 Apr 2011, 19:34
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
The thread views cron shouldn't be that server intensive all by itself. I would be looking at your CPanel or WHM that might be running background tasks.
Reply With Quote
  #4  
Old 05 Apr 2011, 19:45
kevcj's Avatar
kevcj kevcj is offline
 
Join Date: Mar 2007
Real name: Kevin
The thread views table is only 435kb - data length and 750kb index length. That should not be a big deal.

The thread table is only about 18 - 20 megs.

Error-logs - No I have not looked that the error logs. Are you talking about the logs in cpanel?

Cpanel and WHM task - according to WHM server status, cron.php is taking up the largest chuck of the cpu time. Where mysql might be taking 15% of the cpu time, cron.php is taking over 65% of the cpu time.
__________________
political forum
Reply With Quote
Reply



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

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 15:23.

Layout Options | Width: Wide Color: