MySQL: User some_user_name already has more than 'max_user_connections' active connections

I'm using Zend Freamwork for my website. And sometimes i get the following exception from my website:

Message: SQLSTATE[42000] [1203] User elibrary_books already has more than '开发者_开发百科max_user_connections' active connections

As I know "Zend Freamwork" uses PDO to connect to the database. How i can resolve this problem?

Always close your connection. If you are using Sql class it looks like:

$sql->getAdapter()->getDriver()->getConnection()->disconnect();

Sometimes MySQL connection thread is not thrown away even though you've torn down the socket cleanly; it still hangs around waiting for it to be reaped.

Check your settings for wait_timeout. Default value is unreasonably long. Optimal value might be around 20 seconds. You will probably also want it this low if you're using persistent connections.

Try setting the persistent flag in your database driver configuration to be false:

resources.db.params.persistent = 0