----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Jynergiser Message 5 in Discussion I am exploring the singleton pattern for optimizing database connection usage and the tips given on connection pooling is also useful. I have also set the following properties in my connection string. Pooling=true;Min Pool Size=0;Max Pool Size=500; Now the "Too many connections error " occurs after approx 45mins(while previously it came after only 15mins)of browsing the site by only 5 users. So I double checked the code and found all the connection objects are being closed properly. So I ran a tool know as (Navicat)www.navicat.com for Monitoring MySql Databases. From the data it showed it is clear that connections are not being released properly even after closing it in code. And I have a query on the Performance counter Object and connection pools. 1. Are The connection pools are database specific?(I think it is true) 2. If it is can I use .NET performance counters to monitor a MySql Database connection pool 3. If not for (2) any other suggestions for monitoring connection pools in MySql. Thank's all for the suggestions. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
