Bug #24064 Can't set wait_timeout variable

• Submitted: 7 Nov 2006 21:42
• Modified: 8 Nov 2006 16:11
• Reporter: Jared S (Silver Quality Contributor)
• Status: Not a Bug
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.0.27
• OS: Windows (Winxp)
• CPU Architecture: Any
• Tags: global, IN, settings, variable, wait_timeout

[7 Nov 2006 21:42] Jared S

Description:
Hi,

I am trying to set wait_timeout to 30 secs but it wont update.

How to repeat:
1. set global  wait_timeout =30;
2. show variables;

Suggested fix:
make wait_timeout updateable

[8 Nov 2006 16:11] MySQL Verification Team

Thank you for the bug report.

C:\dbs\5.0\bin>mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.27-community-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> set global  wait_timeout =30;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like "wait_timeout"; # this is a session variable
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 28800 |
+---------------+-------+
1 row in set (0.00 sec)

mysql> show global variables like "wait_timeout";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 30    |
+---------------+-------+
1 row in set (0.00 sec)

mysql>