I know I have seen a similar question before but can't remember seeing a definitive answer.

I am using the 1.0.4 version of the connector in my .Net application, and my connection string is very simple and consistent throughout the application. I just specify database, data source, user id and password. I leave everything to do with connection pooling as default on the assumption that it will be fine.

However, it seems that when a user starts to use the application more and more connections get created and go off into a sleep state. It is almost as if connection pooling is not working a new connection is being created every time my application makes a connection, rather than reusing an unused connection that is "asleep".

Am I missing something? Should I be more specific about connection pooling in my connection parameters ? Very soon MySql is going to bomb with too many open connections.....