vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   max user connection error (https://vborg.vbsupport.ru/showthread.php?t=47695)

DarkDraco07 01-13-2003 09:25 PM

max user connection error
 
people get this ewrroe while coming to my site

Warning: User darkneme_forums@localhost has already more than 'max_user_connections' active connections in /home/darkneme/public_html/forums/admin/db_mysql.php on line 40

Warning: MySQL Connection Failed: User darkneme_forums@localhost has already more than 'max_user_connections' active connections in /home/darkneme/public_html/forums/admin/db_mysql.php on line 40

line 40 of that page is :

$this->link_id=mysql_connect($this->server,$this->user,$this->password);

what do i do

Steve Machol 01-13-2003 09:59 PM

The server has maxed out the number of MySQL connections it allows. You can try turning persistent connections off in your config.php:

PHP Code:

// use persistant connections to the database
// 0 = don't use
// 1 = use
$usepconnect 0

But if you still have problems after that, all you can do is ask your host to raise the maximum number of connections they allow.

toLTcaboLT 06-07-2003 01:44 PM

Hello Steve. One q for ya. What is command and where I should put it to max out more connections?

Im using debian latest ....
I edited my.cnf anf putted this ... i putted 100 000 because I wanted to see if works .. obviously not?

set-variable = max_connections=100000
set-variable = join_buffer=4M
set-variable = record_buffer=1M
set-variable = table_cache=1024
set-variable = key_buffer=16M

And still getting 50-100 mails per day about max connection ... :(

Mails are like this ...

Database error in vBulletin :


Link-ID == false, connect failed
mysql error: Too many connections


mysql error number: 1040


Date: Saturday 07th of June 2003 06:42:31 PM
Script: /pnwbase/
Referer:

Pls if you know solution lemme know. thanks :)

Steve Machol 06-07-2003 04:41 PM

It's 'max_user_connections'.

toLTcaboLT 06-07-2003 11:58 PM

set-variable = max_user_connections=1024
set-variable = join_buffer=4M
set-variable = record_buffer=1M
set-variable = table_cache=1024
set-variable = key_buffer=16M

Like this?

Steve Machol 06-08-2003 12:05 AM

Yep. Be sure to restart MySQL after making the change.

toLTcaboLT 06-08-2003 12:28 AM

Thank you mate. Cheers you rox. Will let ya know if works.

filburt1 06-08-2003 12:32 AM

If you have more problems, you might want to post your server info at vB.com's server config forum. "eva2000" there is a god at optimizing servers ;)

toLTcaboLT 06-08-2003 09:17 AM

Damn I cant fix it.

Database error in vBulletin :


Link-ID == false, connect failed
mysql error: Too many connections


mysql error number: 1040


Date: Sunday 08th of June 2003 02:14:04 PM
Script: /pnwbase/showthread.php?threadid=27433

Again and again .. .:(

toLTcaboLT 06-08-2003 09:17 AM

This is my config.

# You can copy this to one of:
# /etc/mysql/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
#
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options

# This will be passed to all mysql clients
[client]
#password = my_password
port = 3306
socket = /var/run/mysqld/mysqld.sock

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

[safe_mysqld]
err-log = /var/log/mysql/mysql.err

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
#
# You can also put it into /var/log/mysql/mysql.log but I leave it in /var/log
# for backward compatibility. Both location gets rotated by the cronjob.
#log = /var/log/mysql/mysql.log
log = /var/log/mysql.log
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-locking
#
# The skip-networkin option will no longer be set via debconf menu.
# You have to manually change it if you want networking i.e. the server
# listening on port 3306. The default is "disable" - for security reasons.
skip-networking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
#
# Here you can see queries with especially long duration
#log-slow-queries = /var/log/mysql/mysql-slow.log
#
# The following can be used as easy to replay backup logs or for replication
#server-id = 1
#log-bin = /var/log/mysql/mysql-bin.log
#binlog-do-db = include_database_name
#binlog-ignore-db = include_database_name
#
# Read the manual if you want to enable InnoDB!
skip-innodb

[mysqldump]

quick
set-variable = max_allowed_packet=1M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]

set-variable = max_user_connections=20000
set-variable = join_buffer=4M
set-variable = record_buffer=1M
set-variable = table_cache=1024
set-variable = key_buffer=16M

toLTcaboLT 06-08-2003 10:04 AM

I putted 100 000 now .. and no problems for 30 mins ... I will see If I will get any more mails. If you have any suggestions pls

toLTcaboLT 06-08-2003 10:35 AM

It was good while it last :(

Database error in vBulletin :


Link-ID == false, connect failed
mysql error: Too many connections


mysql error number: 1040


Date: Sunday 08th of June 2003 03:35:13 PM
Script: /search.php?s=&action=showresults&getnew=true&searc hid=91975
Referer:

Erwin 06-08-2003 11:10 AM

Is it a shared server or dedicated server? If shared, other sites may be maxing out the connections, as on a shared server the max connections are shared by all sites.

toLTcaboLT 06-08-2003 01:10 PM

It's my dedicated server I have few sites on it, yep I know others use mysql too but why It doesnt work? I putted 100 000 connections? That must work Right?

Steve Machol 06-08-2003 03:35 PM

Why did you remove the max_connections setting? This is needed in addition to max_user_connections. They are too different things and your most recent errors are related to max_connections, not max_user_connections.

toLTcaboLT 06-08-2003 04:41 PM

I putted back I hope it will work now


All times are GMT. The time now is 05:03 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.01050 seconds
  • Memory Usage 1,746KB
  • 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
  • (16)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