actiontech/dtle

handle low wait_timeout.

c0494133d4 opened this issue · 2 comments

c0494133d4 commented

Case: mysqld has wait_timeout=60.

ffffwh commented

1 avoid keeping the full copy tx (with consistent snapshot) idle

2e38652

ffffwh commented

2 set wait_timeout for each connection

问题:

  • 对于golang database/sql连接池自动管理的连接, 无法执行
    • db.Query() // 可能新建连接
  • 只能对显式获取的连接执行
    • db.BeginTx()、db.Conn()