Re: Re: Persistant Connections and max_connections on mysql

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.