View Single Post
  #1  
Old 01-31-2013, 05:58 AM
elvinelol elvinelol is offline
 
Join Date: Jan 2013
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Shared Hosting Not Cutting it?

Hello,

I've been having issues with queries being held for 4secs + at given times for my site. I'm a live streamer and can have anywhere from 50-1000 viewers watching. If I post a link to a thread some people get "database error" messages. I assume that's because HostMonster as a 15 user limit on SQL requests. While this shouldn't be an issue since most request are passed within milliseconds from what I'm told. I'm thinking about leaving HostMonster and moving to a vps or a dedicated. My community is growing at a faster rate than I expected.

My question is if my conclusions are correct that it's due to being on a shared hosting server vBulletin runs slow at times and can even hang SQL queries to cause me to hit my database limit set in place by my host. In doing so they also throttle my site.



Some info about my site traffic, 430.83 MB Disk Space used. 32.42 MB vBulletin SQL Database size. Also, I did run VSa - ChatBox and was curious would that also cause hangups in queries? I've since turned it off to see if it would run better, but I think it's best for me to move to vps or dedicated.

Slow queries log created for over 1 sec am I getting attacked from the pattern of these log creation times?



Site: www.elvinelol.com

Thanks for the help in advance!
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01310 seconds
  • Memory Usage 1,763KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete