Re: Performance Issues
We identified this performance issue much. However, we cannot find any
cause that effect performance except the application itself is a
sequential process.
We are using raw devices. The current amount of data in the system is
approxiametly 100 GB and every day it grows. We cannot do fragmentation
for some of the big tables which we think that effect performance.
Because they are big tables and will not fit in 2Gb when we export
them. Also during fragmentation, the system will not be used by users.
Although, I said that it's a batch proccessing system, users use the
system very often by entering transactions. It's a credit card system.
The database is buffered logged. We need this type of logging
mechanism. Because the application itself needs it.
Please note that the information you want is below.
outout of onstat -g iof
========================
AIO global files:
gfd pathname totalops dskread dskwrite io/s
3 s01_01 3255177 1638398 1616779 1.0
4 s02_01 1151528 923048 228480 0.4
5 s03_01 11837403 10898263 939140 3.6
6 s03_02 10277008 8490613 1786395 3.2
7 s04_01 176530154 174971190 1558964 54.4
8 s04_02 6247454 4756935 1490519 1.9
9 s03_03 20956860 20601581 355279 6.5
10 s03_04 217330658 214360687 2969971 67.0
11 s03_05 8315346 7291898 1023448 2.6
12 s03_06 9327855 7882382 1445473 2.9
13 s03_07 9775108 8102368 1672740 3.0
14 s03_08 9127936 7720721 1407215 2.8
15 s04_03 98974098 98198270 775828 30.5
16 s04_04 15945331 15566937 378394 4.9
17 s04_05 13499984 12002841 1497143 4.2
18 s04_06 6325340 5238433 1086907 2.0
19 s01_02 30956934 28877794 2079140 9.5
20 s01_04 27742601 23669967 4072634 8.6
21 s05_01 23687891 22575239 1112652 7.3
22 s05_02 7713413 6966692 746721 2.4
23 s05_03 9147907 8306731 841176 2.8
24 s05_04 120234811 118613886 1620925 37.1
25 s05_05 35464291 33855275 1609016 10.9
26 s05_06 28692991 27372640 1320351 8.8
27 s05_07 34587915 33170763 1417152 10.7
28 s05_08 33808838 31578829 2230009 10.4
29 s06_01 13096241 10184973 2911268 4.0
30 s06_02 8101525 6558977 1542548 2.5
31 s06_03 24971123 21640482 3330641 7.7
32 s06_04 18335414 14374854 3960560 5.7
33 s06_05 36191233 33521494 2669739 11.2
34 s06_06 12337204 10738203 1599001 3.8
35 s06_07 18486486 15954908 2531578 5.7
36 s06_08 13327327 11556547 1770780 4.1
37 s02_02 1385571 1160803 224768 0.4
38 s02_03 1106794 873672 233122 0.3
39 s02_04 1197601 954595 243006 0.4
40 s02_05 1125811 885794 240017 0.3
41 s02_06 1149999 922398 227601 0.4
42 s02_07 18022931 15163720 2859211 5.6
43 s02_08 12913160 10669463 2243697 4.0
44 s01_05 29090240 15594435 13495805 9.0
45 s01_07 10112504 8339484 1773020 3.1
46 s01_08 9989315 8200980 1788335 3.1
47 s01_06 10991683 9493339 1498344 3.4
48 s01_03 10088619 8210907 1877712 3.1
49 s04_07 9549465 8090984 1458481 2.9
50 s04_08 30381922 28471617 1910305 9.4
51 s00_71 9324508 7960152 1364356 2.9
52 s00_72 24351079 22410581 1940498 7.5
53 s00_73 26948464 24014650 2933814 8.3
54 /tmp/error.log
56 /tmp/error.log
57 tmoves_debug.log
58 t00_02 1466363 1303660 162703 0.5
59 s00_75 3949334 3420057 529277 1.2
61 s00_80 3203771 2671359 532412 1.0
62 /tmp/error.log
63 tmoves_debug.log
64 /tmp/error.log
65 /tmp/error.log
68 s00_76 2945157 2557983 387174 0.9
69 /tmp/error.log
70 /tmp/error.log
71 s00_79 3998772 3108595 890177 1.2
72 tmoves_debug.log
73 s00_74 6827538 5746154 1081384 2.1
75 /tmp/error.log
76 tmoves_debug.log
78 /tmp/error.log
80 tmoves_debug.log
81 s00_78 3699232 2674743 1024489 1.1
82 /tmp/error.log
84 /tmp/error.log
85 s00_77 19839171 16912269 2926902 6.1
86 /tmp/error.log
87 /tmp/error.log
88 /tmp/error.log
90 /tmp/error.log
91 /tmp/error.log
92 tmoves_debug.log
94 /tmp/error.log
95 t00_01 5408670 5232767 175903 1.7
96 /tmp/error.log
97 /tmp/error.log
98 /tmp/error.log
100 /tmp/error.log
101 t00_04 33 32 1 0.0
102 tmoves_debug.log
103 /tmp/error.log
104 /tmp/error.log
105 /tmp/error.log
106 /tmp/error.log
107 /tmp/error.log
108 /tmp/error.log
109 t00_05 33 32 1 0.0
112 /tmp/error.log
113 /tmp/error.log
114 /tmp/error.log
115 /tmp/error.log
117 /tmp/error.log
118 tmoves_debug.log
119 /tmp/error.log
121 /tmp/error.log
122 t00_03 33 32 1 0.0
124 tmoves_debug.log
125 /tmp/error.log
126 /tmp/error.log
127 tmoves_debug.log
129 /tmp/error.log
130 /tmp/error.log
131 /tmp/error.log
133 /tmp/error.log
onstat -d
============
Informix Dynamic Server Version 7.31.UC3 -- On-Line -- Up 46 days
23:42:33 --
1487216 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
4d5a6150 1 1 1 1 N informix rootdbs
4d5dbc50 2 1 2 6 N informix logdbs
4d5dbd10 3 1 3 16 N informix dbs1
4d5dbdd0 4 1 5 5 N informix dbs2
4d5dbe90 5 1 19 13 N informix dbs3
4d5dbf50 6 1 27 16 N informix dbs4
4da78018 7 2001 42 1 N T informix tempdbs
612c6388 8 1 59 5 N informix dbspos
8 active, 2047 maximum
Chunks
address chk/dbs offset size free bpages flags pathname
4d5a6210 1 1 0 1000000 454507 PO-
/export/home/ifmxdata
/s01_01
4d5a71f0 2 2 0 1000000 9947 PO-
/export/home/ifmxdata
/s02_01
4d5a72d0 3 3 0 1000000 495259 PO-
/export/home/ifmxdata
/s03_01
4d5a73b0 4 3 0 1000000 0 PO-
/export/home/ifmxdata
/s03_02
4d5a7490 5 4 0 1000000 235218 PO-
/export/home/ifmxdata
/s04_01
4d5a7570 6 4 0 1000000 0 PO-
/export/home/ifmxdata
/s04_02
4d5a7650 7 3 0 1000000 0 PO-
/export/home/ifmxdata
/s03_03
4d5a7730 8 3 0 1000000 0 PO-
/export/home/ifmxdata
/s03_04
4d5a7810 9 3 0 1000000 0 PO-
/export/home/ifmxdata
/s03_05
4d5