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

Reply via email to