Posted by Catalin Trifu on 06/21/05 14:24

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.

• Next in forum: Re: [PHP] MySQLI, Class not found
• Prev in forum: Re: [PHP] Re: Persistant Connections and max_connections on mysql
• Thread view: Re: [PHP] Re: Persistant Connections and max_connections on mysql

[Reply to this message]