MySQL Connections error

72 views
asked Jul 21, 2012 in General by Alpha2 (880 points)
Hello,

I usually encounter the same error on my website regarding Too many connections.  I think there is some constraint that is set on the production server.

/etc/my.cnf/
Max_connection=’xyz’
Max_user_connection=’xx’

What does this mean? And how can I prevent it?

Thanks for reading

2 Answers

0 like 0 dislike
answered Jul 21, 2012 by FixHost (12,380 points)
max_connections  means  the maximum  number of permitted simultaneous client connections at one time
max_user_connections means the maximum number of connections  permitted  simultaneously to any of  MySQL user account
0 like 0 dislike
answered Jul 21, 2012 by SmartHost (9,060 points)
To prevent this, change the number in the max connection option
...