Mysql error: 'Too many connections'

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'
 

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.
 

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?