openpolice-platform icon indicating copy to clipboard operation
openpolice-platform copied to clipboard

Disable persistent connections

Open tomjanssens opened this issue 10 years ago • 0 comments

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

tomjanssens avatar Jan 02 '15 11:01 tomjanssens