|
|
Posted by "david forums" on 10/20/37 11:19
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.
>
Navigation:
[Reply to this message]
|