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

Reply via email to