func (c *Conn) ReConnect() error {
if c.conn != nil {
c.conn.Close()
}
n := "tcp"
if strings.Contains(c.addr, "/") {
n = "unix"
}
netConn, err := net.Dial(n, c.addr)
if err != nil {
return err
}
tcpConn := netConn.(*net.TCPConn)
//SetNoDelay controls whether the operating system should delay packet transmission
// in hopes of sending fewer packets (Nagle's algorithm).
// The default is true (no delay),
// meaning that data is sent as soon as possible after a Write.
//I set this option false.
tcpConn.SetNoDelay(false)
tcpConn.SetKeepAlive(true)
c.conn = tcpConn
c.pkg = mysql.NewPacketIO(tcpConn)
if err := c.readInitialHandshake(); err != nil {
c.conn.Close()
return err
}
if err := c.writeAuthHandshake(); err != nil {
c.conn.Close()
return err
}
if _, err := c.readOK(); err != nil {
c.conn.Close()
return err
}
//we must always use autocommit
if !c.IsAutoCommit() {
if _, err := c.exec("set autocommit = 1"); err != nil {
c.conn.Close()
return err
}
}
return nil
}
func (s *Server) newClientConn(co net.Conn) *ClientConn {
c := new(ClientConn)
tcpConn := co.(*net.TCPConn)
//SetNoDelay controls whether the operating system should delay packet transmission
// in hopes of sending fewer packets (Nagle's algorithm).
// The default is true (no delay),
// meaning that data is sent as soon as possible after a Write.
//I set this option false.
tcpConn.SetNoDelay(false)
c.c = tcpConn
c.schema = s.GetSchema()
c.pkg = mysql.NewPacketIO(tcpConn)
c.proxy = s
c.pkg.Sequence = 0
c.connectionId = atomic.AddUint32(&baseConnId, 1)
c.status = mysql.SERVER_STATUS_AUTOCOMMIT
c.salt, _ = mysql.RandomBuf(20)
c.txConns = make(map[*backend.Node]*backend.BackendConn)
c.closed = false
c.collation = s.collation
c.charset = s.charset
c.stmtId = 0
c.stmts = make(map[uint32]*Stmt)
return c
}