too many mysql connections

Anon

Hi,

I'm having a mysql problem on my freebsd system and I don't know whether it's caused by PHP or an improper mysql configuration.

The problem is this: there are way too many connections open to mysql on my system. I know this because when I do "netstat -a" on the system, it shows over 100 lines under "Active UNIX domain sockets" with the word mysql in it.

I run about 8 database-powered sites on a dedicated server. These site do not get a lot of load, so I've limited the connections to 150. So in about 3-4 days, mysql stops responding because it has too many connections! So I have to restart the server for it to flush all those connections.

Someone please help! I don't know why these sockets are not closing. I'm using mysql_connect() and NOT mysql_pconnect. So should the PHP close connections even if I don't call mysql_close()????

My e-mail is sridhar@texturedigital.com and if anyone has any suggestions or solutions, please e-mail me or post it here. I can post my my.cnf or php.ini file if needed. I'm willing to try any solution since right now I've to restart the server every couple days and even some improvement is better than none.

thank you all in advance!
-sridhar

Anon

why not use pconnect????

Anon

because pconnect won't disconnect once the program stops.

i thought that would solve the problem: but there were still over 100 connections open even when I used pconnect in all my PHPs. So right now i think they are all pconnects.

there are NO other programs running that use mysql except PHP.

i have 4.0.6...

-sridhar

[deleted]

Because that does not help. In fact, using pconnect usually increases the number of connections drastically because unused connections are not closed.

the only way to solve this is by allowing more connections on your database server, or decrease the number of web-server processes that can open connectison.

If your webserver can start 150 child-processes, then your database must be able to handle more than 150 connections.

A forum, a FAQ, what else do you need?