MyCATApache/Mycat-Server

mycat无法设置wait_timeout问题

Open

#2937 opened on Sep 12, 2023

View on GitHub
 (1 comment) (0 reactions) (0 assignees)Java (9,451 stars) (3,886 forks)batch import
help wanted

Description

**描述你使用过程中遇到的问题: ** 客户端连接mycat后，执行: SET SESSION wait_timeout=1; show VARIABLES LIKE 'wait_timeout';

并得不到理想的值，这是因为什么机制呢，在官方文档中没有找到对应的说明。

Contributor guide

Tech stack
javasql
Domain
backenddatabase
Issue type
bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
stale
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
JavaMycat architectureSession variable management
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
35
Research direction
Investigate how Mycat handles SET SESSION commands for wait timeout. Look at the session variable handling in Mycat's source code, particularly in the SQL parser and session management modules. Check if Mycat has its own implementation that might ignore or override certain MySQL system variables. The issue likely requires modifications in the server's configuration handling to properly propagate or simulate wait timeout.