Which is a better option?

[Anon]

MySQL : Too many connection error, database crashes.

Would you suggest using the close function on all of the scripts to solve the "too many connections problem" or setting the max_connect_errors limit to 0? Will the first option really solve the probelm? and the latter cause any problems with the server? Thank you.

[brandonschnell]

if its your own box and you don't expect lots and lots of traffic consider using mysql_pconnect().

otherwise its polite to use mysql_connect() and close when the connection is no longer needed in a script.

[[deleted]]

max_connect_errors has nothing to do with this message, read the MySQL manual.

Closing the connections is good, but does not help because the connections are closed by PHP when the script exits.

Using pconnect will not help either, because that just leaves connections open for a long time so they don't have to be re-opened all the time.

There are exactly two things that will help:
1- Use fewer database connections in your PHP scripts.
2- Increase the number of connections that your database server will accept.