MySQL Bugs: #17237: wait_timeout == interactive

Bug #17237	wait_timeout == interactive_timeout
Submitted:	8 Feb 2006 14:44	Modified:	8 Feb 2006 15:02
Reporter:	Sebastian Nohn	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.15, 5.0.18	OS:	Windows (Win32, Linux)
Assigned to:		CPU Architecture:	Any

Description:
wait_timeout seems to be the same as interactive_timeout. At lease these paramters can not be set independently. http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html suggest something else.

How to repeat:
Set in my.cnf:

wait_timeout = 600
interactive_timeout = 3600

restart mysqld

mysql> show variables where Variable_name = 'wait_timeout';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 3600  |
+---------------+-------+
1 row in set (0.17 sec)

Suggested fix:
Handle wait_timeout and interactive_timeout independently.

The mysql command line client sets the "interactive" flag on connection,
so the interactive_timeout overrides the wait_timeout for that session,
see SHOW GLOBAL VARIABLES for the system-wide timeout settings