Posted: Thu Jun 21, 2007 1:20 pm Post subject: error too many connection in mysql
Hi, i am using mysql database. sometimes i got problem of too many connection. cannot connect to database. Then i have to shutdown my server then restart mysql server then it solve problem. But this is not solution. i dont want to restart mysql. If anyone have the solution for too many connection please help me
Posted: Sun Dec 09, 2007 1:41 pm Post subject: Too many connection problems in mysql
Default connection for mysql for client is maximum 100
when connection exceed from 100, it will not accept another connection. In this case mysql throw error of too many connections.
you need to do setting for attribute max_connections
to increase the limit of connections.
In linux the mysql setting file
In Windows the mysql setting file
add this in this file
or whatever you want limit