Re: Re: Persistant Connections and max_connections on mysql

Hi Use sqlrelay which manage persistance and load balancing and give very high speedy access cause is doing database pool connection cache. regards david Le Tue, 21 Jun 2005 11:47:29 +0200, Catalin Trifu <catalin@isp-software.de> a écrit:

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.