long running inserts -> lost connection error

long running inserts -> lost connection error

Postby 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
shutterstock
 
Posts: 27
Joined: Sat 28 May 2005 20:37

Postby 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.
Serious
 


Return to dotConnect for MySQL