Hi Ann,

--- "Ann W. Harrison" <aharrison@...> wrote:

> KIMURA, Meiji wrote:
>
> >
> > I use Firebird CS in default setting. it means cache is 75.
> > I don't understand Ann's 'That's consistent with running out of semaphores.'
>
> Semaphore usage is related to the number of pages in cache and the
> number of connections trying to use those pages. The larger the
> cache, the more likely it is you'll use semaphores.

I understood this.

> > Set caches size between 100 and 200, I can avoid becoming of process so big ?
>
> Increasing the cache size will make things worse.
>
> Hmmm... could you show us a process list with memory usage
> when the system is using a gig of memory?

Here is the list of top command.
The process marked with "<- 1G".
I'm sorry for a long list in advance.


10:51:34 up 205 days, 23:41, 1 user, load average: 5.25, 4.42, 3.64
102 processes: 100 sleeping, 1 running, 1 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 17.2% 0.0% 2.9% 0.2% 0.7% 33.7% 45.0%
cpu00 1.9% 0.0% 2.9% 0.0% 0.0% 4.9% 90.0%
cpu01 19.8% 0.0% 2.9% 0.0% 0.0% 77.2% 0.0%
cpu02 1.9% 0.0% 1.9% 0.9% 2.9% 3.9% 88.2%
cpu03 45.0% 0.0% 3.9% 0.0% 0.0% 49.0% 1.9%
Mem: 3094708k av, 3076484k used, 18224k free, 0k shrd, 21316k buff
2367312k actv, 293884k in_d, 46656k in_c
Swap: 2008240k av, 544192k used, 1464048k free 1492752k cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
13770 mrtg 24 0 10304 10M 1904 S 11.5 0.3 0:01 3 mrtg

18598 firebird 16 0 1056M 859M 10332 D 2.9 28.4 5:28 1 fb_inet_server <- 1G

736 root 15 0 139M 119M 1872 S 1.9 3.9 338:23 2 java
13779 mrtg 25 0 580 580 412 D 0.4 0.0 0:00 1 rateup
13774 root 19 0 1264 1264 896 R 0.2 0.0 0:00 3 top
1 root 15 0 508 508 452 S 0.0 0.0 3:48 1 init
2 root RT 0 0 0 0 SW 0.0 0.0 0:00 0 migration/0
3 root RT 0 0 0 0 SW 0.0 0.0 0:00 1 migration/1
4 root RT 0 0 0 0 SW 0.0 0.0 0:00 2 migration/2
5 root RT 0 0 0 0 SW 0.0 0.0 0:00 3 migration/3
6 root 15 0 0 0 0 SW 0.0 0.0 1:26 3 keventd
7 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd/0
8 root 34 19 0 0 0 SWN 0.0 0.0 0:00 1 ksoftirqd/1
9 root 34 19 0 0 0 SWN 0.0 0.0 0:00 2 ksoftirqd/2
10 root 34 19 0 0 0 SWN 0.0 0.0 0:00 3 ksoftirqd/3
13 root 15 0 0 0 0 SW 0.0 0.0 2:29 3 bdflush
11 root 15 0 0 0 0 SW 0.0 0.0 969:08 0 kswapd
12 root 15 0 0 0 0 SW 0.0 0.0 201:19 0 kscand
14 root 15 0 0 0 0 SW 0.0 0.0 343:55 2 kupdated
15 root 25 0 0 0 0 SW 0.0 0.0 0:00 2 mdrecoveryd
21 root 25 0 0 0 0 SW 0.0 0.0 0:00 2 scsi_eh_0
24 root 15 0 0 0 0 SW 0.0 0.0 133:40 1 kjournald
78 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 khubd
658 root 15 0 0 0 0 SW 0.0 0.0 0:00 3 kjournald
659 root 15 0 0 0 0 SW 0.0 0.0 133:18 0 kjournald
660 root 15 0 0 0 0 SW 0.0 0.0 261:06 3 kjournald
661 root 15 0 0 0 0 SW 0.0 0.0 90:32 2 kjournald
662 root 15 0 0 0 0 SW 0.0 0.0 43:17 3 kjournald
1937 root 15 0 644 644 536 S 0.0 0.0 7:24 3 syslogd
1941 root 15 0 440 440 384 S 0.0 0.0 0:03 2 klogd
1951 root 15 0 448 448 388 S 0.0 0.0 14:40 0 irqbalance
1959 rpc 15 0 580 580 500 S 0.0 0.0 0:00 1 portmap
1978 rpcuser 25 0 688 688 612 S 0.0 0.0 0:00 1 rpc.statd
2075 root 15 0 2208 2208 936 S 0.0 0.0 24:48 3 snmpd
2126 root 15 0 868 868 632 S 0.0 0.0 0:26 3 sshd
2140 root 15 0 580 580 468 S 0.0 0.0 19:09 0 xinetd
2155 ntp 15 0 2560 2560 2200 S 0.0 0.0 13:19 3 ntpd
2182 root 15 0 1072 1072 376 S 0.0 0.0 9:03 3 sendmail
2191 smmsp 15 0 720 712 168 S 0.0 0.0 0:05 1 sendmail
2201 root 15 0 72 72 20 S 0.0 0.0 0:01 3 gpm
2210 root 15 0 580 580 140 S 0.0 0.0 8:56 3 httpd
2221 wnn 24 0 3440 3440 20 S 0.0 0.1 0:00 2 jserver
2222 nobody 15 0 660 652 136 S 0.0 0.0 0:21 3 httpd
2223 nobody 15 0 876 876 352 S 0.0 0.0 0:23 0 httpd
2224 nobody 15 0 640 640 136 S 0.0 0.0 0:05 3 httpd
2225 nobody 15 0 588 588 88 S 0.0 0.0 0:00 2 httpd
2226 nobody 15 0 876 876 352 S 0.0 0.0 0:23 2 httpd
2235 bin 15 0 468 468 32 S 0.0 0.0 0:05 2 cannaserver
2246 root 15 0 340 340 264 S 0.0 0.0 1:34 3 crond
2301 xfs 15 0 2916 2916 100 S 0.0 0.0 0:09 2 xfs
2320 daemon 15 0 200 200 140 S 0.0 0.0 0:11 0 atd
2334 root 25 0 396 396 180 S 0.0 0.0 0:00 0 S99MibBrowser_S
2335 root 15 0 160 160 48 S 0.0 0.0 24:48 0 initlog
2338 root 24 0 284 284 164 S 0.0 0.0 0:00 2 sh
2367 root 25 0 11096 10M 812 S 0.0 0.3 213:18 2 java
2485 root 21 0 60 60 8 S 0.0 0.0 0:00 2 mingetty
2486 root 21 0 60 60 8 S 0.0 0.0 0:00 1 mingetty
2487 root 21 0 60 60 8 S 0.0 0.0 0:00 2 mingetty
2488 root 21 0 64 64 12 S 0.0 0.0 0:00 2 mingetty
2490 root 21 0 52 52 8 S 0.0 0.0 0:00 3 mingetty
2491 root 21 0 52 52 8 S 0.0 0.0 0:00 1 mingetty
2493 root 15 0 940 940 308 S 0.0 0.0 0:00 0 gdm-binary
2539 root 15 0 852 852 148 S 0.0 0.0 0:00 1 gdm-binary
2540 root 15 0 15488 7036 712 S 0.0 0.2 428:53 3 X
2673 gdm 15 0 21148 20M 1988 S 0.0 0.6 221:51 2 gdmgreeter
29311 nobody 15 0 832 832 328 S 0.0 0.0 0:22 2 httpd
29313 nobody 15 0 660 644 136 S 0.0 0.0 0:21 3 httpd
29381 nobody 15 0 944 944 420 S 0.0 0.0 0:22 3 httpd
24946 root 15 0 7492 7456 7300 S 0.0 0.2 0:37 1 fb_lock_mgr
25239 nobody 15 0 672 664 168 S 0.0 0.0 0:19 3 httpd
27575 nobody 15 0 708 708 208 S 0.0 0.0 0:14 0 httpd
26674 root 22 0 340 340 212 S 0.0 0.0 0:00 1 run.sh
26690 root 24 0 222M 199M 1520 S 0.0 6.6 1498m 0 java
29421 nobody 15 0 660 660 156 S 0.0 0.0 0:03 0 httpd
29422 nobody 15 0 668 668 164 S 0.0 0.0 0:03 1 httpd
27351 nobody 15 0 676 648 172 S 0.0 0.0 0:00 3 httpd
30340 nobody 15 0 888 888 384 S 0.0 0.0 0:02 1 httpd
19828 nobody 15 0 860 852 356 S 0.0 0.0 0:01 0 httpd
19829 nobody 15 0 668 656 164 S 0.0 0.0 0:00 2 httpd
19830 nobody 15 0 672 664 168 S 0.0 0.0 0:00 3 httpd
3340 nobody 15 0 1192 1184 688 S 0.0 0.0 0:01 0 httpd
5409 nobody 15 0 912 896 408 S 0.0 0.0 0:01 1 httpd
21388 nobody 15 0 888 888 384 S 0.0 0.0 0:01 1 httpd
6226 nobody 15 0 1172 1172 668 S 0.0 0.0 0:01 2 httpd
15326 root 23 0 1124 1112 976 S 0.0 0.0 0:02 1 checkCmtsSP.sh
3232 root 25 0 1028 1028 908 S 0.0 0.0 0:00 0 CmtsStatusProvi
3234 root 24 0 11716 10M 1152 S 0.0 0.3 8:50 0 java
15210 root 15 0 1180 968 696 S 0.0 0.0 0:15 3 cupsd
32101 root 20 0 516 456 444 S 0.0 0.0 0:00 0 crond
32108 root 15 0 0 0 0 Z 0.0 0.0 0:00 2 checkTims.sh <defunct>
735 root 21 0 1032 1032 916 S 0.0 0.0 0:00 2 poseidon.sh
1748 firebird 15 0 9648 9648 8244 S 0.0 0.3 0:00 3 fb_inet_server
1750 firebird 15 0 10820 10M 9412 S 0.0 0.3 0:00 1 fb_inet_server
1752 firebird 15 0 10864 10M 9464 S 0.0 0.3 0:00 3 fb_inet_server
3708 root 23 0 584 584 512 S 0.0 0.0 0:00 3 sleep
4003 mrtg 15 0 584 584 512 S 0.0 0.0 0:00 3 sleep
5298 mrtg 20 0 588 588 512 S 0.0 0.0 0:00 3 sleep
13359 root 15 0 1912 1908 1544 S 0.0 0.0 0:00 1 sshd
13407 root 16 0 1408 1408 1160 S 0.0 0.0 0:00 3 bash
13771 mrtg 15 0 584 584 512 S 0.0 0.0 0:00 1 sleep