Re: wait_timeout help

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

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

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

Re: wait_timeout help

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

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

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

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

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 it at the command line : set wait_timeout=x

Re: wait_timeout help

Hi specify it in the .cnf file in the mysqld options: wait_timeout=x or specify it at the command line : set wait_timeout=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]

Re: wait_timeout help

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