The Arcive of Official vBulletin Modifications Site.

honie · #1 10-05-2010, 11:25 PM

I am having some problems with running processes on my forum. I have a 25 process limit on my server, and according to my host I have some queries that are sleeping for a minute or longer. They also said that my chat room and showthread are staying open too long.

We are getting a very slow site, Internal server errors, etc. I have installed the lite version of VB Optimise, and although I am sure it is worth its price being a non profit I can't afford to purchase the full version especially when I am not sure it will solve the problem. If I purchase something, it would have to be very affordable.

We use 3.8.3, any advice would be very much appreciated. Here is what I get when I look at my processes through cpanel

MySQL Queries
| 8407374 | honie_james | localhost | honie_policewives | Sleep | 13 | | |
| 8407945 | honie_james | localhost | honie_policewives | Sleep | 78 | | |
| 8407949 | honie_james | localhost | honie_policewives | Sleep | 78 | | |
| 8407952 | honie_james | localhost | honie_policewives | Sleep | 13 | | |
| 8407955 | honie_james | localhost | honie_policewives | Sleep | 77 | | |
| 8407959 | honie_james | localhost | honie_policewives | Sleep | 77 | | |
| 8408034 | honie_james | localhost | honie_policewives | Sleep | 1 | | |
| 8408316 | honie_james | localhost | honie_policewives | Sleep | 31 | | |
| 8408337 | honie_james | localhost | honie_policewives | Sleep | 28 | | |
| 8408384 | honie_james | localhost | honie_policewives | Sleep | 21 | | |
| 8408408 | honie_james | localhost | honie_policewives | Sleep | 18 | | |
| 8408445 | honie_james | localhost | honie_policewives | Sleep | 5 | | |

Processes Opened.
honie 29596 0.5 0.7 51280 30760 ? SN 18:19 0:00 /usr/bin/php /home/honie/public_html/new/showthread.php
honie 29615 0.1 0.6 47504 26732 ? SN 18:19 0:00 /usr/bin/php /home/honie/public_html/new/showthread.php
honie 29624 0.0 0.3 34960 13520 ? SN 18:19 0:00 /usr/bin/php /home/honie/public_html/ChatRoom/amfphp/gateway.php
honie 29699 0.0 0.3 34960 13520 ? SN 18:19 0:00 /usr/bin/php /home/honie/public_html/ChatRoom/amfphp/gateway.php
honie 29967 0.0 0.3 34960 13520 ? SN 18:20 0:00 /usr/bin/php /home/honie/public_html/ChatRoom/amfphp/gateway.php
honie 30032 0.0 0.3 34960 13520 ? SN 18:20 0:00 /usr/bin/php /home/honie/public_html/ChatRoom/amfphp/gateway.php
honie 30983 0.2 0.6 47248 26540 ? SN 18:21 0:00 /usr/bin/php /home/honie/public_html/new/showthread.php
honie 31017 0.2 0.6 47248 26544 ? SN 18:21 0:00 /usr/bin/php /home/honie/public_html/new/showthread.php
honie 31024 0.3 0.7 49844 29048 ? SN 18:21 0:00 /usr/bin/php /home/honie/public_html/new/showthread.php
honie 31026 0.5 0.0 0 0 ? ZN 18:21 0:00 [php] <defunct>
honie 31028 0.2 0.6 47240 26520 ? SN 18:21 0:00 /usr/bin/php /home/honie/public_html/new/showthread.php
honie 31040 0.2 0.6 47240 26532 ? SN 18:21 0:00 /usr/bin/php /home/honie/public_html/new/showthread.php
honie 31203 0.3 0.7 49880 29124 ? SN 18:21 0:00 /usr/bin/php /home/honie/public_html/new/showthread.php
honie 31745 0.5 0.6 47076 26272 ? SN 18:21 0:00 /usr/bin/php /home/honie/public_html/new/search.php
honie 31782 0.5 0.6 47240 26532 ? SN 18:21 0:00 /usr/bin/php /home/honie/public_html/new/showthread.php
honie 31815 0.8 0.0 0 0 ? ZN 18:21 0:00 [php] <defunct>
honie 31864 1.1 0.6 49064 28400 ? SN 18:22 0:00 /usr/bin/php /home/honie/public_html/new/showthread.php
honie 32023 0.8 0.6 47248 26548 ? SN 18:22 0:00 /usr/bin/php /home/honie/public_html/new/showthread.php
honie 32091 1.9 0.7 49844 29236 ? SN 18:22 0:00 /usr/bin/php /home/honie/public_html/new/showthread.php

BirdOPrey5 · #2 10-08-2010, 02:50 AM

You should probably find a better host... I've only heard of hostgator having this limit.

honie · #3 10-08-2010, 08:57 PM

Thank you, I think that is what I will do. I appreciate you taking the time to reply

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05474 seconds Memory Usage 2,177KB Queries Executed 11 (?)
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)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)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 (3)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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!