informix连接时不时会停顿
AS4U8 informix 9.21UC2在本地通过dbaccess执行sql语句时，时不时会出现1-9s的情况（正常情况下，都低于1s）
通过strace 跟踪，结果如下：
# strace dbaccess register test.sql
socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 4
bind(4, {sa_family=AF_INET, sin_port=htons(0), sin_addr=inet_addr("0.0.0.0")}, 16) = 0
fcntl64(4, F_GETFL) = 0x2 (flags O_RDWR)
fcntl64(4, F_SETFL, O_RDWR|O_NONBLOCK)= 0
connect(4, {sa_family=AF_INET, sin_port=htons(666), sin_addr=inet_addr("ip")}, 16) = -1 EINPROGRESS (Operation now in progress)
time(NULL) = 1312873144
select(5, NULL, , NULL, {80, 0}) = 1 (out , left {80, 0})
getpeername(4, {sa_family=AF_INET, sin_port=htons(666), sin_addr=inet_addr("ip")}, ) = 0
fcntl64(4, F_SETFL, O_RDWR|O_SYNC) = 0
setsockopt(4, SOL_SOCKET, SO_REUSEADDR, , 4) = 0
setsockopt(4, SOL_SOCKET, SO_KEEPALIVE, , 4) = 0
setsockopt(4, SOL_SOCKET, SO_LINGER, {onoff=1, linger=60}, 8) = 0
setsockopt(4, SOL_TCP, TCP_NODELAY, , 4) = 0
time(NULL) = 1312873144
select(5, NULL, , , {80, 0}) = 1 (out , left {80, 0})
send(4, "sqAXoBPQAAsqlexec informix9.24"..., 382, 0) = 382
recv(4, <--会停顿在此处,不知问题出在哪里？ $ onstat -g iof
Informix Dynamic Server 2000 Version 9.21.UC2 -- On-Line -- Up 16:53:49 -- 2397416 Kbytes
AIO global files:
gfd pathname totalopsdskread dskwriteio/s
3 informix_root 97461 90443 7018 1.6
4 informix_log 112522 7940 104582 1.8
5 informix_phy 2594 7 2587 0.0
6 informix_temp 491276 274524 216752 8.1
7 informix_data0 1252928 907016 34591220.6
8 informix_idx0 957178 910082 4709615.7
9 informix_data1 866776 735685 13109114.2
10 informix_data2 1065055 820378 24467717.5
11 informix_data3 436925 417367 19558 7.2
12 informix_data4 1245830 927625 31820520.5
13 informix_data5 162041 155465 6576 2.7
14 informix_data6 931537 730055 20148215.3
15 informix_data7 868998 687189 18180914.3
16 informix_data8 695517 637568 5794911.4
17 informix_data9 480852 459545 21307 7.9
18 informix_idx1 11838811048402 13547919.5
19 informix_idx2 10976401045980 5166018.0
20 informix_data10 397324 339458 57866 6.5
21 informix_data11 30163522591392 42496049.6
22 informix_data12 342138 291548 50590 5.6
23 informix_data13 1103058 726663 37639518.1
24 informix_data14 883553 844325 3922814.5
25 informix_data15 667392 492236 17515611.0
26 informix_data16 885375 645174 24020114.6
27 informix_data17 14756961427120 4857624.3
28 informix_data18 1428501 987666 44083523.5
29 informix_data19 15895491140557 44899226.1
30 informix_data20 568449 521623 46826 9.3
31 informix_data21 203640 173440 30200 3.3
32 informix_data22 209377 170768 38609 3.4
33 informix_data23 346257 316726 29531 5.7
34 informix_data24 374833 357259 17574 6.2
35 informix_data25 403160 382284 20876 6.6
36 informix_data26 188556 186447 2109 3.1
37 informix_root1 58155 54191 3964 1.0
38 informix_data27 158999 158999 0 2.6
39 informix_data28 158996 158996 0 2.6
40 informix_data29 158995 158995 0 2.6
41 informix_idx3 1089424 968569 12085517.9
42 informix_idx4 364004 313805 50199 6.0
43 informix_idx5 3 3 0 0.0
$ onstat -g ioq
Informix Dynamic Server 2000 Version 9.21.UC2 -- On-Line -- Up 16:53:54 -- 2397416 Kbytes
AIO I/O queues:
q name/id len maxlen totalopsdskread dskwritedskcopy
adt 0 0 0 0 0 0 0
msc 0 0 1 718312 0 0 0
aio 0 0 80 142 7 0 0
pio 0 0 1 2586 0 2586 0
lio 0 0 1 104606 0 104606 0
gfd 3 0 150 180304 94456 85848 0
gfd 4 0 3 7943 7940 3 0
gfd 5 0 3 10 7 3 0
gfd 6 0 152 532536 274631 257905 0
gfd 7 0 15028347022329485 505217 0
gfd 8 0 150 970225 911458 58767 0
gfd 9 0 15020323231487929 544394 0
gfd10 0 15023812691746145 635124 0
gfd11 0 15019110021814606 96396 0
gfd12 0 15019404151493031 447384 0
gfd13 0 150 636784 574532 62252 0
gfd14 0 15019460381379178 566860 0
gfd15 0 15018484581554636 293822 0
gfd16 0 15014112261154354 256872 0
gfd17 0 15013713751166879 204496 0
gfd18 0 15112341441054317 179827 0
gfd19 0 15011070421046719 60323 0
gfd20 0 15011806651049294 131371 0
gfd21 0 15052683174346733 921584 0
gfd22 0 15014454011344905 100496 0
gfd23 0 15020151141538328 476786 0
gfd24 0 15022643691925296 339073 0
gfd25 0 15017732471534599 238648 0
gfd26 0 15017516271408471 343156 0
gfd27 0 15046393894277821 361568 0
gfd28 0 15026007801766375 834405 0
gfd29 0 15029855152008779 976736 0
gfd30 0 15013108011140688 170113 0
gfd31 0 21 919306 889086 30220 0
gfd32 0 150 840247 801385 38862 0
gfd33 0 15012121981140699 71499 0
gfd34 0 1501200412 976903 223509 0
gfd35 0 1501052523 792130 260393 0
gfd36 0 15010639041032421 31483 0
gfd37 0 150 109048 57614 51434 0
gfd38 0 810335601033560 0 0
gfd39 0 810335581033558 0 0
gfd40 0 810335561033556 0 0
gfd41 0 1501132258 969006 163252 0
gfd42 0 150 409717 314106 95611 0
gfd43 0 1 3 3 0 0
这样的IO表现，不知是否存在严重的性能问题？ 问题已经解决
页:
[1]