Re: Re: Persistant Connections and max_connections on mysql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




Dan Rossi wrote:
> 
> On 21/06/2005, at 6:06 PM, Catalin Trifu wrote:
> 
>>     Hi,
>>
>>     This is a database issue and has to do with the following mysql
>> variables:
>>
>>     interactive_timeout
>>     wait_timeout
>>
>>     By default these variables are set to 28800 and they represent the
>> time for which
>> the server waits on "persistent" connection.
>>     If you have a busy site that number is way too big; so try to
>> decrease
>> those variables and you should be fine:
>>
>>     mysql> set global interactive_timeout = 120;
>>     mysql> set global wait_timeout = 120;
>>
>>     This makes the timeout on connections 2 minutes after which mysql
>> disconects the user
>> and so freeing usable space for new connections.
>>     You can also add them in my.cnf so that the server gets them when
>> started:
>>
>>     set-variable = intercative_timeout=120
>>
> 
> Cheers its one or the other :O , I work most with intranet apps so dont
> have these kind of issues.

	I presume you mean whether it's interactive_timeout or wait_timeout, or ?
	Actually they both are important. Read the mysql at dev.mysql.com

C.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux