Connection count and Threads

[Mr. Bart Pietercil]

Hi ruslan,
On 18-feb-08, at 19:36, Ruslan Zasukhin wrote:

> On 18/2/08 7:48 PM, "Mr. Bart Pietercil" <bart.pietercil at gmail.com>  
> wrote:
>
> Hi Bart,
>
>> Hi List,
>>
>> 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 ?



> 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 ?


thx

Bart