Subject | FB 1.5.2 CS limited to 32 users? |
---|---|
Author | Bradley Tate |
Post date | 2005-05-26T08:52:02Z |
Hi,
We're hitting performance limits with SuperServer and I'm having big
problems getting Classic running adequately on a multi-processor box.
Server: Dual Opteron
OS: Suse Linux 9.3, kernel 2.6.11 SMP
RAM: 2G
FB Version: FirebirdCS-1.5.2.4731-0.i686.rpm
We have a little program which runs on a Windows client (W2k) and
creates lots of processes which run queries against the server. For
some reason it won't create more than 32 processes agains a Classic
server, while with an SS server it creates hundreds.
I thought the problem might be in the semaphore settings, so I increased
SEMOPM in the linux kernel to 200, and LockSemCount in firebird.conf to
150. Rebooted everything and I'm still stuck at 32 processes. Then I
fiddled with ibconfig on the client, increasing the SEM_COUNT parameters
from 32 to 100. I don't know if they do anything but thought it was
worth a try. No luck.
Any help would be appreciated as I'm stumped. What I really need is
closer to 300 simultaneous connections so 32 is not a lot of use to me.
Hopefully I've done something stupid and easy to correct.
Thanks,
Bradley.
We're hitting performance limits with SuperServer and I'm having big
problems getting Classic running adequately on a multi-processor box.
Server: Dual Opteron
OS: Suse Linux 9.3, kernel 2.6.11 SMP
RAM: 2G
FB Version: FirebirdCS-1.5.2.4731-0.i686.rpm
We have a little program which runs on a Windows client (W2k) and
creates lots of processes which run queries against the server. For
some reason it won't create more than 32 processes agains a Classic
server, while with an SS server it creates hundreds.
I thought the problem might be in the semaphore settings, so I increased
SEMOPM in the linux kernel to 200, and LockSemCount in firebird.conf to
150. Rebooted everything and I'm still stuck at 32 processes. Then I
fiddled with ibconfig on the client, increasing the SEM_COUNT parameters
from 32 to 100. I don't know if they do anything but thought it was
worth a try. No luck.
Any help would be appreciated as I'm stumped. What I really need is
closer to 300 simultaneous connections so 32 is not a lot of use to me.
Hopefully I've done something stupid and easy to correct.
Thanks,
Bradley.