autoreconnect(keepalive) in godrv about mymysql HOT 5 CLOSED

Did you read #22

from mymysql.

database/sql manages connection itself (establishes new if it need, reconnect if connection was closed). Pinging idle connection need concurrent access to the connection, so it need to introduce mutexes and other overhead like in mymysql/thrsafe engine (mymysql/thrsafe implements keepalive on idle connection using SQL PING command).

Because of database/sql behavior to manage pool of connections and automatically reconnect if some connection was closed, godrv by default uses mymysql/native engine. If you want keepalives import thrsafe engine with godrv like this:

import (
_ github.com/ziutek/mymysql/thrsafe
_ github.com/ziutek/mymysql/godrv
database/sql
)

from mymysql.

So even if use the godrv package without the thrsafe, database/sql would handle the "mysql has gone away" problem for me?

from mymysql.

Did you read database/sql documentation or use it before create this issue?

from mymysql.

Please make sure to run Go 1.0.3 or higher. In older versions there was a bug which caused database/sql to not handle closed connections well.
See http://code.google.com/p/go/source/detail?r=b397807815a6 for more details

from mymysql.