View Single Post
  #1  
Old 04-05-2011, 05:31 PM
kevcj's Avatar
kevcj kevcj is offline
 
Join Date: Mar 2007
Location: East Texas
Posts: 334
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Does the Thread Views Updater cron job need to run?

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

Quote:
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.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01265 seconds
  • Memory Usage 1,764KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete