Meaning of the wait_timeout Parameter

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: wait_timeout参数含义

| username: HACK

I saw a timeout parameter:

wait_timeout

  • Scope: SESSION | GLOBAL
  • Persistent to cluster: Yes
  • Default value: 28800
  • Range: [0, 31536000]
  • Unit: seconds
  • This variable indicates the idle timeout for user sessions. 0 means no time limit.

May I ask, does this timeout configuration mean that if the idle time between the application’s data source and the TiDB server exceeds 8 hours, the TiDB server will disconnect this connection? Is that correct?

【TiDB Usage Environment】Production, Testing, Research
【TiDB Version】
【Encountered Problem】
【Reproduction Path】What operations were performed that led to the problem
【Problem Phenomenon and Impact】

【Attachments】

Please provide the version information of each component, such as cdc/tikv, which can be obtained by executing cdc version/tikv-server --version.

2
| username: 啦啦啦啦啦 | Original post link

Yes, it is consistent with MySQL and is generally used together with interactive_timeout.

3
| username: HACK | Original post link

Okay!

4
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.