Setting wait_timeout in my.cnf?
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]
RE: Setting wait_timeout in my.cnf?
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? 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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]
RE: Re: Setting wait_timeout in my.cnf?
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Setting wait_timeout in my.cnf?
Hoeven, Maarten van der [EMAIL PROTECTED] wrote: 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. Set up value for interactive_timeout variable, too. 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 -- 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]
RE: Setting wait_timeout in my.cnf?
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]