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

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

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.

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 :)

It's 'max_user_connections'.

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?

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

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

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 ;)

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 .. .:(

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

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

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:

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.

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?

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.

I putted back I hope it will work now