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

Reply
 
Thread Tools Display Modes
  #1  
Old 05-26-2005, 10:33 AM
alamuae alamuae is offline
 
Join Date: Sep 2002
Location: uae in alain
Posts: 25
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Often the server load is high

I am facing a problem with my forum that located in a very powerful server and the server contain only the vb forum.
the problem is the load of the server is often high it reaches (80%) some time although the specification of the server are quite enough to run it.

I have written this problem in the vbulletin.com
and this is the topic link:
http://www.vbulletin.com/forum/showthread.php?t=139532

after receiving a command from this Guy MarcoH64 the server load went down till 7 - 11% and I am looking for a better result and a final solution.

-----------

About my database I would like to empty these four tables, if there is any critical problem if I empty them, please inform me or if it is normal send me the command that empty the tables without any errors.

pm 1,335,172 MyISAM 63.8 MB 47,022 Bytes
pmtext 526,413 MyISAM 306.3 MB 1,141 KB
postindex 69,701,315 MyISAM 1.5 GB -
word 2,232,375 MyISAM 167.7 MB -

I would like to reduce the number of the attachments for a specific forum not all forums, please give me the command that empty the attachments from one specific forum.

attachment 24,563 MyISAM 1.5 GB 55,384 Bytes
Reply With Quote
  #2  
Old 05-26-2005, 11:44 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by alamuae
after receiving a command from this Guy MarcoH64 the server load went down till 7 - 11% and I am looking for a better result and a final solution.
Yeah, that really is a great guy.

PS I already send you all commands to do this at vbulletin.com.

But instead of removing data, i see more use of adding some more indexes on data often used in WHERE or ORDER BY clauses. That might be your best solution (beside server tuning) on the long term. It is not an easy process, you would be monitoring the queries that take most time and focus on improving those.
Reply With Quote
  #3  
Old 05-26-2005, 04:23 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by alamuae
pm 1,335,172 MyISAM 63.8 MB 47,022 Bytes
pmtext 526,413 MyISAM 306.3 MB 1,141 KB
postindex 69,701,315 MyISAM 1.5 GB -
word 2,232,375 MyISAM 167.7 MB -
Why do you want to empty them - you will be affecting forum functionality.

Quote:
Originally Posted by alamuae
attachment 24,563 MyISAM 1.5 GB 55,384 Bytes
You try switching to using the file system for attachments, we did this as out attachments table got big.
Reply With Quote
  #4  
Old 05-26-2005, 07:10 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Paul,

Look up his posts on vbulletin.com. This have already been discussed long there.
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 11:09 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03836 seconds
  • Memory Usage 2,188KB
  • 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
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)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