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

[8 Feb 2006 14:44] Sebastian Nohn
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.
[8 Feb 2006 15:02] Hartmut Holzgraefe
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