Re: Online is RAM-Hungry
In article <33A5F357.3B27@echonyc.com>, Cosmo Lee <cosmo@echonyc.com>
writes
>I've been called in to troubleshoot an Online installation. The problem
>is that upon startup, Online immediately starts to "dynamically"
>allocate additional shared memory segments. The logfile shows 10
>allocations of 8,388,608 additional memory segments (A whopping
>additional 83 Meg!). I'm not sure how this is possible, given that
>SHMVIRTSIZE is set to 64,536 (64 Meg?) - the system only has 96 meg of
>memory total.
>
>Another weird thing is that they've got their chunks pointed to
>"/dev/dsk"-Block slices, rather than "/dev/rdsk"-Character slices. I'm
>not sure what affect this has, but the DB seems to be running ok. I've
>never seen that before...
>
Does work - I've done it but it is slow as UNIX does buffering as well
as online.
>In their Onconfig file, I can't seem to find anything that would need to
>have 83 additional MB of memory. The following are the possibly
>meaningful differences I've found. I'd appreciate it if anybody would
>let me know if they see anything that looks like it might be causing the
>prolem.
>
> theirs onconfig.std
> ------ ------------
>PHYSFILE 2560 1000
>SERVERNUM 7 0
>BUFFERS 1024 200
>PHYSBUF 2560 32
>LOGBUFF 2560 32
>USERTHREADS no entry 100
>TRANSACTIONS no entry 100
>TBLSPACES no entry 200
>CHUNKS no entry 8
>DBSPACES no entry 8
>SHMVIRTSIZE 64536 8000
>TIMEOUT 0x12c 300
>STACKSIZE 256 32
here it the problem, queries are running as PDQ queries, hence
indicies are probably not being used, set PDQPRIORITY = 0 and
MAXPDQPRIORITY = 0 in the onconfig file.
>PDQPRIORITY 10 0
> (dual-processor machine, but only 1 CPU enabled)
>
Apart from that I would need the output from onstat -a to
get more info...
--
David Williams