Re: wait_timeout variable can't be set in MySQL 4.0.9-gamma-nt

At 21:30 25/02/2003 -0800, Bil Corry wrote:
Hi,
> Description:
>         wait_timeout variable can't be set in MySQL 
> 4.0.9-gamma-nt.  Setting interactive_timeout changes both of them.  Or at 
> least that's what SHOW GLOBAL VARIABLES is showing.
>
> How-To-Repeat:
>         SHOW GLOBAL VARIABLES like '%timeout';
>         SET GLOBAL wait_timeout=100;
>         SHOW GLOBAL VARIABLES like 'timeout';
>         (no change)

I did the test using 4.0.11:

Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

c:\mysql\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: 4.0.11-gamma-nt

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

mysql> SHOW GLOBAL VARIABLES like '%timeout';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| connect_timeout          | 5     |
| delayed_insert_timeout   | 300   |
| innodb_lock_wait_timeout | 50    |
| interactive_timeout      | 28800 |
| net_read_timeout         | 30    |
| net_write_timeout        | 60    |
| slave_net_timeout        | 3600  |
| wait_timeout             | 28800 |
+--------------------------+-------+
8 rows in set (0.06 sec)

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

mysql> SHOW GLOBAL VARIABLES like '%timeout';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| connect_timeout          | 5     |
| delayed_insert_timeout   | 300   |
| innodb_lock_wait_timeout | 50    |
| interactive_timeout      | 28800 |
| net_read_timeout         | 30    |
| net_write_timeout        | 60    |
| slave_net_timeout        | 3600  |
| wait_timeout             | 100   |
+--------------------------+-------+
8 rows in set (0.00 sec)

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

mysql> SHOW GLOBAL VARIABLES like '%timeout';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| connect_timeout          | 5     |
| delayed_insert_timeout   | 300   |
| innodb_lock_wait_timeout | 50    |
| interactive_timeout      | 200   |
| net_read_timeout         | 30    |
| net_write_timeout        | 60    |
| slave_net_timeout        | 3600  |
| wait_timeout             | 100   |
+--------------------------+-------+
8 rows in set (0.00 sec)

Then how you can see above it worked as expected. Please do the
update if you continue with the same problem 0n 4.0.9

>         SET GLOBAL interactive_timeout=100;
>         SHOW GLOBAL VARIABLES like 'timeout';
>         (both interactive_timeout and wait_timeout have changed)

--
Regards,
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Miguel Angel Solórzano <miguel@xxxxxxxxx>
 / /|_/ / // /\ \/ /_/ / /__   São Paulo - Brazil
/_/  /_/\_, /___/\___\_\___/
       <___/   www.mysql.com 


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before
posting. To request this thread, e-mail win32-thread10628@xxxxxxxxxxxxxxx

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@xxxxxxxxxxxxxxx instead.