long running inserts -> lost connection error

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
shutterstock
Posts: 27
Joined: Sat 28 May 2005 20:37

long running inserts -> lost connection error

Post by shutterstock » Wed 13 Jul 2005 14:25

if i'm doing 10-20 long running inserts - i get a lost connection error.

is this due to the wait_timeout? it's set to 28,800 right now (8 minutes?)

I searched the forums for a while - but i don't see an exact solution.

thanks
Jon

Serious

Post by Serious » Wed 13 Jul 2005 14:55

Check 'max_allowed_packet' value in 'my.ini' file.
We recommend to use 167772160

Code: Select all

[mysqld]
...
max_allowed_packet=167772160
You can also check the MySqlCommand.CommandTimeout property.

Post Reply