vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   mysql database error (https://vborg.vbsupport.ru/showthread.php?t=267296)

dlewisr 07-23-2011 06:50 PM

mysql database error
 
For the last couple of days I have been receiving the email below. Can anyone explain what this means and how to get solve the issue.

Cheers in advance.

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User xxxxx admin already has more than 'max_user_connections' active connections
/home/xxxxxxx/public_html/includes/class_core.php on line 314

MySQL Error :
Error Number :
Request Date : Saturday, July 23rd 2011 @ 12:22:28 PM
Error Date : Saturday, July 23rd 2011 @ 12:22:28 PM
Script : http://www.xxxxxxxxxx.co.uk/forum.php
Referrer :
IP Address : xxxxxxxxxx
Username :
Classname : vB_Database
MySQL Version :

Lynne 07-23-2011 07:04 PM

The server has maxed out the number of MySQL connections it allows. You can try turning persistent connections off by adding this to your config.php:
PHP Code:

$config['MasterServer']['usepconnect'] = 0

But, if you still have the problem you will have to talk to your host about raising that limit. Also, see this Common MySQL Error Messages

dlewisr 07-23-2011 07:49 PM

Thank you Lynne. That is already added to my config. I have just received an email from the Host Papa

We allow up to 15 simultaneous connections per MySQL user, and up to 150 simultaneous connections per server.

Fifteen connections are more than enough for most sites. Most connections are only open a fraction of a second, so 15 simultaneous connections is usually sufficient, even for a forum (for example) with hundreds of members.

It's a very small forum that I have with only 60 members!

Videx 07-24-2011 12:53 AM

Reminds me of my Bad Old Days on HG. What they didn't tell you in that email is that if they oversell their shared servers then each connection stays open way longer than it should, and this error can result. You want to look to the server load, and try complaining about that. Good Luck - they'll probably just try to sell you a "less shared" server like a VPS.

dlewisr 07-24-2011 04:42 PM

They haven't been any help at all really, as with other issues. It's frustrating as I asked lots of questions such as server load before I signed and was reassured that they fitted all of my needs. You hit the nail on the head, as they have suggested I move to a VPS server, which they don't provide and I have prepaid for 3 years!

Thanks for the reply Videx

silver.fox1969 11-22-2011 06:52 PM

Just want to find out how you got on with this error as im getting the same problem and my host allows 10 connections per MySQL on my small forum.

CILGINKRAL_ 03-01-2013 08:45 AM

Lynne thank you ;)


All times are GMT. The time now is 11:33 PM.

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.01824 seconds
  • Memory Usage 1,726KB
  • 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
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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