Server Provider said my site was causing high load issues

[FockerFGAA]

22654 fvsports 25 0 65576 18m 4996 R 35.4 0.5 171:35.35 /usr/php4/bin/php /home/fvsports/public_html/errors.php
7756 fvsports 25 0 60460 13m 5048 R 29.5 0.4 795:34.46 /usr/php4/bin/php /home/fvsports/public_html/errors.php
26055 fvsports 25 0 61660 14m 5084 R 29.5 0.4 794:13.35 /usr/php4/bin/php /home/fvsports/public_html/errors.php
28048 fvsports 25 0 67052 19m 5000 R 29.5 0.5 171:08.35 /usr/php4/bin/php /home/fvsports/public_html/errors.php
21794 fvsports 25 0 64972 17m 4996 R 28.5 0.5 171:05.50 /usr/php4/bin/php /home/fvsports/public_html/errors.php

and that is what they linked me. i have checked over my stuff time and time again and i even went to the vbulletin.com to optimize and the only thing that i could have done differently was upgrade from 3.6.4. there has to be something im missing that would cause that high load, but i have no clue how to find out.

[SEOvB]

errors.php isn't a standard vBulletin file so we can't really tell what the cause for the load is without knowing what that file is from.

Are you on shared, dedicated, or a VPS server?

[Brandon Sheley]

try disabling some of the mods until the load goes down, then when you find the one that makes it drop, I would find another mod and not us that one..

[FockerFGAA]

im on a vps server. the problem is the load on the server will be fine. i have the mod to see the load on my forums and its almost always fine. but then randomly it spikes up. and supposedly we caused the server to bog down. its the same thing they told us like 6 months ago, but it seems odd that it will run fine for the most part and then suddenly will spike and cause everything to shut down.

also, ive done the optimization from vbulletin.com but the only thing i can really do being on a vps that was recommended is upgrade my vbulletin (im on 3.6.4), but i havent done an upgrade before and i dont want to lose anything.

[FockerFGAA]

i did debug mode and this is what it says


* Page Generation 0.13454 seconds
* Memory Usage 3,237KB
* Queries Executed 10 (?)

More Information
Template Usage:

* (1)FORUMHOME
* (1)ad_footer_end
* (1)ad_footer_start
* (1)ad_forumhome_afterforums
* (1)ad_header_end
* (1)ad_header_logo
* (1)ad_navbar_below
* (1)cyb_paypal_link
* (1)footer
* (1)forumhome_birthdaybit
* (4)forumhome_forumbit_level1_nopost
* (12)forumhome_forumbit_level2_post
* (16)forumhome_lastpostby
* (1)forumhome_loggedinuser
* (1)forumhome_markread_script
* (9)forumhome_moderator
* (15)forumhome_subforumbit_post
* (1)forumhome_subforumseparator_post
* (1)gobutton
* (1)header
* (1)headinclude
* (1)navbar
* (9)navbar_notifications_menubit
* (1)option
* (1)spacer_close
* (1)spacer_open

Phrase Groups Available:

* global
* holiday


Included Files:

* ./index.php
* ./global.php
* ./includes/init.php
* ./includes/class_core.php
* ./includes/config.php
* ./includes/functions.php
* ./includes/class_datastore.php
* ./includes/datastore/datastore_cache.php
* ./includes/class_hook.php
* ./includes/functions_bigthree.php
* ./includes/functions_forumlist.php
* ./includes/functions_calendar.php

Hooks Called:

* init_startup
* fetch_userinfo_query
* fetch_musername
* fetch_userinfo
* cache_permissions
* style_fetch
* cache_templates
* global_start
* parse_templates
* notifications_list
* global_setup_complete
* forumhome_start
* forumhome_loggedinuser_query
* forumhome_loggedinuser
* cache_ordered_forums
* forumbit_display
* forumbit_moderator
* forumbit_subforumbit
* forumbit_subforumbit2
* forumhome_complete


i dont know if that makes any difference to anyone. i upgraded from 3.6.4 to 3.7.4 today. i eliminated a few hacks that i had (extended rep and submit a quote were active ones). i really want to make sure my site doesnt have the same issues its been having, but i feel like im in over my head which sucks.

[SEOvB]

i did debug mode and this is what it says



i dont know if that makes any difference to anyone. i upgraded from 3.6.4 to 3.7.4 today. i eliminated a few hacks that i had (extended rep and submit a quote were active ones). i really want to make sure my site doesnt have the same issues its been having, but i feel like im in over my head which sucks.

If you're on a true VPS you should still have access to my.cnf, php.ini, httpd.conf and other configuration files that would allow you to optimize your settings to reduce load.

[FockerFGAA]

If you're on a true VPS you should still have access to my.cnf, php.ini, httpd.conf and other configuration files that would allow you to optimize your settings to reduce load.

Well I can't seem to find those files. I read you can create a my.cnf file but i have no clue where i would even begin with that. I don't see any of those three files.

[SEOvB]

did you login as root via SSH and you may have to run

updatedb
locate my.cnf

usually is in the /etc/ folder but depends on your setup.

[FockerFGAA]

did you login as root via SSH and you may have to run

updatedb
locate my.cnf

usually is in the /etc/ folder but depends on your setup.

sorry i guess i said it wrong. im on a semi dedicated. http://www.jaguarpc.com/semi-dedicated/

[snakes1100]

I don't see any where on that page that you host has set limits to what resources you can use anyways, seeing as this is a semi-dedicated and not a VPS, as a VPS is alloted what its allowed to use, in my opinion, this host is trying to nudge you into a larger package of hosting, my guess is that they will continue to be of no help to you in the support area, meaning they will not tell you what is causing the high load, if they continue this tactic, i would change hosts.

[Replicators]

I have to agree with snakes here. seems they are causing the spiking themselves, but blaming your site in hopes you will upgrade. OR someone is attacking your site.

[nsaivamsi]

Previously i too had the same problem .. try using the below link which i have received from support staff of vbulletin :-

http://www.vbulletin.com/forum/showthread.php?t=224462

[FockerFGAA]

Thanks for all the info and help guys. I have upgraded to 3.7.4 and that fixed the issue so far of high server load. I am beginning to think that I had a bad index or some badly coded queries of some sorts. I have tried to remove any mods that I deemed not important and it seems to be working well so far.