List:General Discussion« Previous MessageNext Message »
From:Thomas Raso Date:November 14 2007 11:07am
Subject:SET GLOBAL don't work
View as plain text  
Hi all,

i have a mysql 4.1.21

and i want to change the wait_timeout variable without restarting mysql.

I found that this variable can be changed by using SET GLOBAL
wait_timeout=XXX


mysql> show variables like 'wait%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 28800 |
+---------------+-------+
1 row in set (0.00 sec)


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

mysql> show variables like 'wait%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 28800 |
+---------------+-------+
1 row in set (0.00 sec)


Can you explain me why this operation don't work ???

ie: I useed the root account...

Thanks

Thomas Raso

Thread
SET GLOBAL don't workThomas Raso14 Nov
  • Re: SET GLOBAL don't workBaron Schwartz14 Nov