MySql 'wait_timeout' Global Variable vs Variable -

i trying reproduce connection timeout error temporarily reducing "wait_timeout" 60 seconds instead of default 28800 seconds.

i added wait_timeout=60 my.ini file , restarted mysql. unfortunately, still not able reproduce error condition (unless want wait 28800 seconds).

the queries below seem indicate "wait_timeout" set 60 @ global variable level still set @ 28800 seconds regular variable (is same session variable?).

how can correct this? how setting in my.ini getting overwritten?

thanks advice still bit of mysql admin noob. :)

i'm running mysql 5.5.10 on windows xp.

mysql> show variables 'wait_timeout'; +---------------+-------+ | variable_name | value | +---------------+-------+ | wait_timeout  | 28800 | +---------------+-------+ 1 row in set (0.00 sec)  mysql> show global variables 'wait_timeout'; +---------------+-------+ | variable_name | value | +---------------+-------+ | wait_timeout  | 60    | +---------------+-------+ 1 row in set (0.00 sec) 

from mysql documentation: wait_timeout:

on thread startup, session wait_timeout value initialized global wait_timeout value or global interactive_timeout value, depending on type of client (as defined client_interactive connect option mysql_real_connect()). see interactive_timeout.

you should lower interactive_timeout global variable in ini file.

also note that:

this timeout applies tcp/ip , unix socket file connections, not connections made using named pipes, or shared memory.

(as vladislav pointed above note should disregarded, this bug has been fixed , timeout applies connections named pipes or shared memory well, apparently docs have not been updated.)