Re: Performance Problem with many buffer wait
In article <38111FF3.6C7C28F3@netvigator.com>, Grace Kan
<hykan@netvigator.com> writes
>Hi all informix expert,
>
> Thank you very much for all of your advice. And I have tuned the
>informix parameter to
>
> BUFFER=40000 (old 20000)
> LRUS=32 (old 16)
> CLEANERS=16 (old 8)
>
>and the database is still under monitoring, see whether it have improvement.
>
>ps. Here is some more information about my database and unix server.
>
> Machine : HP D350/2
> OS: HPUX10.20
> Memory: 1G
> Data Dbspace: 4G (4 chunk and 1G for each chunk)
>
> output of onstat -u
>
>Informix Dynamic Server Version 7.30.UC6X1 -- On-Line -- Up 5 days 07:06:27 --
>339280 Kbytes
>
>Userthreads
>address flags sessid user tty wait tout locks nreads
>nwrites
>c4aca018 ---P--D 1 informix - 0 0 0 11313 49701
>c4aca4cc ---P--F 0 informix - 0 0 0 0 405775
>
>c4aca980 ---P--F 0 informix - 0 0 0 0 456985
>
>c4acae34 ---P--F 0 informix - 0 0 0 0 523057
>
>c4acb2e8 ---P--F 0 informix - 0 0 0 0 454950
>
>c4acb79c ---P--F 0 informix - 0 0 0 0 394938
>
>c4acbc50 ---P--F 0 informix - 0 0 0 0 399707
>
>c4acc104 ---P--F 0 informix - 0 0 0 0 348578
>
>c4acc5b8 ---P--F 0 informix - 0 0 0 0 316917
>
>c4acca6c ---P--- 9 informix - 0 0 0 0 37394
>c4accf20 ---P--B 10 informix - 0 0 0 32423 17408
>c4acd3d4 Y--P--- 50560 osmcur12 ttyt6 c6d8f240 0 1 134 0
>c4acd888 Y--P--- 49368 osmcur19 ttyu0 c5ddd3c8 0 1 1 0
>c4acdd3c ---P--D 13 informix - 0 0 0 0 0
>c4ace1f0 ---P--- 50353 osmde08 osm20 0 0 3 614 512
>c4ace6a4 Y--P--- 2788 dcs - c6f1cac0 0 1 0 0
>c4aceb58 ---P--- 50601 osmde15 osm35 0 0 1 674 256
>c4acf00c ---P--- 50753 osmde21 osm12 0 0 3 92 0
>c4acf4c0 --BP--- 45500 scladm - 0 0 17 3538 3859
>c4acf974 Y--P--- 50648 hwchung osm01 c5af1870 0 1 1 0
>c4acfe28 Y--P--- 50595 lswong ttytc ca4d3380 0 1 1 0
>c4ad0790 ---P--- 50376 osmpde02 osm03 0 0 3 566 704
>c4ad10f8 ---P--- 27299 scladm - 0 0 1 53619 20295
>c4ad15ac Y--P--- 4274 shckln1 shck3 c5eb9da0 0 1 6 0
>c4ad1a60 Y--P--- 47911 dcs - c73045f0 0 1 11160 0
>c4ad1f14 Y--P--- 49906 chchan shch2 caf3f820 0 1 1 0
>c4ad287c Y--P--- 3084 scladm - c633ba58 0 1 375 384
>c4ad31e4 Y--P--- 50615 osmde01 osm55 c5d2fa40 0 3 119 192
>c4ad3698 Y--P--- 50136 osmcur12 ttys9 e8fff370 0 1 3 0
>c4ad4000 Y--P--- 50538 chchan ttyub c5ff8ef8 0 1 0 0
>c4ad44b4 Y--P--- 49236 shckln1 shck7 c8ce80e8 0 0 159 64
>c4ad4e1c Y--P--- 50510 chchan shch2 c5d33738 0 1 48 0
>c4ad52d0 Y--P--- 2799 dcs - c6aecc90 0 1 848 0
>c4ad5784 Y--P--- 47741 dcs - c6359d10 0 1 121 0
>c4ad65a0 Y--P--- 3081 scladm - c6e172d0 0 1 252 512
>c4ad6f08 Y--P--- 50680 osmde18 osm56 c8740528 0 3 111 128
>c4ad73bc Y--P--- 50614 hwchung ttyud c5e637a0 0 1 1 0
>c4ad7870 Y--P--- 47115 dcs - c6953ee0 0 1 7151 0
>c4ad7d24 B--PR-- 50686 hwchung ttyud c22403a8 0 1 1238 64
>c4ad81d8 Y--P--- 50183 lswong osm37 c602e310 0 1 1 0
>c4ad868c Y--P--- 2785 dcs - c6f1af18 0 1 0 0
>c4ad8b40 Y--P--- 50678 osmde18 osm56 c713ca70 0 1 5 0
>c4ad94a8 Y--P--- 50402 spdclk ttyr5 c5d0a2a0 0 4 268 0
>c4ad995c ---P--- 50643 osmpde07 osm32 0 0 1 228 256
>c4ada2c4 Y--P--- 2787 dcs - c6f1c188 0 1 0 0
>c4ada778 Y--P--- 50621 osmde20 osm45 c63bf998 0 1 4 0
>c4adac2c ---P--- 50736 spddox ttyqa 0 0 8 48 64
>c4adb0e0 Y--P--- 2784 dcs - c54971b0 0 1 206 0
>c4adb594 Y--P--- 50749 osmcur36 ttyp8 c8b63ee0 0 1 37 0
>c4adbefc ---P--- 50645 osmde19 osm21 0 0 1 722 320
>c4adc3b0 Y--P--- 48298 osmpde03 osm11 ca050f98 0 1 5 0
>c4adc864 ---P--- 50453 osmcur40 ttys6 0 0 1 89 0
>c4adcd18 ---P--- 50771 hwchung - 0 0 1 0 0
>c4add1cc Y--P--- 49664 spdclk ttyu7 c5ff1678 0 1 7 0
>c4add680 --BP--- 50657 dheadm - 0 0 7 278 128
>c4addb34 Y--P--- 50435 spddox ttysf c7a334b0 0 4 694 256
>c4addfe8 Y--P--- 50242 osmde01 osm55 caaf2508 0 1 0 0
>c4ade49c Y--P--- 50565 osmcur35 ttyre c7bab710 0 1 354 0
>c4ade950 ---P--- 50516 osmopr - 0 0 4 9505 0
>c4adee04 Y--P--- 48415 osmpde17 osm33 c4e15090 0 1 1 0
>c4adf2b8 Y--P--- 45185 dcs - c5d133e8 0 1 5074 0
>c4adf76c ---P--- 50130 osmpde08 osm34 0 0 1 1419 896
>c4adfc20 Y--P--- 48497 osmpde07 osm32 c62c2190 0 1 2 0
>c4ae00d4 Y--P--- 48359 osmcur36 ttysa c548e900 0 1 8 0
>c4ae0ef0 Y--P--- 50637 osmde14 ttyue cb2e9090 0 1 0 0
>c4ae1858 ---P--- 50563 osmpde14 osm17 0 0 3 235 192
>c4ae1d0c Y--P--- 49835 raicoho ttysd ccff8300 0 1 0 0
>c4ae21c0 Y--P--- 50750 chchan shch1 c799cb30 0 1 6 0
>c4ae2674 Y--P--- 41236 sisadm - cdbc1fc8 0 1 1062 768
>c4ae2b28 ---P--- 50769 scladm - 0 0 1 0 64
>c4ae3490 Y--P--- 49658 osmcur23 osm36 cd371cd8 0 1 1 0
>c4ae3944 ---P--- 50369 osmde05 osm05 0 0 1 952 512
>c4ae3df8 Y--P--- 50759 osmcur12 ttyu3 c6012120 0 1 29 0
>c4ae42ac Y--P--- 50335 lswong ttyp4 c612c718 0 1 9 0
>c4ae4760 Y--P--- 50020 spdclk ttyr5 c5efea98 0 1 9 0
>c4ae4c14 Y--P--- 50761 osmcur36 ttyp8 c6afbbb0 0 1 6 0
>c4ae50c8 B--PR-- 50627 hwchung ttyud c22bc08c 0 1 1606 0
>c4ae557c Y--P--- 47295 osmcur01 ttyvd ce27efb0 0 1 86 0
>c4ae5a30 Y--P--- 50104 lswong ttyp4 c78f5258 0 1 2 64
>c4ae5ee4 Y--P--- 50154 spddox ttysf c564e2c0 0 1 1 0
>c4ae6d00 Y--P--- 50370 osmpde02 osm03 c6d416b0 0 1 0 0
>c4ae7668 Y--P--- 49865 cramos ttys2 c994ea48 0 1 1 0
>c4ae7b1c Y--P--- 49370 osmcur19 ttyu0 c4f875a0 0 1 4 0
>c4ae7fd0 ---P--- 50574 osmcur12 - 0 0 1 2144 0@@
Hi all informix expert,
Thank you very much for all of your advice. And I have tuned the
informix parameter to
BUFFER=40000 (old 20000)
LRUS=32 (old 16)
CLEANERS=16 (old 8)
and the database is still under monitoring, see whether it have improvement.
ps. Here is some more information about my database and unix server.
Machine : HP D350/2
OS: HPUX10.20
Memory: 1G
Data Dbspace: 4G (4 chunk and 1G for each chunk)
output of onstat -u
Informix Dynamic Server Version 7.30.UC6X1 -- On-Line -- Up 5 days 07:06:27 --
339280 Kbytes
Userthreads
address flags sessid user tty wait tout locks nreads
nwrites
c4aca018 ---P--D 1 informix - 0 0 0 11313 49701
c4aca4cc ---P--F 0 informix - 0 0 0 0 405775
c4aca980 ---P--F 0 informix - 0 0 0 0 456985
c4acae34 ---P--F 0 informix - 0 0 0 0 523057
c4acb2e8 ---P--F 0 informix - 0 0 0 0 454950
c4acb79c ---P--F 0 informix - 0 0 0 0 394938
c4acbc50 ---P--F 0 informix - 0 0 0 0 399707
c4acc104 ---P--F 0 informix - 0 0 0 0 348578
c4acc5b8 ---P--F 0 informix - 0 0 0 0 316917
c4acca6c ---P--- 9 informix - 0 0 0 0 37394
c4accf20 ---P--B 10 informix - 0 0 0 32423 17408
c4acd3d4 Y--P--- 50560 osmcur12 ttyt6 c6d8f240 0 1 134 0
c4acd888 Y--P--- 49368 osmcur19 ttyu0 c5ddd3c8 0 1 1 0
c4acdd3c ---P--D 13 informix - 0 0 0 0 0
c4ace1f0 ---P--- 50353 osmde08 osm20 0 0 3 614 512
c4ace6a4 Y--P--- 2788 dcs - c6f1cac0 0 1 0 0
c4aceb58 ---P--- 50601 osmde15 osm35 0 0 1 674 256
c4acf00c ---P--- 50753 osmde21 osm12 0 0 3 92 0
c4acf4c0 --BP--- 45500 scladm - 0 0 17 3538 3859
c4acf974 Y--P--- 50648 hwchung osm01 c5af1870 0 1 1 0
c4acfe28 Y--P--- 50595 lswong ttytc ca4d3380 0 1 1 0
c4ad0790 ---P--- 50376 osmpde02 osm03 0 0 3 566 704
c4ad10f8 ---P--- 27299 scladm - 0 0 1 53619 20295
c4ad15ac Y--P--- 4274 shckln1 shck3 c5eb9da0 0 1 6 0
c4ad1a60 Y--P--- 47911 dcs - c73045f0 0 1 11160 0
c4ad1f14 Y--P--- 49906 chchan shch2 caf3f820 0 1 1 0
c4ad287c Y--P--- 3084 scladm - c633ba58 0 1 375 384
c4ad31e4 Y--P--- 50615 osmde01 osm55 c5d2fa40 0 3 119 192
c4ad3698 Y--P--- 50136 osmcur12 ttys9 e8fff370 0 1 3 0
c4ad4000 Y--P--- 50538 chchan ttyub c5ff8ef8 0 1 0 0
c4ad44b4 Y--P--- 49236 shckln1 shck7 c8ce80e8 0 0 159 64
c4ad4e1c Y--P--- 50510 chchan shch2 c5d33738 0 1 48 0
c4ad52d0 Y--P--- 2799 dcs - c6aecc90 0 1 848 0
c4ad5784 Y--P--- 47741 dcs - c6359d10 0 1 121 0
c4ad65a0 Y--P--- 3081 scladm - c6e172d0 0 1 252 512
c4ad6f08 Y--P--- 50680 osmde18 osm56 c8740528 0 3 111 128
c4ad73bc Y--P--- 50614 hwchung ttyud c5e637a0 0 1 1 0
c4ad7870 Y--P--- 47115 dcs - c6953ee0 0 1 7151 0
c4ad7d24 B--PR-- 50686 hwchung ttyud c22403a8 0 1 1238 64
c4ad81d8 Y--P--- 50183 lswong osm37 c602e310 0 1 1 0
c4ad868c Y--P--- 2785 dcs - c6f1af18 0 1 0 0
c4ad8b40 Y--P--- 50678 osmde18 osm56 c713ca70 0 1 5 0
c4ad94a8 Y--P--- 50402 spdclk ttyr5 c5d0a2a0 0 4 268 0
c4ad995c ---P--- 50643 osmpde07 osm32 0 0 1 228 256
c4ada2c4 Y--P--- 2787 dcs - c6f1c188 0 1 0 0
c4ada778 Y--P--- 50621 osmde20 osm45 c63bf998 0 1 4 0
c4adac2c ---P--- 50736 spddox ttyqa 0 0 8 48 64
c4adb0e0 Y--P--- 2784 dcs - c54971b0 0 1 206 0
c4adb594 Y--P--- 50749 osmcur36 ttyp8 c8b63ee0 0 1 37 0
c4adbefc ---P--- 50645 osmde19 osm21 0 0 1 722 320
c4adc3b0 Y--P--- 48298 osmpde03 osm11 ca050f98 0 1 5 0
c4adc864 ---P--- 50453 osmcur40 ttys6 0 0 1 89 0
c4adcd18 ---P--- 50771 hwchung - 0 0 1 0 0
c4add1cc Y--P--- 49664 spdclk ttyu7 c5ff1678 0 1 7 0
c4add680 --BP--- 50657 dheadm - 0 0 7 278 128
c4addb34 Y--P--- 50435 spddox ttysf c7a334b0 0 4 694 256
c4addfe8 Y--P--- 50242 osmde01 osm55 caaf2508 0 1 0 0
c4ade49c Y--P--- 50565 osmcur35 ttyre c7bab710 0 1 354 0
c4ade950 ---P--- 50516 osmopr - 0 0 4 9505 0
c4adee04 Y--P--- 48415 osmpde17 osm33 c4e15090 0 1 1 0
c4adf2b8 Y--P--- 45185 dcs - c5d133e8 0 1 5074 0
c4adf76c ---P--- 50130 osmpde08 osm34 0 0 1 1419 896
c4adfc20 Y--P--- 48497 osmpde07 osm32 c62c2190 0 1 2 0
c4ae00d4 Y--P--- 48359 osmcur36 ttysa c548e900 0 1 8 0
c4ae0ef0 Y--P--- 50637 osmde14 ttyue cb2e9090 0 1 0 0
c4ae1858 ---P--- 50563 osmpde14 osm17 0 0 3 235 192
c4ae1d0c Y--P--- 49835 raicoho ttysd ccff8300 0 1 0 0
c4ae21c0 Y--P--- 50750 chchan shch1 c799cb30 0 1 6 0
c4ae2674 Y--P--- 41236 sisadm - cdbc1fc8 0 1 1062 768
c4ae2b28 ---P--- 50769 scladm - 0 0 1 0 64
c4ae3490 Y--P--- 49658 osmcur23 osm36 cd371cd8 0 1 1 0
c4ae3944 ---P--- 50369 osmde05 osm05 0 0 1 952 512
c4ae3df8 Y--P--- 50759 osmcur12 ttyu3 c6012120 0 1 29 0
c4ae42ac Y--P--- 50335 lswong ttyp4 c612c718 0 1 9 0
c4ae4760 Y--P--- 50020 spdclk ttyr5 c5efea98 0 1 9 0
c4ae4c14 Y--P--- 50761 osmcur36 ttyp8 c6afbbb0 0 1 6 0
c4ae50c8 B--PR-- 50627 hwchung ttyud c22bc08c 0 1 1606 0
c4ae557c Y--P--- 47295 osmcur01 ttyvd ce27efb0 0 1 86 0
c4ae5a30 Y--P--- 50104 lswong ttyp4 c78f5258 0 1 2 64
c4ae5ee4 Y--P--- 50154 spddox ttysf c564e2c0 0 1 1 0
c4ae6d00 Y--P--- 50370 osmpde02 osm03 c6d416b0 0 1 0 0
c4ae7668 Y--P--- 49865 cramos ttys2 c994ea48 0 1 1 0
c4ae7b1c Y--P--- 49370 osmcur19 ttyu0 c4f875a0 0 1 4 0
c4ae7fd0 ---P--- 50574 osmcur12 - 0 0 1 2144 0
c4ae8484 Y--P--- 50396 osmcur12 ttys8 c5ea9158 0 1 1 0
c4ae8938 Y--P--- 41238 sisadm - c6353e10 0 1 0 0
c4ae8dec ---P--- 49130 osmopr - 0