Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > General Hosting/Server Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
SQL Mem Crashes + CPanel Memory Usage Details »»
SQL Mem Crashes + CPanel Memory Usage
Version: , by wezoo wezoo is offline
Developer Last Online: Feb 2008 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 10-28-2007 Last Update: Never Installs: 0
 
No support by the author.

Hi all, we're having serious memory problems we can't explain.

We're getting periodic SQL and php errors claiming we've ran out of memory, this crashes the server and it remains unstable until a full reboot. Here's the thing tho, we are a smaller board and sometimes only have 6-10 users online at the time?

The resting memory usage on CPanel (with no one on the site) is 70% which a) seems high, and b) whenever we look it seems to seldom go over 74% with 30-40 users online, however if we catch it right we'll see it spiking to 85% or so, when nothing as we can tell is going on on the site.

We're using a VPS 256. Can anyone suggest anywhere we could look to track down the problem? Our hosts have been of little help and have been unable to give us any idea of what are causing these memory spikes.

We've tried countless things, too many to explain, on the host's suggestion, disabling Spam Assassin, disabling a bunch of scheduled tasks, etc, etc, but none of these have had any noticable impact at all.

If you need any more information please let us know,

Thanks!

Chris (posting as wez)

CGEmpire.com

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 10-28-2007, 03:42 PM
lighti lighti is offline
 
Join Date: May 2007
Posts: 49
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

With a VPS is likely another user on the server is using way more ram then they should and cutting into your available ram. Perhaps the server was oversold to much and their is not much physical free ram left. Is this a Linux OS? Because with Linux it loves to eat ram, and store it. It will appear to be "Gone" but it is really cached for faster loading of items. Linux loves to use the physical ram and the virtual ram, together, so just because it says its eating 70% does not mean its all active.

My guess is (which is why I dislike VPS over priced shared accounts) but thats my opinion.. That the machine maybe oversold, and not alot of memory free, or cPanel may not of been installed properly and something is causing an error
Reply With Quote
  #3  
Old 10-28-2007, 06:09 PM
wezoo wezoo is offline
 
Join Date: Apr 2006
Posts: 86
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hmm interesting, thanks for the info lighti! I'll look into this!
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 10:36 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.04272 seconds
  • Memory Usage 2,204KB
  • Queries Executed 16 (?)
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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (2)postbit
  • (3)postbit_onlinestatus
  • (3)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_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