Re: Informix Performance Issues
PFB the onstat -p output and my thoughts on the same. Please provide your
valuable inputs.
The %cached for buffered read is a low number?it should be well above 95%.
Adding more buffers should solve this problem.
bufwaits can be brought down by reducing the RA_PAGES and RA_THRESHOLD.
params.This can be further checked from the RA stats below?.RA-pgsused is
greater than sum of ixda-RA ids-RA n da-RA
onstat ?p
IBM Informix Dynamic Server Version 9.30.FC6W4 -- On-Line -- Up 8 days
10:22:5
0 -- 1746404 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
1525587639 2242129221 16409885204 90.70 13386474 31272626 96935964 86.19
isamtot open start read write rewrite delete commit
rollbk
16611229372 161354924 870540973 12672021046 19719184 21971728 1518044
10158667
12809
gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs
706929 14664 3254021 14152 0 0 4
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
0 0 0 102375.25 31659.65 608 1801
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
131086405 5097807 2429049027 3 0 903 1938576 94027
ixda-RA idx-RA da-RA RA-pgsused lchwaits
38469248 109333718 748405431 894562606 4758183
--
Message posted via http://www.dbmonster.com