C# MySQL command timeout

Question

I have specified command_timeout for 4 seconds.

But when I run the application, the command takes something about 8-12 seconds before it times out.

I also specified connection timeout in MySQL connection string, but with no luck

default command timeout=4

It works for MsSqll and Oracle well, but for MySQL not.

Is there any way how to specify the timeout?

I found the issue there https://forums.mysql.com/read.php?38,634568,634568 but with no answer.

Edit

Code Sample

...         
DataTable outputNodes = new DataTable();
Stopwatch sw = new Stopwatch();
cmd.CommandTimeout = 4;
sw.Start();
var a = cmd.ExecuteReader();
sw.Stop();
ex_time = sw.Elapsed;
sw.Reset();
outputNodes.Load(a);
CloseConnection();
...

You can also use something like MySqlCommand cmd = new MySqlCommand(); cmd.CommandTimeout = 4; — Hackerman
– Hackerman, Commented Jan 31, 2018 at 15:13
@Hackerman I also specified cmd.CommandTimeout = 4. Result still same. — Jan Krupa
– Jan Krupa, Commented Jan 31, 2018 at 15:19

Bradley Grainger · Accepted Answer · 2018-02-01 04:56:01Z

1

This is probably a bug in Connector/NET. I've run into a number of bugs with CommandTimeout, e.g., bug 88124, bug 87307. I thought I even remembered filing a bug report about MySqlCommand taking 2× CommandTimeout before it actually timed out (which sounds like your situation), but I can't find it now (if I actually did file it).

If you have a consistent repro, I'd suggest filing a bug at bugs.mysql.com.

And if you have the flexibility to change drivers, try MySqlConnector, which has a much more robust CommandTimeout implementation.

answered Feb 1, 2018 at 4:56

Bradley Grainger

28.3k4 gold badges95 silver badges117 bronze badges

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

1 Comment

Jan Krupa Over a year ago

I found some of the bug reports too but from 2015. I thought it might be resolved now. Thanks for the information.

Collectives™ on Stack Overflow

C# MySQL command timeout

Edit

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Edit

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related