kingshard icon indicating copy to clipboard operation
kingshard copied to clipboard

Published 20 hours ago • verified publisher icon flike

timeout设置问题.

Open smallevil opened this issue 2 years ago • 0 comments

当interactive_timeout和wait_timeout有任意一个值小于20时,kingshard的sys.log里会每隔几秒产生一条报错记录: ERROR - node.go:[104] - [Node] "checkMaster" "Ping" "db.Addr=127.0.0.1:3306|error=connection was bad" conn_id=0 但不影响连接mysql,也不影响执行sql语句.

只有两个值同时大于20时,才不会报这个错. 有哪个有经验的大哥能回答一下,在使用mysql proxy时,这两个值设多少合适? 谢谢

smallevil avatar Apr 18 '22 14:04 smallevil