increasing informix performance
Chris Huys
I have a customer which has as configuration :
HP9000 / N4000/6 CPU (360 Mhz)
4 Gbyte memory (2 Gbyte free)
mirrored FC10 configuration
informix 7.30.UC7
The checkpoint duration of his system is during working hours between
1 and
8 seconds.
In glance/disk report the cum# of raw IO requests is almost 20% of the
total amount of IO requests (= Logical IO requests), which I find
rather high.
Before I propose, any change to his present informix configuration, as
I'm no informix dba, but a simple HP-UX support engineer :-), I
thought I may pass its current config to this group and see what youre
recommendations are.
Thx, in advance.
Chris
=============================================================================
glance / disk report (5 minutes of activity )
DISK REPORT
Users= 10
Req Type Requests % Rate Bytes Cum Req % Cum
Rate Cum Byte
--------------------------------------------------------------------------------
Local Logl Rds 17690 99.7 4020.4 279.1mb 1035548 98.3 2086.9
<wrong#>
Logl Wts 59 0.3 13.4 50kb 17893 1.7 36.0
281.4mb
Phys Rds 2027 93.0 460.6 34.9mb 200430 82.8 403.9
3.44gb
Phys Wts 152 7.0 34.5 797kb 41514 17.2 83.6
440.5mb
User 27 1.2 6.1 47kb 7265 3.0 14.6
29.6mb
Virt Mem 4 0.2 0.9 4kb 1134 0.5 2.2
19.6mb
System 121 5.6 27.5 746kb 22126 9.1 44.5
125.2mb
Raw 2027 93.0 460.6 34.9mb 211419 87.4 426.0
3.70gb
Remote Logl Rds 0 0.0 0.0 0kb 0 0.0 0.0
0kb
Logl Wts 0 0.0 0.0 0kb 0 0.0 0.0
0kb
Phys Rds 0 0.0 0.0 0kb 0 0.0 0.0
0kb
Phys Wts 0 0.0 0.0 0kb 0 0.0 0.0
0kb
#sar -u
HP-UX antaut B.11.00 U 9000/800 01/21/02
00:00:01 %usr %sys %wio %idle
<cut>
08:00:01 14 11 21 55
08:20:00 19 12 20 49
08:40:00 22 12 20 47
09:00:00 22 12 19 47
09:20:00 22 13 16 49
09:40:01 20 12 20 48
10:00:00 22 11 28 39
10:20:00 32 12 29 28
10:40:00 25 12 33 29
11:00:00 26 12 31 30
11:20:01 25 13 32 30
11:40:00 26 11 11 53
12:00:00 24 11 16 49
12:20:00 28 10 41 21
12:40:00 26 12 36 27
13:00:00 28 12 32 28
13:20:00 27 9 15 49
13:40:00 27 10 28 35
14:00:00 36 11 11 42
<cut>
#vi /opt/informix/online.log
Mon Jan 21 00:02:28 2002
<cut>
10:32:53 Checkpoint Completed: duration was 4 seconds.
10:32:54 Logical Log 22627 Complete.
10:38:01 Checkpoint Completed: duration was 4 seconds.
10:40:07 Logical Log 22628 Complete.
10:43:11 Checkpoint Completed: duration was 6 seconds.
10:48:07 Logical Log 22629 Complete.
10:48:19 Checkpoint Completed: duration was 5 seconds.
10:53:25 Checkpoint Completed: duration was 3 seconds.
10:58:31 Checkpoint Completed: duration was 4 seconds.
10:58:34 Logical Log 22630 Complete.
11:03:42 Checkpoint Completed: duration was 8 seconds.
11:08:41 Logical Log 22631 Complete.
11:08:50 Checkpoint Completed: duration was 4 seconds.
11:13:58 Checkpoint Completed: duration was 5 seconds.
11:18:00 Logical Log 22632 Complete.
11:19:05 Checkpoint Completed: duration was 4 seconds.
11:24:13 Checkpoint Completed: duration was 5 seconds.
11:27:54 Logical Log 22633 Complete.
11:29:22 Checkpoint Completed: duration was 5 seconds.
11:34:29 Checkpoint Completed: duration was 4 seconds.
11:38:30 Logical Log 22634 Complete.
11:39:36 Checkpoint Completed: duration was 5 seconds.
11:44:44 Checkpoint Completed: duration was 4 seconds.
<cut>
onstat -p
Informix Dynamic Server Version 7.30.UC7 -- On-Line (Prim) -- Up 4
days 04:32:
52 -- 774136 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
67478504 7190043 3130479126 97.84 3236324 3016660 11351051 71.49
isamtot open start read write rewrite delete commit
rollbk
2613490313 359450682 504700424 835601896 1069289 162315 521543
808888 199
gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
0 0 0 0 0 0 0
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 104383.24 6228.01 1211 2422
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress
seqscans
11771181 10 1958846026 0 0 1865 56771
1004014
ixda-RA idx-RA da-RA RA-pgsused lchwaits
58407793 42720 1483017 59688471 4262154
Informix Dynamic Server Version 7.30.UC7 -- On-Line (Prim) -- Up 4
days 04:33:
55 -- 774136 Kbytes
onstat -F
Fg Writes LRU Writes Chunk Writes
0 393754 604369
address flusher state data
8d12a4cc 0 I 0 = 0X0
8d12a980 1 I 0 = 0X0
8d12ae34 2 I 0 = 0X0
8d12b2e8 3 I 0 = 0X0
8d12b79c 4 I 0 = 0X0
8d12bc50 5 I 0 = 0X0
states: Exit Idle Chunk Lru
onstat -g iov
Informix Dynamic Server Version 7.30.UC7 -- On-Line (Prim) (CKPT
REQ) -- Up 4
days 04:34:23 -- 774136 Kbytes
Blocked:CKPT
AIO I/O vps:
class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup
errors
msc 0 i 0.2 55377 0 0 0 55125 1.0
0
aio 0 s 9.7 3507303 2965316 541899 0 3250920 1.1
0
aio 1 s 6.9 2490380 2050602 439741 0 2242202 1.1
0
aio 2 s 6.0 2183153 1807404 375732 0 1937430 1.1
0
aio 3 s 5.4 1959252 1691203 268039 0 1731451 1.1
0
aio 4 s 4.7 1705265 1490445 214811 0 1491117 1.1
0
aio 5 s 4.1 1469365 1301079 168280 0 1264147 1.2
0
aio 6 s 3.6 1315889 1178020 137864 0 1115645 1.2
0
aio 7 s 3.3 1201920 1084264 117652 0 1009914 1.2
0
aio 8 s 3.1 1106467 1001564 104898 0 918832 1.2
0
aio 9 s 2.8 1013575 918348 95225 0 833517 1.2
0
aio 10 s 2.6 926254 838033 88218 0 750784 1.2
0
aio 11 s 2.3 838629 755255 83371 0 665844 1.3
0
aio 12 s 2.1 751406 671688 79713 0 580718 1.3
0
aio 13 s 1.8 667505 591686 75818 0 498761 1.3
0
aio 14 s 1.6 597271 524396 72873 0 423231 1.4
0
aio 15 s 1.5 541770 471581 70189 0 355460 1.5
0
pio 0 i 0.1 20611 0 20611 0 20607 1.0
0
lio 0 i 0.1 27801 0 27801 0 27775 1.0
0
onstat -g ioq
Informix Dynamic Server Version 7.30.UC7 -- On-Line (Prim) -- Up 4
days 04:36:
43 -- 774136 Kbytes
AIO I/O queues:
q name/id len maxlen totalops dskread dskwrite dskcopy
adt 0 0 0 0 0 0 0
msc 0 0 2 55385 0 0 0
aio 0 0 15 322 117 8 0
pio 0 0 1 20615 0 20615 0
lio 0 0 1 27804 0 27804 0
gfd 3 0 8 28543 23771 4772 0
gfd 4 0 50 2432531 1173272 1259259 0
gfd 5 0 99 15511423 15445443 65980 0
gfd 6 0 88 11648667 11554783 93884 0
gfd 7 0 46 2389656 1152128 1237528 0
gfd 8 0 87 14904073 14735447 168626 0
gfd 9 0 101 23367276 23073651 293625 0
gfd 10 0 1 20 19 1 0
gfd 11 0 1 20 19 1 0
gfd 12 0 48 384609 320129 64480 0
gfd 13 0 1 19 19 0 0
gfd 14 0 1 19 19 0 0
gfd 15 0 1 19 19 0 0
gfd 16 0 1 19 19 0 0
gfd 17 0 1 19 19 0 0
gfd 18 0 1 19 19 0 0
gfd 19 0 1 19 19 0 0
onstat -g seg
Informix Dynamic Server Version 7.30.UC7 -- On-Line (Prim) -- Up 4
days 04:36:
43 -- 774136 Kbytes
Segment Summary:
id key addr size ovhd class blkused
blkfree
512 1381451777 80000000 219258880 13008 R 26759 6
(shared) 1381451777 8d11a000 573456384 9360 V 21043 48959
4617 1381451778 c37d5000 1654784 636 M 199 3
522 1381451779 c3969000 1654784 636 M 195 7
267 1381451780 c3afd000 1654784 636 M 195 7
524 1381451781 c3c91000 1654784 636 M 195 7
Total: - - 799334400 - - 48586 48989
(* segment locked in memory)
onstat -l
Informix Dynamic Server Version 7.30.UC7 -- On-Line (Prim) -- Up 4
days 04:39:
44 -- 774136 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 13 21 411435 20628 19.95
phybegin physize phypos phyused %used
10003f 10240 8744 34 0.33
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages
pages/io
L-1 0 16 5787924 239197 27824 24.2 8.6
Subsystem numrecs Log Space used
OLDRSAM 5787924 457772012
address number flags uniqid begin size used
%used
801889a4 1 U------ 23561 10283f 750 750
100.00
801889c0 2 U---C-L 23562 102b2d 750 646
86.13
801889dc 3 U-B---- 23523 102e1b 750 750
100.00
801889f8 4 U-B---- 23524 103109 750 750
100.00
80188a14 5 U-B---- 23525 1033f7 750 750
100.00
80188a30 6 U-B---- 23526 1036e5 750 750
100.00
80188a4c 7 U-B---- 23527 1039d3 750 750
100.00
80188a68 8 U-B---- 23528 103cc1 750 741
98.80
80188a84 9 U-B---- 23529 103faf 750 750
100.00
80188aa0 10 U-B---- 23530 10429d 750 750
100.00
80188abc 11 U-B---- 23531 10458b 750 750
100.00
80188ad8 12 U-B---- 23532 104879 750 271
36.13
80188af4 13 U-B---- 23533 104b67 750 750
100.00
80188b10 14 U-B---- 23534 104e55 750 750
100.00
80188b2c 15 U-B---- 23535 105143 750 750
100.00
80188b48 16 U-B---- 23536 105431 750 750
100.00
80188b64 17 U-B---- 23537 10571f 750 750
100.00
80188b80 18 U-B---- 23538 105a0d 750 750
100.00
80188b9c 19 U-B---- 23539 105cfb 750 750
100.00
80188bb8 20 U-B---- 23540 105fe9 750 750
100.00
80188bd4 21 U-B---- 23541 1062d7 750 750
100.00
80188bf0 22 U-B---- 23542 1065c5 750 750
100.00
80188c0c 23 U-B---- 23543 1068b3 750 750
100.00
80188c28 24 U-B---- 23544 106ba1 750 750
100.00
80188c44 25 U-B---- 23545 106e8f 750 750
100.00
80188c60 26 U-B---- 23546 10717d 750 750
100.00
80188c7c 27 U-B---- 23547 10746b 750 750
100.00
80188c98 28 U-B---- 23548 107759 750 750
100.00
80188cb4 29 U-B---- 23549 107a47 750 750
100.00
80188cd0 30 U-B---- 23550 107d35 750 750
100.00
80188cec 31 U-B---- 23551 108023 750 750
100.00
80188d08 32 U-B---- 23552 108311 750 750
100.00
80188d24 33 U-B---- 23553 1085ff 750 750
100.00
80188d40 34 U-B---- 23554 1088ed 750 449
59.87
80188d5c 35 U------ 23555 108bdb 750 750
100.00
80188d78 36 U------ 23556 108ec9 750 750
100.00
80188d94 37 U------ 23557 1091b7 750 750
100.00
80188db0 38 U------ 23558 1094a5 750 750
100.00
80188dcc 39 U------ 23559 109793 750 750
100.00
80188de8 40 U------ 23560 109a81 750 750
100.00
onstat -D
Informix Dynamic Server Version 7.30.UC7 -- On-Line (Prim) -- Up 4
days 04:58:
43 -- 774136 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
8d128158 1 1 1 1 N informix rootdbs
8d1294d8 2 2001 2 1 N T informix dbtemp1
8d129598 3 1 3 8 N informix
dbspace1
8d129658 4 2001 5 1 N T informix dbtemp2
8d129718 5 1 10 6 N informix
dbspace2
5 active, 2047 maximum
Chunks
address chk/dbs offset page Rd page Wr pathname
8d128218 1 1 0 258829 656609 /dev/online_root1
8d1286d8 2 2 0 265264 1008055 /dev/online_temp1
8d1287b8 3 3 0 468331 66096 /dev/online_db1
8d128898 4 3 0 2033680 93997 /dev/online_db2
8d128978 5 4 0 2024826 667502 /dev/online_temp2
8d128a58 6 3 0 1260736 168662 /dev/online_db3
8d128b38 7 3 0 276085 294425 /dev/online_db4
8d128c18 8 3 0 19 1 /dev/online_db5
8d128cf8 9 3 0 19 1 /dev/online_db6
8d128dd8 10 5 0 610963 64615 /dev/online_db7
8d128eb8 11 5 0 19 0 /dev/online_db8
8d128f98 12 5 0 19 0 /dev/online_db9
8d129078 13 5 0 19 0 /dev/online_db10
8d129158 14 5 0 19 0 /dev/online_db11
8d129238 15 5 0 19 0 /dev/online_db12
8d129318 16 3 0 19 0 /dev/online_db13
8d1293f8 17 3 0 19 0 /dev/online_db14
17 active, 2047 maximum
root@antaut:/opt/informix/bin(1089)# onstat -u |grep "P--F"
8d12a4cc ---P--F 0 informix - 0 0 0 0
158034
8d12a980 ---P--F 0 informix - 0 0 0 0
101865
8d12ae34 ---P--F 0 informix - 0 0 0 0
110009
8d12b2e8 ---P--F 0 informix - 0 0 0 0
179426
8d12b79c ---P--F 0 informix - 0 0 0 0
143141
8d12bc50 ---P--F 0 informix - 0 0 0 0
313558
onstat -c
Informix Dynamic Server Version 7.30.UC7 -- On-Line (Prim) -- Up 4
days 04:42:
25 -- 774136 Kbytes
Configuration File: /opt/informix/etc/onconfig
#**************************************************************************
#
# INFORMIX SOFTWARE, INC.
#
# Title: onconfig.std
# Description: Informix Dynamic Server Configuration Parameters
#
#**************************************************************************
# Root Dbspace Configuration
ROOTNAME rootdbs # Root dbspace name
ROOTPATH /dev/online_root1 # Path for root dbspace
ROOTOFFSET 0 # Offset of root dbspace into device
(Kbytes)
ROOTSIZE 155648 # Size of root dbspace (Kbytes)
# Disk Mirroring Configuration Parameters
MIRROR 1 # Mirroring flag (Yes = 1, No = 0)
MIRRORPATH # Path for device containing mirrored
root
MIRROROFFSET 0 # Offset into mirrored device (Kbytes)
# Physical Log Configuration
PHYSDBS rootdbs # Location (dbspace) of physical log
PHYSFILE 20480 # Physical log file size (Kbytes)
# Logical Log Configuration
LOGFILES 40 # Number of logical log files
LOGSIZE 1500 # Logical log size (Kbytes)
# Diagnostics
MSGPATH /opt/informix/etc/online.log # System message log file
path
CONSOLE /dev/console # System console message path
#ALARMPROGRAM /opt/informix/etc/log_full.sh # Alarm program path
SYSALARMPROGRAM /opt/informix/etc/evidence.sh # System Alarm program
path
TBLSPACE_STATS 1
# System Archive Tape Device
#TAPEDEV /oschijf/ontape.hdr
#TAPEDEV /dev/null # Tape device path
#TAPEDEV /dev/rmt/0m # Tape device path
TAPEDEV /dev/tape_db # Tape device path
TAPEBLK 64 # Tape block size (Kbytes)
TAPESIZE 24576000 # Maximum amount of data to put on
tape (Kbytes)
# Log Archive Tape Device
#LTAPEDEV /dev/null # Log tape device path
LTAPEDEV /dev/tape_ll # Log tape device path
LTAPEBLK 64 # Log tape block size (Kbytes)
LTAPESIZE 24576000 # Max amount of data to put on log
tape (Kbytes)
# Optical
STAGEBLOB # Informix Dynamic Server/Optical
staging area
# System Configuration
SERVERNUM 1 # Unique id corresponding to a Dynamic
Server in
DBSERVERNAME ol_antaut # Name of default database server
DBSERVERALIASES ol_antaut1,ol_antaut1hdr_tcp
# List of alternate dbservernames
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 4 # 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 1 # Affinity start processor
AFF_NPROCS 4 # Affinity number of processors
# Shared Memory Parameters
LOCKS 20000 # Maximum number of locks
# BUFFERS 16384 # Maximum number of shared buffers
BUFFERS 100000 # TUNE checkpoints
NUMAIOVPS 16 # Number of IO vps
PHYSBUFF 42 # Physical log buffer size (Kbytes)
LOGBUFF 32 # Logical log buffer size (Kbytes)
LOGSMAX 100 # Maximum number of logical log files
CLEANERS 6 # Number of buffer cleaner processes
SHMBASE 0x0 # Shared memory base address
##SHMVIRTSIZE 327680 # initial virtual shared memory
segment size
##SHMADD 163840 # 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 2 # LRU percent dirty begin cleaning
limit
LRU_MIN_DIRTY 0 # LRU percent dirty end cleaning limit
LTXHWM 40 # Long transaction high water mark
percentage
LTXEHWM 50 # Long transaction high water mark
(exclusive)
TXTIMEOUT 0x12c # Transaction timeout (in sec)
STACKSIZE 32 # Stack size (Kbytes)
# System Page Size
# BUFFSIZE - Dynamic Server no longer supports this configuration
parameter.
# To determine the page size used by Dynamic Server on your
platform
# see the last line of output from the command, 'onstat
-b'.
# Recovery Variables
# OFF_RECVRY_THREADS:
# Number of parallel worker threads during fast recovery or an offline
restore.
# ON_RECVRY_THREADS:
# Number of parallel worker threads during an online restore.
OFF_RECVRY_THREADS 10 # Default number of offline worker
threads
ON_RECVRY_THREADS 1 # Default number of online worker
threads
# Data Replication Variables
# DRAUTO: 0 manual, 1 retain type, 2 reverse type
DRAUTO 0 # DR automatic switchover
DRINTERVAL 3 # DR max time between DR buffer
flushes (in sec)
DRTIMEOUT 30 # DR network timeout (in sec)
DRLOSTFOUND /opt/informix/etc/dr.lostfound # DR lost+found file
path
# CDR Variables
CDR_LOGBUFFERS 2048 # size of log reading buffer pool
(Kbytes)
CDR_EVALTHREADS 1,2 # evaluator threads
(per-cpu-vp,additional)
CDR_DSLOCKWAIT 5 # DS lockwait timeout (seconds)
CDR_QUEUEMEM 4096 # Maximum amount of memory for any CDR
queue (Kb
ytes)
# Backup/Restore variables
BAR_ACT_LOG /tmp/bar_act.log
BAR_MAX_BACKUP 0
BAR_RETRY 1
BAR_NB_XPORT_COUNT 10
BAR_XFER_BUF_SIZE 31
# Informix Storage Manager variables
ISM_DATA_POOL ISMData # If the data pool name is changed, be
sure to
# update $INFORMIXDIR/bin/onbar.
Change to
# ism_catalog -create_bootstrap -pool
<new name>
ISM_LOG_POOL ISMLogs
# Read Ahead Variables
RA_PAGES 32 # Number of pages to attempt to read
ahead
RA_THRESHOLD 16 # Number of pages left before next
group
# DBSPACETEMP:
# Dynamic Server equivalent of DBTEMP for SE. This is the list of
dbspaces
# that the Dynamic Server SQL Engine will use to create temp tables
etc.
# If specified it must be a colon separated list of dbspaces that
exist
# when the Dynamic Server system is brought online. If not specified,
or if
# all dbspaces specified are invalid, various ad hoc queries will
create
# temporary files in /tmp instead.
DBSPACETEMP dbtemp2,dbtemp1 # Default temp dbspaces
# DUMP*:
# The following parameters control the type of diagnostics information
which
# is preserved when an unanticipated error condition (assertion
failure) occurs
# during Dynamic Server operations.
# For DUMPSHMEM, DUMPGCORE and DUMPCORE 1 means Yes, 0 means No.
DUMPDIR /tmp # Preserve diagnostics in this
directory
DUMPSHMEM 1 # Dump a copy of shared memory
DUMPGCORE 0 # Dump a core image using 'gcore'
DUMPCORE 0 # Dump a core image (Warning:this
aborts Dynamic
Server)
DUMPCNT 1 # Number of shared memory or gcore
dumps for
# a single user's session
FILLFACTOR 90 # Fill factor for building indexes
# method for Dynamic Server to use when determining current time
USEOSTIME 0 # 0: use internal time(fast), 1: get
time from O
S(slow)
# Parallel Database Queries (pdq)
MAX_PDQPRIORITY 50 # 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
# 0 => Nested loop joins will be preferred (where
# possible) over sortmerge joins and hash joins.
# 1 => If the transaction isolation mode is not
# "repeatable read", optimizer behaves as in (2)
# below. Otherwise it behaves as in (0) above.
# 2 => Use costs regardless of the transaction isolation
# mode. Nested loop joins are not necessarily
# preferred. Optimizer bases its decision purely
# on costs.
OPTCOMPIND 2 # To hint the optimizer
ONDBSPACEDOWN 2 # Dbspace down option: 0 = CONTINUE, 1
= ABORT,
2 = WAIT
LBU_PRESERVE 1 # 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
# HETERO_COMMIT (Gateway participation in distributed transactions)
# 1 => Heterogeneous Commit is enabled
# 0 (or any other value) => Heterogeneous Commit is disabled
HETERO_COMMIT 0
# Optimization goal: -1 = ALL_ROWS(Default), 0 = FIRST_ROWS
OPT_GOAL -1
# Optimizer DIRECTIVES ON (1/Default) or OFF (0)
DIRECTIVES 1
# Status of restartable restore
RESTARTABLE_RESTORE off
NETTYPE ipcshm,4,150,CPU # Configure poll thread(s) for
nettype
NETTYPE soctcp,2,50,NET # Configure poll thread(s) for nettype
#ALARMPROGRAM /opt/pip/system/backup_log.sh # Configured by
SETUPFBACKUP
SHMVIRTSIZE 560000 # Configured by Kernel Param
SHMADD 64000 # Configured by Kernel Param
#ALARMPROGRAM /opt/pip/system/backup_log.sh # Configured by
SETUPFBACKUP
#ALARMPROGRAM /opt/pip/system/backup_log.sh # Configured by
SETUPFBACKUP
ALARMPROGRAM /opt/pip/system/backup_log.sh # Configured by
SETUPFBACKUP
Neil Truby
news:9dc4e78a.02012...@posting.google.com...
> Hi @,
>
> I have a customer which has as configuration :
> The checkpoint duration of his system is during working hours between
> 1 and
> 8 seconds.
> Before I propose, any change to his present informix configuration, as
> I'm no informix dba, but a simple HP-UX support engineer :-),
Tuning Informix is easy. All you have to remember is one simple rule: "No
parameter change you can make will ever make one-fiftieth the impact of
increasing BUFFERS"! In this case, with 4GBytes of memory, and assuming
that there are no other memory-hungry systems running on the server,
Informix or otherwise, I would tempted to increse BUFFERS to, say, 250000
(500MBytes) and see if the rather poor write cache rate can be coaxed
towards 90%.
With a low checkpoint interval of 5 minutes, and a low maximum dirty lru
threshold of 2, your checkpoints are occasionally occurring within the
interval. Also, the bulk of the i/o activity is going to the temp dbspaces.
I would invite the client to have a long hard look at the application, and
try to home in on critical slow-running processes. I suspect you may find
that some shite database or application design is the real villan here.
Other things: kaio on HP-UX is a Good Thing, so I'd enable this. If this
isn't acceptable, increase the number of aio vps until the last few are
doing very little. The logical logs are woefully inadequare in size. Are
they being backed up? If possible, the logical and physical logs should be
isolated both from one another, and from "hot" dbspaces. Both appear to be
in the root dbspace in your example.
That'll be £1000 please.
Abajo De Ysidro
> Hi @,
>
> I have a customer which has as configuration :
> HP9000 / N4000/6 CPU (360 Mhz)
> 4 Gbyte memory (2 Gbyte free)
> mirrored FC10 configuration
> informix 7.30.UC7
>
> The checkpoint duration of his system is during working hours between
> 1 and
> 8 seconds.
>
Buenas Dias Senors y Senoritas;
Agree with Niel, but found una mas interesting things in config:
RESIDENT 0 # Forced residency flag (Yes = 1, No =
Does not HP/UX support residency? Es remotely possible es swapping?
Hasta - Abajo
Fred Prose
activity is on your rootdbs. It would appear that your logical logs and
Physical logs are contained in the root dbspace. Those need to be moved to
seperate dbspaces, preferably on different devices and (if you can)
different controllers.
It would also appear that you have two dbspaces with multiple chunks.
Unfortunatley, Informix doesn't distribute the I/O amoung all chunks evenly.
As you can notice from the "onstat -D", nine of the chucks have no I/O after
four days of uptime.
Overall, I think you need to check your I/O distribution on your
disks/controllers.
You are doing a lot of Chunk writes in proportion to the LRU writes.
Considering what you have LRU_MAX_DIRTY and LRU_MIN_DIRTY set to, Informix
should be cleaning almost constantly. However, you only have six cleaners -
that's two low for 100000 buffers.
Neil Truby
"Fred Prose" <fpr...@supreme.sp.state.az.us> wrote in message
news:a36ad4$e...@netnews.state.az.us...
> A couple of problems with your configuration. Notice how hight the I/O
> activity is on your rootdbs. It would appear that your logical logs and
> Physical logs are contained in the root dbspace. Those need to be moved
to
> seperate dbspaces, preferably on different devices and (if you can)
> different controllers.
"Polly want a cracker"