Managing Excess Connections

I'm having an issue where an application will open multiple connections to mysql that will remain open. Eventually, the server will get bogged down with these connections or reach the max connections and stop allowing new connections. I'm working with the application vendor to resolve the issue

Re: Managing Excess Connections

- From: Cory Robin [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, October 13, 2006 12:43:13 PM GMT-0500 US/Eastern Subject: Managing Excess Connections I'm having an issue where an application will open multiple connections to mysql that will remain open. Eventually, the server

Re: Managing Excess Connections

Rolando, You are my hero! Thank you very much, this was extremely helpful. --- Rolando Edwards [EMAIL PROTECTED] wrote: 1) Are you opening connections and properly (explicitly) closing them ??? If you are using PHP, Please make sure you close all mysql_query requests with two(2) calls