Add connection read/write timeout

[ghost]

Can we set mysql read/write timeout,?

MYSQL_OPT_READ_TIMEOUT ..

[jmacd]

I'm having trouble with long-running queries, too, although I couldn't say if MYSQL_OPT_READ_TIMEOUT will solve my problem. I have a long-running SELECT statement that does some amount of CPU-intensive processing for each record. Eventually, the log shows (w/ code from March 2):

[MySQL] 2013/04/01 04:02:06 packets.go:62: EOF
[MySQL] 2013/04/01 04:02:08 packets.go:32: EOF
and an error returned to my code with String() = "driver: bad connection"

The duration my SELECT query runs before this happens is variable, so I presume this has something to do with my high CPU load and hitting some kind of timeout with MySQL. Anyway, thanks for the great code.

[arnehormann]

According to the documentation, there are four timeouts which can be changed per session. They are:

• interactive_timeout
• wait_timeout
• net_read_timeout
• net_write_timeout

You may be interested in net_write_timeout, which is 60 seconds by default.

Do you still see the problem when you issue SET SESSION net_write_timeout = 600 after opening a connection?

This can also be set by appending &net_write_timeout=600 to the DSN.

[julienschmidt]

@jmacd the EOF means, that the connection was closed, probably by the server.
Can you update to beta 5 ( go get -u github.com/go-sql-driver/mysql ) and try again with net_write_timeout set to a higher value like @arnehormann suggested?

[julienschmidt]

@better0332 do you have a certain issue you try to solve with a read / write timeout or is this more a general question?
I'm not sure if the driver should support this, since setting a client side timeout (in fact it is a deadline in absolute time we need to calculate every time) is quite expensive.

[ghost]

Our network quality is not stable, the client remote connect center mysql server. It seems like trap to driver until
/proc/sys/net/ipv4/tcp_keepalive_time
/proc/sys/net/ipv4/tcp_keepalive_intvl
/proc/sys/net/ipv4/tcp_keepalive_probes

[arnehormann]

@better0332 so you solved it by changing OS settings? Is this resolved, then?

[ghost]

yes, i resolved and I think the read/write timeout may affect connection pool

[arnehormann]

We'll close this for now. We can reopen it if @jmacd or somebody else still has problems.

[jmacd]

I raised net_read_timeout and net_write_timeout and it works.
Thanks,Josh.

On Tue, Apr 30, 2013 at 1:03 AM, Arne Hormann [email protected]:

We'll close this for now. We can reopen it if @jmacdhttps://github.com/jmacdor somebody else still has problems.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/50#issuecomment-17214289
.

[arnehormann]

And it will stay closed... Thank you for getting back to us!

[shenshouer]

@arnehormann hi ,I got this issue now. The detail like:
[MySQL] 2015/03/19 14:30:25 packets.go:59: read tcp 172.16.2.105:3306: connection reset by peer
[MySQL] 2015/03/19 14:30:25 packets.go:336: Busy buffer
2015/03/19 14:30:25 [INFO] people-count/app/models.(*Platform_db_info).getAgentConnect : (platform_db.go:150) - select agents from [北京] err: [driver: bad connection]