Mysql error: 'Too many connections'

C

CamronFry

BANNED
Jan 1, 2005
49
0
156
How can I get mysql to support more connections?
# mysqladmin processlist
mysqladmin: connect to server at 'localhost' failed
error: 'Too many connections'
 
K

kris1351

Well-Known Member
Apr 18, 2003
961
0
166
Lewisville, Tx
Do a search for mysyql tuning will provide you with some good templates for starting your tuning process. By default there isn't much defined in most mysql setups. Look in /etc/my.cnf and up the max connections. If it isn't there then find one of the templates here that people have posted and adjust it to fit your needs.
 
C

CamronFry

BANNED
Jan 1, 2005
49
0
156
If I have a bunch of sleeping queries from the same user does that mean they are using persistant mysql connections?
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
charliecres Mysql database error Databases 3
leonep mysql error on log access denied Databases 3
D Connect Error MySQL Databases 2
D Manage MySQL Profiles error Databases 3
A Account Creation Error: "The system failed to determine the “mysqld” version" Databases 2
Similar threads
Mysql database error
mysql error on log access denied
Connect Error MySQL
Manage MySQL Profiles error
Account Creation Error: "The system failed to determine the “mysqld” version"
Top Bottom