Re: Re: Persistant Connections and max_connections on mysql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



	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 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, 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.

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux