Re: wait_timeout help

2006-11-08 Thread Visolve DB Team
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 I set the wait_timeout

Re: wait_timeout help

2006-11-08 Thread Sayed Hadi Rastgou Haghi
*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 reason can be? On 11/7/06, Visolve DB Team [EMAIL

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. a href= http://www.spreadfirefox.com/?q=affiliatesamp;id=0amp;t=1; Get FireFox! /a

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- -- MySQL

Re: wait_timeout help

2006-11-07 Thread Visolve DB Team
] To: mysql@lists.mysql.com 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. a href= http

Re: wait_timeout help

2006-11-07 Thread Sayed Hadi Rastgou Haghi
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: mysql@lists.mysql.com Sent: Tuesday, November 07, 2006 2:08 PM Subject: wait_timeout help Dear All, I want to set

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 Visolve DB Team
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 options: wait_timeout=x or specify

Re: wait_timeout help

2006-11-07 Thread Sayed Hadi Rastgou Haghi
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: mysql@lists.mysql.com Sent: Tuesday, November 07, 2006 3:21 PM Subject: Re: wait_timeout help

Re: wait_timeout help

2006-11-07 Thread Visolve DB Team
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; +--+---+--++---+-++-+ | Id | User | Host

Re: wait_timeout help

2006-11-07 Thread Sayed Hadi Rastgou Haghi
by the CLIENT_INTERACTIVE connect option to mysql_real_connect()) Thanks ViSolve DB Team. - Original Message - *From:* Sayed Hadi Rastgou Haghi [EMAIL PROTECTED] *To:* Visolve DB Team [EMAIL PROTECTED] *Cc:* mysql@lists.mysql.com *Sent:* Tuesday, November 07, 2006 4:12 PM *Subject:* Re: wait_timeout help