MySQL query timeout

Question

I'm trying to execute a query using C#. The problem is that, despite the fact that I modified the timeout period, it thrown a timeout exception. It is rising the exception after 30 seconds, that is the default value.

using (MySqlConnection conn = new MySqlConnection(connStr))
{
   int x = conn.ConnectionTimeout;

   conn.Open();
   cmd.Connection = conn;

   cmd.CommandText = "SELECT AVG(v.value_min) AS minValue FROM values v";

   adpter.SelectCommand = cmd;
   adpter.Fill(dados);

   conn.Close();
}

As you can see, I'm using conn.ConnectionTimeout to check if the timeout is properly configured and, yes it is. At least it shows the amount of time that I configured (in that case 90).

So, how do I do this? How to run a long time query?

UPDATE: The query that I posted is just an example.

shA.t · Accepted Answer · 2015-06-06 12:34:05Z

2

Setting the CommandTimeout property on your MySqlCommand instead of the connection should do the trick.

edited Jun 6, 2015 at 12:34

shA.t

17k5 gold badges59 silver badges121 bronze badges

answered Feb 9, 2010 at 19:25

nos

231k60 gold badges436 silver badges516 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bob Rivers Over a year ago

Opps... Thanks. I dind't saw the property,,,

Collectives™ on Stack Overflow

MySQL query timeout

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related