Bug #22625 SHOW VARIABLES lists wrong value for wait_timeout

• Submitted: 23 Sep 2006 5:04
• Modified: 23 Sep 2006 6:24
• Reporter: Steve Wolf
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.24a
• OS: Linux (CentOS 4.4 x86_64)
• CPU Architecture: Any
• Tags: variables, wait_timeout

[23 Sep 2006 5:04] Steve Wolf

Description:
The value of wait_timeout listed in SHOW VARIABLES never changes from the default value of 28800.  The proper value of wait_timeout can be seen with SELECT @@global.wait_timeout

How to repeat:
SET GLOBAL wait_timeout=15;
SHOW VARIABLES;
SELECT @@global.wait_timeout;

[23 Sep 2006 5:26] Paul DuBois

Try SHOW GLOBAL VARIABLES.

[23 Sep 2006 6:24] MySQL Verification Team

Thank you for the bug report. You need to use the GLOBAL modifier for:

miguel@hegel:~/dbs/5.0> bin/mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.26-debug

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

mysql> SELECT @@global.wait_timeout;
+-----------------------+
| @@global.wait_timeout |
+-----------------------+
|                 28800 | 
+-----------------------+
1 row in set (0.01 sec)

mysql> SET GLOBAL wait_timeout=15;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW VARIABLES LIKE 'wait_timeout';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 28800 | 
+---------------+-------+
1 row in set (0.01 sec)

mysql> SHOW GLOBAL VARIABLES LIKE 'wait_timeout';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 15    | 
+---------------+-------+
1 row in set (0.01 sec)

mysql>