vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Databse Error when there's too many connections (https://vborg.vbsupport.ru/showthread.php?t=313133)

Firyou 07-21-2014 06:30 PM

Databse Error when there's too many connections
 
Hey guys I have a weird problem. Whenever my forum reaches 340ish users online at one given time, it starts throwing a database error. Anything below that and it acts fine, I can even have 300 people on and no problems. But whenver it reaches that peak of 340 or more it starts doing it. I'm not sure why it does that, my current VPS has 4gb ram and AMD Opteron(tm) Processor 6376 quad core CPU. I'm running vb 4.2.0 pl4

RichieBoy67 07-21-2014 06:31 PM

You can increase the Max_connections in your my.cnf if you have root access or tell your host to increase it.

Firyou 07-21-2014 07:10 PM

Quote:

Originally Posted by RichieBoy67 (Post 2507675)
You can increase the Max_connections in your my.cnf if you have root access or tell your host to increase it.

Thanks for the quick response! I'll give that a try :)

Lynne 07-21-2014 07:16 PM

What is the exact database error that you are getting?

RichieBoy67 07-21-2014 07:48 PM

Quote:

Originally Posted by Lynne (Post 2507682)
What is the exact database error that you are getting?

I was assuming it was a max connections error because of the title but I could be wrong.

--------------- Added [DATE]1405979374[/DATE] at [TIME]1405979374[/TIME] ---------------

Quote:

Originally Posted by Firyou (Post 2507680)
Thanks for the quick response! I'll give that a try :)

No problem. :)

Firyou 08-19-2014 02:48 AM

Just wanted to give an update on this. It worked great! I increase the max connections in the .cnf file and I had about 500+ connections at one time and the errors went away!


All times are GMT. The time now is 11:30 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02013 seconds
  • Memory Usage 1,716KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete