Re: [Re: Re: set wait_timeout]

2004-05-21 Thread Victoria Reznichenko
t right value (=30), as i set it on startup. > > when i start mysql command line client and run: > show variables; > then i get value for interactive_timeout (it's default =28800). > > } this is what you pointed out. > > but when i run: > mysql -e 'set wait

[Re: Re: set wait_timeout]

2004-05-21 Thread [EMAIL PROTECTED]
for interactive_timeout (it's default =28800). } this is what you pointed out. but when i run: mysql -e 'set wait_timeout=26600;' mysql -e 'show variables;' then i get old values: wait_timeout=30 interactive_timeout=28800 this behaviour is quite odd and i don't see a

Re: set wait_timeout

2004-05-20 Thread Victoria Reznichenko
ter 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 star

set wait_timeout

2004-05-20 Thread [EMAIL PROTECTED]
: 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_ti