Bogdan TARU <[EMAIL PROTECTED]> wrote: > > Hi Martin, > > Hm. Don't really get it. Basically both mysqladmin and 'show variables' > should read these variables from the mysql server, right? Why then would > they give separate results?
mysql command-line client runs in interactive mode and gets value for 'wait_timeout' from 'interactive_timeout' variable which is 28800 by default. mysqladmin shows value which you specify in the my.cnf file. > > Thanks, > bogdan > > > On Mon, 21 Jul 2003, Martin Gainty wrote: > >> mysqladmin has the capability to specify the my.ini file to read on startup >> under " my.ini Setup " >> hth, >> Martin >> ----- Original Message ----- >> From: "Bogdan TARU" <[EMAIL PROTECTED]> >> To: <[EMAIL PROTECTED]> >> Sent: Monday, July 21, 2003 6:37 AM >> Subject: set/show variables >> >> >> > >> > Hi everyone, >> > >> > I have recently installed MySQL 4.0.13 on a freebsd box, and I have >> > stumbled into the following problem: >> > >> > I have set the following in /etc/my.cnf: >> > >> > set-variable = max_connections=100 >> > set-variable = wait_timeout=60 >> > >> > (tried with and w/o 'set-variable ='). Then I restarted mysql, and a >> > 'show variables' would show me: >> > >> > wait_timeout | 28800 >> > >> > And a 'mysqladmin variables' would report: >> > >> > wait_timeout | 60 >> > >> > What am I doing wrong here? > > -- 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]