DS 7.23 performance
Posted in 1998
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 instance
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 distributed env.
RESIDENT 0 # Forced residency flag (Yes = 1, No = 0)
MULTIPROCESSOR 0 # 0 for single-processor, 1 for multi-processor
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 size
SHMADD 8192 # Size of new shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
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 percentage
LTXEHWM 60 # Long transaction high water mark (exclusive)
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 queries
DS_TOTAL_MEMORY # Decision support memory (Kbytes)
DS_MAX_SCANS 1048576 # Maximum number of decision support scans
DATASKIP off # List of dbspaces to skip
OPTCOMPIND 2 # To hint the optimizer
ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1 = ABORT, 2 = WAITLBU_PRESERVE 0 # Preserve last log for log backup
OPCACHEMAX 0 # Maximum optical cache size (Kbytes)
# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Commit is enabled
# 0 (or any other value) => 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 = 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'rkdahl Phone: +46-(0)31-707 25 93, Fax: +46-(0)31-707 25 99
Applitron Datasystem Marieholmsgatan 10 C, S-415 02 G'teborg, Sweden