Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 31 Jan 2013, 05:58
elvinelol elvinelol is offline
 
Join Date: Jan 2013
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!

Last edited by elvinelol; 31 Jan 2013 at 08:46.
Reply With Quote
  #2  
Old 31 Jan 2013, 20:52
final kaoss final kaoss is offline
 
Join Date: Apr 2006
Self hosted chat's are a main cause for lag/performance issues. I would suggest you switch your chat system to a 3rd party provider to see if it helps.

Tinychat for example.
Reply With Quote
  #3  
Old 01 Feb 2013, 05:02
elvinelol elvinelol is offline
 
Join Date: Jan 2013
Originally Posted by final kaoss View Post
Self hosted chat's are a main cause for lag/performance issues. I would suggest you switch your chat system to a 3rd party provider to see if it helps.

Tinychat for example.
Even when I disabled the chat plugin these still happened.
Reply With Quote
  #4  
Old 02 Feb 2013, 01:29
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
 
Join Date: Aug 2008
Real name: Simon
It seems to me that those queries belong to a cron job (scheduled task) because of the regularity of times.
__________________
Kind regards,
Simon Microsoft Office Help
My Mods: Find my modifications here
Please do not pm me for support unless i have invited you to!
Reply With Quote
  #5  
Old 02 Feb 2013, 06:03
elvinelol elvinelol is offline
 
Join Date: Jan 2013

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

This was one of the newest logs, I'm not familiar with cron jobs. Are these done on vB or on the server? Should I assume my host cannot handle the demands of my site?

http://pastebin.com/4p9SaJzY

Example of another, but much larger log.

Last edited by elvinelol; 02 Feb 2013 at 06:20.
Reply With Quote
  #6  
Old 02 Feb 2013, 06:23
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
Admincp -- Scheduled Tasks --> Scheduled Task Manager

It doesnt mean the server your on cant handle it, but the fact that the host has most likely limited your resources you can use in the shared server & the fact its most likely over sold to begin with.

Im also guessing that their server isnt optimized, nor is it setup hardware wise to better utilize sql.

The session query time & its locking, is a indication of the above.
Reply With Quote
  #7  
Old 02 Feb 2013, 16:29
syrus.xl's Avatar
syrus.xl syrus.xl is offline
 
Join Date: Jun 2005
Being on Shared Hosting and running shoutboxes or chatrooms, just will not play well - most will have limitations so you do not start draining resources and causing server load issues with other users on the same server as you. External hosted chat is better when on shared hosting.

If you really need to host it yourself, then you will need to go for either a VPS or dedicated box. I personally run vBulletin from a VPS, without any problems - then again you have full resources to yourself and not sharing with anyone. I spent the laswt 2 years with managed vBulletin hosting with www.urljet.com - on a VPS.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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


New To Site? Need Help?

All times are GMT. The time now is 04:42.

Layout Options | Width: Wide Color: