tsss, how about that :) yes, I can set interactive_timeout to a value in my.cnf (interactive_timeout=30). This works! However, as a side-effect, wait_timeout is *also* set to 30.
Right, problem solved. Thanks, Nils. Maarten -----Original Message----- From: Nils Valentin [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 1:48 PM To: [EMAIL PROTECTED] Cc: Hoeven, Maarten van der Subject: Re: Setting wait_timeout in my.cnf? Hmm. You could try show variables like "%timeout%"; perhaps interactive_timeout can help you out ? -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ On Tuesday 11 November 2003 21:37, Hoeven, Maarten van der wrote: > nope, that didnt help. Thanks though! > > Any other suggestions? > > -----Original Message----- > From: Nils Valentin [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 11, 2003 1:00 PM > To: [EMAIL PROTECTED] > Subject: Re: Setting wait_timeout in my.cnf? > > > > Hi Maarten, > > I havent tried it recently but substitute any underbar (_) with a hiven > (-) > when doing a setting in the my.cnf. > > > -- > kind regards > > Nils Valentin > Tokyo/Japan > > http://www.be-known-online.com/mysql/ > > On Tuesday 11 November 2003 20:22, Hoeven, Maarten van der wrote: > > correction: section shoud be read as [mysqld] > > > > -----Original Message----- > > From: Hoeven, Maarten van der > > Sent: Tuesday, November 11, 2003 12:02 PM > > To: [EMAIL PROTECTED] > > Subject: Setting wait_timeout in my.cnf? > > -- > kind regards > > Nils Valentin > Tokyo/Japan > > http://www.be-known-online.com/mysql/ > > > Hi all, > > > > gosh, I must be overlooking something obvious. Running mysql 4.0.16. I > > want to set the wait_timeout in my.cnf (section [mysql]) like: > > > > wait_timeout = 300 > > > > also tried the depricated > > > > set-variable = wait_timeout=300 > > > > Both are not working; still default to 28800. Sure, I stopped and > > started the server. > > > > > > However, when I set the variable in the mysql-client with: > > > > set wait_timeout=30; > > > > the variable wait_timeout is changed! > > > > > > What am I overlooking? I really want to set this in my config-file, > > rather that setting it manually in the client... Any hints? > > > > > > PS. Linux Redhat 9 out of the Box, kernel 2.4.20-8 > > > > > > Maarten > > -------------------------------------------------------------- > > Zie ook/see also: http://www.knmi.nl/maildisclaimer.html > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > -------------------------------------------------------------- > > Zie ook/see also: http://www.knmi.nl/maildisclaimer.html > > ------------------------------------------------------- > > -- > kind regards > > Nils Valentin > Tokyo/Japan > > http://www.be-known-online.com/mysql/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -------------------------------------------------------------- > Zie ook/see also: http://www.knmi.nl/maildisclaimer.html -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ -------------------------------------------------------------- Zie ook/see also: http://www.knmi.nl/maildisclaimer.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
