Hi
Thomas Raso wrote:
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 ???
Because you need to use SHOW GLOBAL to see the changes to the global value.
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
