Subject Re: [firebird-support] Re: Questions about SuperServer
Author Milan Babuskov
fabiano_bonin wrote:
> My Slackware version is 10.1.
> Kernel version is 2.4.29.

I forgot to mention. I run 2.6. kernel. I just checked, and Slack 10.1
does not have NTPL, and neither does 10.2 with 2.4 kernel, so sorry for
confusion. Here's copy/paste from 10.2's README.NTPL file:

This version of Slackware contains support in glibc for NPTL (the Native
POSIX Thread Library). NPTL works with newer kernels (meaning 2.6.x, or
a 2.4 kernel that is patched to support NPTL, but not an unmodified
"vanilla" 2.4 kernel such as Slackware uses) to provide improved
performance for threads.

> ps -e | grep fb

You should really use ps -axf, in order to see if those are threads or
processes. Alternatively, you can use:

pstree | grep fb


I just took non-NTPL package and installed on my Slackware 9.1 box
(kernel 2.4.22):

root@sar FirebirdSS-2.0.0.12710-ReleaseCandidate3.i686# ./install.sh

Firebird super 2.0.0.12710-ReleaseCandidate3.i686 Installation

Press Enter to start installation or ^C to abort
Extracting install data
Updated /etc/services
Starting Firebird server: server has been successfully started
Please enter new password for SYSDBA user: aa
Install completed
root@sar FirebirdSS-2.0.0.12710-ReleaseCandidate3.i686# ps -e | grep fb
737 ? 00:00:00 fbguard
738 ? 00:02:06 fbserver
root@sar FirebirdSS-2.0.0.12710-ReleaseCandidate3.i686#

root@sar FirebirdSS-2.0.0.12710-ReleaseCandidate3.i686# pstree | grep fb
|-fbguard---fbserver---fbserver---4*[fbserver]

This is without any connections. Now I connect to employee database, and
check again:

milanb@sar milanb$ ps -e | grep fb
737 ? 00:00:00 fbguard
738 ? 00:05:09 fbserver

milanb@sar milanb$ pstree | grep fb
|-fbguard---fbserver---fbserver---6*[fbserver]

root@sar root# fuser /opt/firebird/examples/empbuild/employee.fdb
/opt/firebird/examples/empbuild/employee.fdb: 738 739 742 743
770 771 772 773

Interesting, and (as you can see) not much different from what you have.

Ok, then I cleaned up everything, installed non-ntpl SS 1.5.3:

root@sar FirebirdSS-1.5.3.4870-0.i686# ps -e | grep fb
952 pts/1 00:00:00 fbguard
953 ? 00:00:00 fbserver
root@sar FirebirdSS-1.5.3.4870-0.i686# pstree | grep fb
|-fbguard---fbserver---fbserver---fbserver
root@saruman FirebirdSS-1.5.3.4870-0.i686#

Connected to employee database:

root@sar root# fuser /opt/firebird/examples/employee.fdb
/opt/firebird/examples/employee.fdb: 953 954 957 979 980 981
982

I guess the behavior is expected. I really didn't use SS much since FB
1.0, so I can't be 100% sure, but this appears fine.

--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org