Connection count and Threads

[Ivan Smahin]

Hello Ruslan,

Monday, February 18, 2008, 9:47:43 PM, you wrote:

> On 18/2/08 9:02 PM, "Mr. Bart Pietercil" <bart.pietercil at gmail.com> wrote:

> Hi Bart,

>>>> anybody care to explain the use of threads (and the implications of
>>>> the use of threads) and what does connection count learn me (is at
>>>> the moment at 808, what does that mean?)
>> 
>> What about connection count ?

> Ivan? :-)

Really, there are N worker threads (Threads defined in ini file)
which are maintaining all connected clients.

So clients count doesn't correspond to count of
worker threads. Any client activity will be "assigned" to "idle"
worker thread.


Example:
 23:26:25.218000 (2580): (1524) User: sa. Connection encoding: windows-1252 - LittleEndian.

 1524 - means "client id"
 2580 - worker thread handle assigned for the call.

 23:26:25.218000 (3480): (1524) Ping OK.

 "The ping is performed by 3480 thread for 1524 client."


808 - what do you mean? - How do you get it?
From log? Show that part of the log here please.





-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com