variable's new value keeps getting overridden by the default value after the new value's time period.

[Jim Clayson]

Hi,

I'm having a problem on MySQL5.1 where I try to set the value of a variable:

SET wait_timeout=5;

... the result is that the new value gets overridden to the default(28800) in the same number of seconds i.e. in this case 5.

If I set it to 10, it reverts to 28800 after 10 seconds.

Of course if I access the db within the 10 seconds, then the 10 seconds starts again.

Don't understand why it is reverting to the default each time.

Thanks for any help.
Jim