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
long running inserts -> lost connection error
-
- Posts: 27
- Joined: Sat 28 May 2005 20:37
Check 'max_allowed_packet' value in 'my.ini' file.
We recommend to use 167772160
You can also check the MySqlCommand.CommandTimeout property.
We recommend to use 167772160
Code: Select all
[mysqld]
...
max_allowed_packet=167772160