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
<[EMAIL PROTECTED]> a écrit:
Dan Rossi wrote:
On 21/06/2005, at 6:06 PM, Cata
One other mysql optimization is to increase the thread_pool.
This way mysql spends less time creating threads; which on linux without NPTL
is not exactly a cheap operation.
Catalin
Dan Rossi wrote:
>
> On 21/06/2005, at 7:47 PM, Catalin Trifu wrote:
>
>>
>> I presume you mean wheth
On Tuesday 21 June 2005 18:33, Dan Rossi wrote:
> We should be sweet now, still use persistant connections on a high
> traffice server, but reduce the timeout for the threads before they
> drop off, hence why they stay open for so long and then run into the
> max_connection issues.
To be certain
On 21/06/2005, at 7:47 PM, Catalin Trifu wrote:
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.
We should be sweet now, still use persistant connections on a high
traffice server, bu
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 th
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 "p
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
7 matches
Mail list logo
