Hi all,

I have a client that is having problems with a new server, they are trying
to improve performance on a system temporarily (their actual aim is to eval
FB 1 / IB 7). Their old server is dual proc 800 MHZ PIII with 1GB RAM OS /
swap and temp on mirrored, data on 5 disk raid. New server is 2.2Ghz PIII
with 2GB RAM and same disk config (except disks spin 2x old disk speed.

The new server starts off being a lot quicker, but performance degrades as
load increases during the day. They are doing all kinds of observational
testing and have noticed that under heavy load the IB process' No of threads
jumps between 20 -> 240.

They are convinced the configs are the same, although I haven't inspected
the new servers, on a count(*) of a very large (> 20million) row table, the
performance is 5 x faster with the new box, but under heavy load this
degrades on small selects dramatically.

So my Q. What a threads used for in 5.6 SS? Any help would be appreciated
as I don't really have an idea without going onsite and doing loads of
testing.

Cheers all,

JAC.