Hi. On Fri 2002-12-20 at 10:13:57 +0200, [EMAIL PROTECTED] wrote: > Hi . > Simple but still tricky question : what mean 'thread' in mysql's server > point of view ? > I've set the thread_cache_size=30 in my.cnf . > > I use Mysql with Php and my aplication's behaviour is like this : > connect -> > select > update > insert > select > ....etc.. > disconnect; > > This(above) is a thread that mysql caches ? If so , i don't think i can > benefit from thread cache because my threads > are very different from one to another :) .
The thread cache does not care, what a thread had executed. It is about saving the destroy/create cycle, when your app disconnects and the next one connects. So it is about re-using an existing thread for the next connection, instead of creating a new one for each new connection. HTH, Benjamin. -- [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php