mySQL - Too Many Connections...

[Anon]

Ack, recently I've had a problem with all my mysql crap at coasters2k.com giving me errors of
too many connections... For each page I've been having it connect to the
database for the queries, but obviously this has some downsides. would
mysql_pconnect do the trick? Or perhaps adding "mysql_close();" at the
bottom of all the pages would be better to close the connection before
moving on? Thanks for your input.

[Anon]

Closing connection at the end over every page will probably solve your problem.

[Anon]

I was thinking this, but doesn't the connection automatically close when the script ends? Or maybe I'm thinking something different.

[Anon]

Thats the way I read it as well in the PHP documentation - php closes database connections automatically.

Have had the same problem using f2s.com - the mysql daemon is being shared by many websites and at peak times "mysql: Too Many Connections..." is common.

If you can configure the mysql server yourself, there's probably something you can do to increase the number of concurrent connections it can handle at one time.