Hi there,
I am running a couple sites off a mysql server and I am currently having a too many mysql_connect error:
during this time, when I do
I see that there are around 70 ~ 100
and I manually have to kill all mysql process (killall mysqld) and restart the server.
My question is, is it likely I am missing a mysql_close() somewhere in my apps and that is the cause of this problem?
Also, I have increased the max_connections=100 in my.cnf but I am still seeing this problem. Does it not mean that I can have up to a 1000 lines in "ps aux | grep msql " before I see this too many connection error?
If webmasters have experienced similar problem, please kindly share your resolution.
Many thanks!
I am running a couple sites off a mysql server and I am currently having a too many mysql_connect error:
Code:
Warning: mysql_connect(): #08004Too many connectionsduring this time, when I do
Code:
ps aux | grep mysql | wc -land I manually have to kill all mysql process (killall mysqld) and restart the server.
My question is, is it likely I am missing a mysql_close() somewhere in my apps and that is the cause of this problem?
Also, I have increased the max_connections=100 in my.cnf but I am still seeing this problem. Does it not mean that I can have up to a 1000 lines in "ps aux | grep msql " before I see this too many connection error?
If webmasters have experienced similar problem, please kindly share your resolution.
Many thanks!