Re: DS 7.23 performance
Hi Niclas,
first, read your Release Notes concerning the SHMBASE settings.
You just have about 2000 BUFFERS, that is, 4MB of memory for
your cache and about 8MB for the virtual segment. It must be
possible to increase your cache.
Your complete configuration file looks a bit as if you didn't
change a lot. What about your old $TBCONFIG file. I think
it would be a good idea to post this, too.
Your major performance problems will be fixed by changing =
the parameter OPTCOMPIND from 2 to 0.
Best regards,
Stefan Weideneder
Niclas Bjorkdahl wrote:
> =
> We have upgraded from Online 5.06 to Dynamic Server 7.23.FC1 on OSF1
> ver 4.0 and have major performance problems. Some applications now are
> up to 6 times slower.
> =
> Applications also once in a while receives error -25587 and -25588.
> =
> I've tried to increase LOCKS and BUFFERS, but then receives:
> oninit: Fatal error in shared memory creation
> =
> ....and in the online.log:
> 17:21:26 shmat: [ENOMEM][12]: out of available data space, check system =MAXMEM
> 17:21:26 mt_shm_init: can't create virtual segment
> =
> Increasing SHMVIRTSIZE causes:
> 13:13:10 shmat: [EINVAL][22]: shared memory base address illegal
> 13:13:10 using 0x2025ce000, needs 0x800000
> 13:13:10 mt_shm_init: can't create virtual segment
> =
> ONCONFIG-PARAMETERS:
> =
> SERVERNUM 0 # Unique id corresponding to a OnLine ins=tance
> DBSERVERNAME ebba_on
> DBSERVERALIASES t2000 # List of alternate dbservernames
> NETTYPE ipcshm,,,CPU # Configure poll thread(s) for nettype
> NETTYPE soctcp,,,NET # Configure poll thread(s) for nettype
> DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distribute=
d env.
> RESIDENT 0 # Forced residency flag (Yes =3D 1, No =3D=
0)
> =
> MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-pro=cessor
> NUMCPUVPS 1 # Number of user (cpu) vps
> SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to=
one
> =
> NOAGE 0 # Process aging
> AFF_SPROC 0 # Affinity start processor
> AFF_NPROCS 0 # Affinity number of processors
> =
> # Shared Memory Parameters
> =
> LOCKS 8000 # Maximum number of locks
> BUFFERS 2000 # Maximum number of shared buffers
> NUMAIOVPS # Number of IO vps
> PHYSBUFF 32 # Physical log buffer size (Kbytes)
> LOGBUFF 32 # Logical log buffer size (Kbytes)> LOGSMAX 9 # Maximum number of logical log files
> CLEANERS 1 # Number of buffer cleaner processes
> SHMBASE 0x200000000 # Shared memory base address
> SHMVIRTSIZE 8192 # initial virtual shared memory segment s=ize
> SHMADD 8192 # Size of new shared memory segments (Kby=
tes)
> SHMTOTAL 0 # Total shared memory (Kbytes). 0=3D>unli=mited
> CKPTINTVL 300 # Check point interval (in sec)
> LRUS 8 # Number of LRU queues
> LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit
> LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit
> LTXHWM 50 # Long transaction high water mark percen=tage
> LTXEHWM 60 # Long transaction high water mark (exclu=
sive)
> TXTIMEOUT 0x12c # Transaction timeout (in sec)
> STACKSIZE 128 # Stack size (Kbytes)
> =
> # Parallel Database Queries (pdq)
> MAX_PDQPRIORITY 100 # Maximum allowed pdqpriority
> DS_MAX_QUERIES # Maximum number of decision support quer=ies
> DS_TOTAL_MEMORY # Decision support memory (Kbytes)
> DS_MAX_SCANS 1048576 # Maximum number of decision support scan=s
> DATASKIP off # List of dbspaces to skip
> =
> OPTCOMPIND 2 # To hint the optimizer
> =
> ONDBSPACEDOWN 2 # Dbspace down option: 0 =3D CONTINUE, 1 =
=3D ABORT, 2 =3D WAIT> LBU_PRESERVE 0 # Preserve last log for log backup
> OPCACHEMAX 0 # Maximum optical cache size (Kbytes)
> =
> # HETERO_COMMIT (Gateway participation in distributed transactions)
> # 1 =3D> Heterogeneous Commit is enabled
> # 0 (or any other value) =3D> Heterogeneous Commit is disabled
> HETERO_COMMIT 0
> =
> Kernel-parameters:
> =
> SEMMNI 512
> SEMMSL 1600
> SEMMNS 100
> =
> SHMMAX 2147483647
> SHMMIN 1
> SHMMNI 256
> SHMSEG 150
> =
> Machine-notes:
> =
> ebba vmunix: Digital UNIX V4.0B (Rev. 564); Sat Jun 27 21:39:45 MET DST =
1998
> ebba vmunix: physical memory =3D 256.00 megabytes.
> ebba vmunix: using 975 buffers containing 7.61 megabytes of memory
> ebba vmunix: AlphaServer 2100 5/300
> ebba vmunix: cpu 0 EV-5 4mb b-cache
> =
> Thanks in advance,
> /Nic
> --
> Niclas Bj=F6rkdahl Phone: +46-(0)31-707 25 93, Fax: +46-(0)31-707 =
25 99
> Applitron Datasystem Marieholmsgatan 10 C, S-415 02 G=F6teborg, Sweden=
-- =
Stefan Weideneder
----------------------------------------------------------------
----------------------------------------------------------------