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
*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
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
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
]
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
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
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
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
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
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
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
11 matches
Mail list logo