glabal and session variables

[Thomas Raso]

hi list

I don't understand what happen in mysql 4.1.22 ! ! ! ! ! (the same in
version 5.0)


-bash-3.00$ mysql -e "show variables like 'wait_timeout%'"
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | *30*    |
+---------------+-------+
-bash-3.00$ mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 55 to server version: 4.1.22-log

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

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

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

mysql>