MySQL connections

See also this article for further details.

MySQL Driver configurations

The repository for MySQL driver is https://github.com/go-sql-driver/mysql

DSN parameters

The DSN parameters for timeout is either application layer and TCP layer and they’re on client sides.

1. timeout: a dial timeout.
   • Actual code
2. readTimeout: Used to set timeout for reading data from I/O. This is used for net.Conn.SetReadDeadline
   • Usages
     • Set ReadDeadline for a buffer
     • Check connection for a first query from a connection pool
3. writeTimeout: Used to set timeout for writing data from I/O. This is used for net.Conn.SetWriteDeadline
   • Usages
     • Code for writting a packet

MySQL server configurations

Even if the client connection is disconnected, queries on MySQL servers can keep running. On MySQL server side, some configurations like wait_timeout is used to close a non-interactive “idle” connection. See this answer, for example.

In order to stop running queries for longer time, max_execution_time can be used, though it’s only applied to read-only SELECT statements. See this article for more details.