数据的读写率低
环境:IBM AIX5.1 INFORMIX 10.00.FC
维护问题
数据库的ontape -p中的写操作率低,正常情况下都应该在95%以上,读率正常,一般都在99%,但是写的情况下,在刚开始时,数据库的写率还很高,过一段时间后,只有50%~60%左右,不知道该怎么解决。
IBM Informix Dynamic Server Version 10.00.FC8 -- On-Line (Prim) -- Up 652 days 18:56:02 -- 3000224 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached4430561 59351979 462683543591 100.00 841948 1433692 2436217 65.51
isamtot open start read write rewrite delete commit rollbk
312185890234 30533382819 43823133659 53137121481 471137 19373 204998 340690 391
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 8338554.24 3014148.09 34761 377280
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
16040 17 735693946468 0 0 1942 32619 7718425460
ixda-RA idx-RA da-RA RA-pgsused lchwaits
16552 1 2462 18998 375607411