openpolice-platform
openpolice-platform copied to clipboard
Disable persistent connections
The number of open connections keeps growing until the limit has been reached. For now, the wait_timeout has been decreased to make sure connections are being cleaned up automatically.
Todo:
- Remove the ATTR_PERSISTENT setting in DatabaseAdapterMysql where the mysql connection is being made
- Reset the server's configuration (wait_timeout + max_connections back to default)
- Follow-up. If the situation has improved, apply the same change to Nooku Platform.
See: http://www.percona.com/blog/2006/11/12/are-php-persistent-connections-evil/ Also see: https://groups.google.com/forum/#!topic/comp.databases.mysql/SuaL7-G0iOc