Re: What is the difference between thread and connection

2002-08-02 Thread Paul DuBois
At 14:53 -0400 8/2/02, Mihail Manolov wrote: >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? Threads get reused. When you disconnect, the thread that the

Re: What is the difference between thread and connection

2002-08-02 Thread Jeremy Zawodny
On Fri, Aug 02, 2002 at 02:53:38PM -0400, Mihail Manolov wrote: > 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? Thread caching. MySQL doesn't alwa

Re: What is the difference between thread and connection

2002-08-02 Thread Mihail Manolov
ECTED]>; <[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? >

Re: What is the difference between thread and connection

2002-08-02 Thread Paul DuBois
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.

What is the difference between thread and connection

2002-08-02 Thread Mihail Manolov
Could someone explain to me what is the difference between thread and connection? I guess one connection can have many threads? Am I right? Thanks, Mihail Manolov sql,query - Before posting, please check: http