php, mysql – Too many connections to database error

by

There are a bunch of different reasons for the “Too Many Connections” error.

Check out this FAQ page on MySQL.com: http://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html

Check your my.cnf file for “max_connections”. If none exist try:

[mysqld]
set-variable=max_connections=250

However the default is 151, so you should be okay.

If you are on a shared host, it might be that other users are taking up too many connections.

Other problems to look out for is the use of persistent connections and running out of diskspace.

More Related Contents:

  1. How do detect that transaction has already been started?
  2. PHP / PDO echo data from database into a table
  3. Can I mix MySQL APIs in PHP?
  4. How to apply bindValue method in LIMIT clause?
  5. PDOException “could not find driver”
  6. Row count with PDO
  7. PDO get the last ID inserted
  8. How do I use password hashing with PDO to make my code more secure? [closed]
  9. Error when preparing a multiple insert query
  10. How to view query error in PDO PHP
  11. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  12. Insert/update helper function using PDO
  13. Resetting array pointer in PDO results
  14. PDO multiple queries
  15. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  16. Do SQL connections opened with PDO in PHP have to be closed
  17. PDO::PARAM for type decimal?
  18. Update query with PDO and MySQL
  19. What is the advantage of using try {} catch {} versus if {} else {}
  20. Is “SET CHARACTER SET utf8” necessary?
  21. Alternative for mysql_num_rows using PDO
  22. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  23. Set PDO to throw exceptions by default [duplicate]
  24. PDO: MySQL server has gone away
  25. return one value from database with mysql php pdo
  26. Checking for an empty result (PHP, PDO, and MySQL) [duplicate]
  27. How can I pass an array of PDO parameters yet still specify their types?
  28. PHP/SQL Insert Error when using Named Placeholders
  29. Is a BLOB converted using the current/default charset in MySQL?
  30. Using PDO Prepared Statement and Incrementing a column value

Leave a Comment