Re: wait_timeout help

2006-11-08 Thread Sayed Hadi Rastgou Haghi
Team <[EMAIL PROTECTED]> *Cc:* mysql@lists.mysql.com *Sent:* Wednesday, November 08, 2006 11:51 AM *Subject:* Re: wait_timeout help Hi I set the wait_timeout in my.cnf. Sometimes it works well and there is no idle process 120 seconds time. But sometimes there are idle processes with 1900s time. What the

Re: wait_timeout help

2006-11-08 Thread Visolve DB Team
econnected with 'reconnect flag' set to 1 in the MySQL structure... Thanks ViSolve DB Team - Original Message - From: Sayed Hadi Rastgou Haghi To: Visolve DB Team Cc: mysql@lists.mysql.com Sent: Wednesday, November 08, 2006 11:51 AM Subject: Re: wait_timeout help Hi

Re: wait_timeout help

2006-11-07 Thread Sayed Hadi Rastgou Haghi
; *Cc:* mysql@lists.mysql.com *Sent:* Tuesday, November 07, 2006 4:12 PM *Subject:* Re: wait_timeout help Thanks again I have some questions that may help me explain my problem well. 1- What's this mean: mysql> SHOW PROCESSLIS; +--+---+--++---+

Re: wait_timeout help

2006-11-07 Thread Visolve DB Team
m Cc: mysql@lists.mysql.com Sent: Tuesday, November 07, 2006 4:12 PM Subject: Re: wait_timeout help Thanks again I have some questions that may help me explain my problem well. 1- What's this mean: mysql> SHOW PROCESSLIS; +--+---+--+-

Re: wait_timeout help

2006-11-07 Thread Sayed Hadi Rastgou Haghi
command line option, like mysql >set @@session.wait_timeout=15; mysql> show variables; Thanks Visolve DB Team. - Original Message - From: "Sayed Hadi Rastgou Haghi" <[EMAIL PROTECTED]> To: "Visolve DB Team" <[EMAIL PROTECTED]> Cc: Sent: Tuesday,

Re: wait_timeout help

2006-11-07 Thread Visolve DB Team
nt: Tuesday, November 07, 2006 3:21 PM Subject: Re: wait_timeout help Thanks But this sets. GLOBAL wait_timeout variable. Cab be seen by SHOW GLOBAL VARIABLES not by SHOW VARIABLES; On 11/7/06, Visolve DB Team <[EMAIL PROTECTED]> wrote: Hi specify it in the .cnf file in the mysqld op

Re: wait_timeout help

2006-11-07 Thread Christian Hammers
On 2006-11-07 Sayed Hadi Rastgou Haghi wrote: > Thanks > But this sets. GLOBAL wait_timeout variable. > Cab be seen by SHOW GLOBAL VARIABLES not by SHOW VARIABLES; Ah, yes, MySQL is very confusing about this special variable: You have to use "interactive_timeout = XXX" to change what is called "

Re: wait_timeout help

2006-11-07 Thread Sayed Hadi Rastgou Haghi
imeout=x or start mysqld with --wait_timeout=x along with other options. Thanks ViSolve DB Team - Original Message - From: "Sayed Hadi Rastgou Haghi" <[EMAIL PROTECTED]> To: Sent: Tuesday, November 07, 2006 2:08 PM Subject: wait_timeout help > Dear All, > > I wa

Re: wait_timeout help

2006-11-07 Thread Visolve DB Team
AIL PROTECTED]> To: Sent: Tuesday, November 07, 2006 2:08 PM Subject: wait_timeout help Dear All, I want to set wait_timeout variable on mysqld startup. Is there any way to do that? -- Sincerely, Hadi Rastgou A Google Account is the key that unlocks the world of Google. http://www.spre

Re: wait_timeout help

2006-11-07 Thread Christian Hammers
On 2006-11-07 Sayed Hadi Rastgou Haghi wrote: > Dear All, > > I want to set wait_timeout variable on mysqld startup. > Is there any way to do that? Put "wait_timeout = XXX" into the "[mysqld]" stanza of your /etc/mysql/my.cnf (or wherever your global config file is). bye, -christian- -- MyS

wait_timeout help

2006-11-07 Thread Sayed Hadi Rastgou Haghi
Dear All, I want to set wait_timeout variable on mysqld startup. Is there any way to do that? -- Sincerely, Hadi Rastgou A Google Account is the key that unlocks the world of Google. http://www.spreadfirefox.com/?q=affiliates&id=0&t=1";> Get FireFox!