Thanks Paul, I am confused with these two variables in the server status:
Connections: 114577 Threads_created: 12759 Could you explain the difference between these two variables? "Connections" should be the number of connection attemplts to the MySQL server. Does this counts slave connections? Cause they are usually permanent connections. "Threads_created" - Number of threads created to handle connections. Thank you very much! Mihail ----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Mihail Manolov" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, August 02, 2002 1:45 PM Subject: Re: What is the difference between thread and connection > At 13:29 -0400 8/2/02, Mihail Manolov wrote: > >Could someone explain to me what is the difference between thread and > >connection? > > No difference. > > > > >I guess one connection can have many threads? Am I right? > > The server is multi-threaded. It associates a thread with each > connection. Connection ID and thread ID are synonymous. > > > > > > >Thanks, > > > >Mihail Manolov > > > >sql,query > > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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
