"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > hi, > i have problem with automatic setting of variable wait_timeout. > mysql version 4.0.20 (and 4.0.18) on slackware linux. > i've tried to set it in several ways: > > 1) in startup script as a parameter to mysql_safe: > -O wait_timeout=30 > > 2a) in configuration file /etc/my.cnf, section [mysqld]: > set-variable=wait_timeout=30 > > 2b) in configuration file /etc/my.cnf, section [mysqld]: > wait_timeout=30 > > 3) from the shell (i've planed to place it into the startup script after > mysqld_safe start): > mysql -e 'set wait_timeout=30' > > nothing worked, i got no error message and the value of wait_timeout > stood default: 28800. > when i run 'set wait_timeout=30;' as privileged user in interactive > mysql session (running 'mysql'), the value changes as i wish. > what should i do to set the variable at startup? >
If you check wait_timeout value using mysql command-line client, it takes value for 'wait_timeout' from 'interactive_timeout' variable which is 28800 by default. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
