Go Back   vb.org Archive > Community Discussions > Forum and Server Management
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 03-23-2010, 05:11 PM
TMH63 TMH63 is offline
 
Join Date: Jan 2007
Location: MN
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Too many connections open....I need help!

So starting about a month ago or more, my website went to slow and I started getting database errors with the site crashing from time to time. My hosting person tells me that I'm having problems with too many connections being open..sql maybe he said. I'm hosting with hostgator on a reseller acct and I know there are other websites on my acct, but from what I understand none really all that big and not forum related type websites. My guy is trying to get me to go to a dedicated server and I don't understand all of this, but I don't see how that will eliminate my problems.

I'm not sure what I have done within that amount of time to do anything other than possibly signing up for the Mochi whatever the hell it is through v3arcade. What I have done(today) is disabled the arcade, took out anything in my file directory associating my site to them and in the process of deleting my acct with them.

Can anyone help me....what the heck else can I do, what can I check?

my website is www.themidwesthunter.com

Thanks!! I need help.
Reply With Quote
  #2  
Old 03-23-2010, 10:59 PM
Videx's Avatar
Videx Videx is offline
 
Join Date: Feb 2007
Posts: 3,085
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

HG has relatively low sql limits - like 25 connections. Depending how they're using the board, that may top out around 50-100 concurrent users. Good move dumping the arcade - ditto any chat rooms.

But your next step up (if still needed) is a VPS, not dedicated.
Reply With Quote
  #3  
Old 03-24-2010, 02:32 AM
chennairam's Avatar
chennairam chennairam is offline
 
Join Date: Aug 2007
Posts: 284
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Videx View Post
HG has relatively low sql limits - like 25 connections. Depending how they're using the board, that may top out around 50-100 concurrent users. Good move dumping the arcade - ditto any chat rooms.

But your next step up (if still needed) is a VPS, not dedicated.
I am also facing this problem .. too many connection

i having dedicated server

also i upgrade server core2duo to dual xeon qaud core 2.13 (nehelam) also 12Gb ram

Still facing this problem


please help me out


Regards
Ram
Reply With Quote
  #4  
Old 03-24-2010, 08:14 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If you are on a dedicated server then you can adjust the MySQL settings to avoid getting this error. I suggest you post a server optimization request at vBulletin.com.
Reply With Quote
  #5  
Old 03-24-2010, 01:24 PM
TMH63 TMH63 is offline
 
Join Date: Jan 2007
Location: MN
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Videx View Post
HG has relatively low sql limits - like 25 connections. Depending how they're using the board, that may top out around 50-100 concurrent users. Good move dumping the arcade - ditto any chat rooms.

But your next step up (if still needed) is a VPS, not dedicated.
I have no idea about hosting, what it takes or really what much of anything means...so I need it all dumbed down. ha, ha

What is a VPS?
EDIT....ok, I figured out what that was. :-)


Here's my scenario though.....

I have a reseller account with HostGator. I have an agreement with who I'm going through that they pay my monthly fee, but can resell my space(with max parameters set in place). Good deal in the beginning from what I thought. What I'm dealing with now are database errors from time to time(way more often than I can stomach) because of too many open connections and I sense that my website is slowly becoming slower and slower in performance as time goes on. I find out this morning that there are a total of 28 domains on my account and 45-50 is the cap. Stupid me, I should have written into the contract a lower cap amount when we wrote it up. But I had no idea.

My vB forums has roughly 60-80+ users that log on per day and as AWstats says, I have on average of 1.2-1.5mil hits a month whatever that means. Average 15gb of bandwidth used per month with a high of 24gb and just under 2gb total disk spaced currently used. If you need more stats, let me know! Of course I expect my forums to grow, so I also need to factor in some room for growth but still at a very reasonable $$ rate. I can't continue the way things are going, so I need some opinions from all of you on what I should do. Who I'm going through, they recommend me going to a dedicated server. Which I personally think is BS because I don't feel that the size of my site and the traffic I'm getting even warrants that, but heck if I know. Does it???

What are my options.....what should I do?
Go back to my domain ONLY being on my reseller acct?
Dump Host Gator and go with someone else?
Go to a different hosting acct with Host Gator?
Anything else I may have missed?
Reply With Quote
  #6  
Old 03-24-2010, 02:25 PM
borbole's Avatar
borbole borbole is offline
 
Join Date: Jan 2010
Posts: 2,559
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Have a look here about VPS.

http://en.wikipedia.org/wiki/Virtual_private_server
Reply With Quote
  #7  
Old 03-24-2010, 04:08 PM
chennairam's Avatar
chennairam chennairam is offline
 
Join Date: Aug 2007
Posts: 284
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Marco van Herwaarden View Post
If you are on a dedicated server then you can adjust the MySQL settings to avoid getting this error. I suggest you post a server optimization request at vBulletin.com.
They Need my Server access Detials


it is paid Server or Free Service Also My license Expired
Reply With Quote
  #8  
Old 03-24-2010, 04:21 PM
Videx's Avatar
Videx Videx is offline
 
Join Date: Feb 2007
Posts: 3,085
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
My vB forums has roughly 60-80+ users that log on per day
That's not relevant. What counts is how many concurrent users you have.

The whole reseller concept confuses me. Perhaps a first step would be to try a shared server somewhere on your own. But if you have a lot of simultaneous users, and can afford it, get a VPS.
Reply With Quote
  #9  
Old 03-24-2010, 05:27 PM
Angel-Wings's Avatar
Angel-Wings Angel-Wings is offline
 
Join Date: Sep 2007
Posts: 206
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by chennairam View Post
They Need my Server access Detials

it is paid Server or Free Service Also My license Expired
Why don't do it at your own ? They don't invent the wheel a second time so tuning-primer / mysqltuner and maybe some profiling to see what your DB is doing all the time might help.

Same applies to all other services like Apache - apachetop as example or temporary running mod_status.

Depending on the OS - MySQL sometimes is configured to run with brakes enabled
Reply With Quote
  #10  
Old 03-24-2010, 06:01 PM
TMH63 TMH63 is offline
 
Join Date: Jan 2007
Location: MN
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Videx View Post
That's not relevant. What counts is how many concurrent users you have.

The whole reseller concept confuses me. Perhaps a first step would be to try a shared server somewhere on your own. But if you have a lot of simultaneous users, and can afford it, get a VPS.
How can I determine how many simultaneous users I have?
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 09:33 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.04169 seconds
  • Memory Usage 2,260KB
  • 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
  • (6)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete