I'm using MySQL 5.051a for Windows and running a .NET winapp that uses approx 102 threads according to MySQL Administrator -> User Connections....
The winapp works fine for approx 1 minute then errors:
"The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached."
I have checked the winapp C# .NET code to make sure all connections close after execution.
I have installed MySQL 5.051a with all default setting intact.
I'm sure all MySQL syntax is correct as well.
I've never had this sort of error running our winapp in MSSQL Server with MSSQL syntax..