I ran the "SHOW VARIABLES LIKE '%TIMEOUT%' "
The INTERACTIVE-TIMEOUT value is 200 seconds and the NET_READ_TIMEOUT
is 30 seconds, both larger the the 10 second time at which "MySQL server
has gone away" kicks in. I note there is a CONNECT_TIMEOUT set at 5
seconds and a WAIT_TIMEOUT set at 10 seconds. I am not that familiar
with MySQL server setttings, do you think the WAIT_TIMEOUT value could
be the problem?
Dave Stredulinsky
> I get it to work with 10 seconds or less, and have the same problem
> with 11 or more.
>
> If you have admin privileges on that MySQL server, can you run a
> "SHOW VARIABLES LIKE '%TIMEOUT%' " query to see what the various
> settings are? Specifically, you may have the INTERACTIVE-TIMEOUT or
> NET_READ_TIMEOUT setting too low. I tried running the command, but
> get an empty response, indicating that the login being used does not
> have privileges for that.
>
> -- Ed Leafe
> -- http://leafe.com
> -- http://dabodev.com
>
>
>
>
©2007 Dave Stredulinsky |
