Timeout expired error in mysql with C# in my asp.net web application?

Question

I have developed one asp.net application with mysql database connection.Some times i am facing the timeout error when looking at the pages.i also set the connection time. but still am receiving the same error dynamically.I couldn't able to figure it out about in which situation it has occurred.

This is the complete error message that i received...

error connecting: Timeout expired. 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.

What are all the parameter i have to monitor to solve this error?

Please guide me to solve this...

There is only one escape and it is called [using statement](http://msdn.microsoft.com/en-us/library/yh598w02.aspx) — Steve, Jul 20 '13 at 12:05

score 1 · Answer 1 · answered Jul 20 '13 at 16:11

Did you close the connection after you open it..?

try
{
     conn.Open();
     someCall (myConnection);
}
finally
{
     myConnection.Close();                
}

In MSSQL you can check connection by using this "sp_lock, sp_who" .. Check this site: http://www.xaprb.com/blog/2006/07/31/how-to-analyze-innodb-mysql-locks/ for equivalent in mysql

score 0 · Answer 2 · answered Jul 20 '13 at 11:50

It means that you are running out of the connections available in the connection pool. You can increase that in the connection string the max pool size. But it is recommendedthat you check why are you not closing the connections after you have used them.

Timeout expired error in mysql with C# in my asp.net web application?

2 Answers2