max user connection error

[DarkDraco07]

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]

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

// 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]

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]

It's 'max_user_connections'.

[toLTcaboLT]

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]

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

[toLTcaboLT]

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

[filburt1]

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]

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]

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]

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]

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&searchid=91975
Referer:

[Erwin]

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]

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]

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]

I putted back I hope it will work now