Connection count and Threads

[Mr. Bart Pietercil]

On 18-feb-08, at 20:47, Ruslan Zasukhin 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? :-)
>
>
>>> Threads
>>>
>>> * VSERVER have inside N worker threads.
>>>
>>> * if you hardware have single CPU, then it is not wise set many
>>> threads.
>>>       4-10 will be good.
>>>
>>>   because then you start waste time on thread switch.
>>>
>>> * if you have 4-8 CPUs then can be good idea raise this parameter.
>>>
>>> And as always, often only experiment will show you the best values
>>> for your
>>> hardware + db + tasks.
>>>
>>
>> Since the db is running on a quad core xserve and in activity monitor
>> I see the load rise sometimes to 150% CPU (I suppose that is 1,5
>> cores ), a number of 10 threads seems reasonable ?
>>
>> Is there a relation between connections and threads ?
>
> I have not catched yet about which connection count you talking.
>
> You have Vserver Office unlimited?
>    and you have now 800 live connections?


it is indeed a VServer Office unlimited. However when I relaunch  
vStudio and reconnect to this server its connection count is 25. The  
only way this VServer is connected to is through vPHP.... (and vPHP  
keeps causing Client suddenly disconnected in the log)

Bart