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.

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

Reply via email to