最先要看的,我认为是onstat -p看看有没有死锁,是我的一个习惯。IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 03:56:40 -- 15360 KbytesProfiledskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached939 &nb...
显示全部最先要看的,我认为是onstat -p
看看有没有死锁,是我的一个习惯。
IBM Informix Dynamic Server Version 10.00.UC1 -- On-Line -- Up 03:56:40 -- 15360 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
939 943 143905 99.35 3925 10816 46919 91.63
isamtot open start read write rewrite delete commit rollbk
100055 15851 16112 24632 13343 1342 1392 905 0
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 12.00 2.69 9 101
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
8 0 26894 0 0 1 1247 478
ixda-RA idx-RA da-RA RA-pgsused lchwaits
5 0 10 15 23
收起