IDS Forum

Re: slow connections

Posted By: jak aka
Date: Tuesday, 2 December 2008, at 11:35 p.m.

In Response To: slow connections (ILKKA MUSTONEN)

My idea :

- OS level such as kernel parameter, error log from system
, i/o busy
- Network level such as network card errors , network log

For IDS :
- Check point duration and check point interval (system will be blocked while doing checkpoint)
- try to change

NETTYPE soctcp,4,100,NET
to

NETTYPE soctcp,1,400,NET (or 2,200) because you have only 3VPs , too much poll thread will affect VPs load
- Why you use "AFF_NPROCS 0" , try "AFF_NPROCS 3" and ensure that AFF_SPROC is the correct no.

Jakkrit A.

________________________________
From: ILKKA MUSTONEN <i.will.sue.you@gmail.com>
To: ids@iiug.org
Sent: Tuesday, December 2, 2008 1:57:46 AM
Subject: slow connections [14174]

IDS 10.00.FC7 on AIX 5.3 on IBM P550 server

Greetings fellow IIUGgers,
I'm getting sporadic slowness establishing connections OR complete connection
timeouts.
Not sure what could cause such behavior, the server is 95% idle.
Any recommendations where to look? I can provide other info, just ask.
Thanks,
--IAM

Following errors in online.log:
11:45:33 Checkpoint loguniq 72613, logpos 0x3310, timestamp: 0xa7a36a3c
11:45:33 Maximum server connections 281
11:47:07 listener-thread: err = -25573: oserr = 72: errstr = : Network driver
cannot accept a connection on the port. System error = 72.
11:49:16 Logical Log 72612 - Backup Started
11:49:17 Logical Log 72612 - Backup Completed
11:49:36 listener-thread: err = -25573: oserr = 72: errstr = : Network driver
cannot accept a connection on the port. System error = 72.
11:49:37 listener-thread: err = -25573: oserr = 72: errstr = : Network driver
cannot accept a connection on the port. System error = 72.
11:50:33 Fuzzy Checkpoint Completed: duration was 0 seconds, 347 buffers not
flushed.
11:50:33 Checkpoint loguniq 72613, logpos 0x4bd100, timestamp: 0xa7a38347

from /usr/include/sys/errno.h (to define oserr = 72)
#define ECONNABORTED 72 /* Software caused connection abort */

from onconfig:
# System Configuration
SERVERNUM 1 # Unique id corresponding to a OnLine instance
DBSERVERNAME biz_prod # Name of default database server
DBSERVERALIASES # List of alternate dbservernames
NETTYPE soctcp,4,100,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 1 # 0 for single-processor, 1 for multi-processor
NUMCPUVPS 3 # Number of user (cpu) vps
SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one
NOAGE 1 # Process aging
AFF_SPROC 0 # Affinity start processor
AFF_NPROCS 0 # Affinity number of processors
# Shared Memory Parameters
LOCKS 200000 # Maximum number of locks
NUMAIOVPS 2 # Number of IO vps
PHYSBUFF 32 # Logical log buffer size (Kbytes)
CLEANERS 12 # Number of buffer cleaner processes
SHMBASE 0x700000010000000L # Shared memory base address
SHMVIRTSIZE 386480 # initial virtual shared memory segment size
SHMADD 32768 # Size of new shared memory segments (Kbytes)
EXTSHMADD 32768 # Size of new extension shared memory segments (Kbytes)
SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited
SHMVIRT_ALLOCSEG 0 # Values between 0 and .99 are %, values > 1 are
CKPTINTVL 300 # Check point interval (in sec)
TXTIMEOUT 300 # Transaction timeout (in sec)
STACKSIZE 64 # Stack size (Kbytes)

last line of onstat -u
221 active, 384 total, 298 maximum concurrent

*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• slow connections
  ILKKA MUSTONEN -- Monday, 1 December 2008, at 1:57 p.m.
  • Re: slow connections
    jak aka -- Tuesday, 2 December 2008, at 11:35 p.m.
    • Re: slow connections
      ILKKA MUSTONEN -- Thursday, 4 December 2008, at 12:56 p.m.
      • Re: slow connections
        Jonathan Smaby -- Saturday, 6 December 2008, at 12:02 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.