Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 09-19-2011, 08:24 PM
PWillard PWillard is offline
 
Join Date: Sep 2011
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default server load on linux

hello there,
we are running vbulletin v4.1.5 on a centos v5.6 server running on mysql v5.5.16 and php v5.2.10.
server hardware has 8GB ram with Intel Core Quad CPU Q8200 @ 2.33GHz
we are running 5 different sites on this dedicated server and only 1 site its running vbulletin..
all use mysql databases for different things, but usually the server load is about 4 or 5 right now its a bit high

[(05:24 PM)][(root@alpha)] [(~)] $ uptime
17:25:42 up 12 days, 3:30, 1 user, load average: 9.64, 7.94, 7.01

I would like to know whats causing this.
if we put the vbulletin site on pause then the server load drops to about 0.52 and 0.70 stable..
the mysql database tables are on InnoDB file format. the traffic of the site is about 3k uniques a day!

addons currently enabled on the site are
Code:
VSa - Sub-Forum Manager v3.1.2
VSa - Advanced Permissions Based on Post Count v5.1
VSa - Advanced Forum Statistics v7.0.3
VSa - Advanced Forum Rules v5.0.5
vBSEO :: Sitemap Generator v3.0
vBSEO v3.6.0
Usergroup Color Bar v2.0.0
Report by Threads with Templates v1.0
Quick trash Posts v1.2
Anti Double Post System v2.2
KeyCAPTCHA v3.6.0
Sphinx Search v1.2.2
Reply With Quote
  #2  
Old 09-19-2011, 09:25 PM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I don't know most of thos Add-ons but purely judging from the names

VSa - Advanced Forum Statistics v7.0.3

would be my No. 1 candidate for further investigation.

3K unique visitors doesn't seem that much - analyze your server configuration and log files, especially MySQL slow queries.
Reply With Quote
  #3  
Old 09-19-2011, 09:27 PM
PWillard PWillard is offline
 
Join Date: Sep 2011
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

admins are the only ones allowed to see Advanced Forum Statistics v7.0.3
Reply With Quote
  #4  
Old 09-19-2011, 09:32 PM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That doesn't mean much, there could still be (heavy) queries getting executed for everyone.
Reply With Quote
  #5  
Old 09-19-2011, 10:07 PM
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
Posts: 3,134
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by PWillard View Post
the traffic of the site is about 3k uniques a day!
That's not as relevant as what those 3000 uniques are doing. How many of them are repeatedly loading pages or large files, as in a DoS attack? How many are just pure spam, scrapers, etc? Bad actors.

CloudFlare - get it. You'll end all of these issues and more.
Reply With Quote
  #6  
Old 09-20-2011, 12:20 PM
charlesr charlesr is offline
 
Join Date: Aug 2009
Posts: 177
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

My site was crawling (and falling over completely every few days) from search on InnoDB (that vB4 sneakily switched to when I upgraded from vB3). I changed to a VPS with fast I/O which helped and then changed all the tables back to MyISAM and since then load rarely goes over 1

The innodb index size was 1.5GB
With myisam it dropped massively.
Reply With Quote
  #7  
Old 09-20-2011, 02:43 PM
PWillard PWillard is offline
 
Join Date: Sep 2011
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

how can I check the current innodb index size ?
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 05:00 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05566 seconds
  • Memory Usage 2,216KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete