List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:May 21 2004 6:26am
Subject:Re: set wait_timeout
View as plain text  
"ruby@stripped" <ruby@stripped> 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
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com




Thread
set wait_timeoutruby@eq.cz20 May
  • Rename databaseNgim Ngau - Kzresults20 May
  • Re: set wait_timeoutVictoria Reznichenko21 May
RE: Rename databaseBob)20 May
RE: Rename databaseEd Reed20 May
RE: Rename databaseVictor Pendleton20 May
RE: Rename databaseemierzwa20 May