|
|
Posted by Dan Rossi on 06/21/05 11:26
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.
Navigation:
[Reply to this message]
|