vb.org Archive - Small board getting max_user

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Small board getting max_user_connection errors (https://vborg.vbsupport.ru/showthread.php?t=324533)

chikuru

02-27-2017 03:27 AM

Small board getting max_user_connection errors

The forum is very small and rarely gets 20 users online (guest and memers combined).
max_user_connection is set to 80
persistent connection settings is:
$config['MasterServer']['usepconnect'] = 0;

What could be the problem and possible fix?

Code:

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User xxxxx_xxxxxxxx already has more than 'max_user_connections' active connections

/home/xxxxx/public_html/forum/includes/class_core.php on line 317

final kaoss

02-27-2017 05:53 PM

And this is on a vps?

Dave	02-27-2017 05:57 PM

Well the fix is pretty simple, increase the value of max_user_connection. Most shared hosts usually set it to 250/300 so I would set it to that first and see if that fixes it.

chikuru

02-28-2017 01:43 AM

Quote:

Originally Posted by Dave (Post 2582966)

Well the fix is pretty simple, increase the value of max_user_connection. Most shared hosts usually set it to 250/300 so I would set it to that first and see if that fixes it.

Is mysql server restart needed after changing the value?

bzcomputers

02-28-2017 03:20 AM

Quote:

Originally Posted by chikuru (Post 2582977)

Is mysql server restart needed after changing the value?

Yes

chikuru

03-02-2017 04:59 PM

Is there vbulletin-side optimization to reduce max connection and max user connection error?

Lynne

03-02-2017 05:23 PM

No, there is not. There is some article in the articles section for getting around it on some servers, but I have never tried and have no idea if it is still valid.

Paul M

03-02-2017 09:39 PM

Quote:

Originally Posted by chikuru (Post 2583149)

Is there vbulletin-side optimization to reduce max connection and max user connection error?

No, its not a vbulletin issue, its a MySQL issue, you value is too low (and your mysql timeout is probably too high).

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01194 seconds Memory Usage 1,722KB 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_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)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
Messages: