Hi, you'll need to provide more details
Off hand the problem may be due to network errors or timeouts from the Server, in case of timeout, you can reconfigure a larger threshold
As specified from:
http://bugs.mysql.com/bug.php?id=57365
the documentation for this variables is avialable here
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_net_read_timeou...
No mention of max value, however I checked at the server code 5.6.4 and found that the biggest value allowed for these net_xx_timeout variables is 31536000.
I tested it and is set correctly with the queries:
set net_write_timeout = 31536000
show variables like 'net_write_timeout'
Source:
sql\sys_vars.c
static Sys_var_ulong Sys_net_write_timeout(
"net_write_timeout",
"Number of seconds to wait for a block to be written to a connection "
"before aborting the write",
SESSION_VAR(net_write_timeout), CMD_LINE(REQUIRED_ARG),
VALID_RANGE(1, LONG_TIMEOUT), DEFAULT(NET_WRITE_TIMEOUT), BLOCK_SIZE(1),
NO_MUTEX_GUARD, NOT_IN_BINLOG, ON_CHECK(0),
ON_UPDATE(fix_net_write_timeout));
sql\sql_const.h
#define LONG_TIMEOUT ((ulong) 3600L*24L*365L)
*** My opinions do not necessarily reflect the opinions of my employeer ***
Fernando Gonzalez Sanchez
Sr. Software Engineer
MySql Connector/NET Team
Oracle Corporation