Re: Fwd: KAIO con HPUX 11 [265]
Posted in 2004
Topics: Performance & Tuning, Storage & Space Management
Mensaje citado por "TBP@Nospam.Nothere.Co.Uk" <TBP@Nospam.Nothere.Co.Uk>:
> angruiz@coomevamail.com wrote:
> > ----- Mensaje reenviado de "ANGEL MARIA...." <angruiz@coomevamail.com>
> -----
> > Fecha: Mon, 9 Feb 2004 10:44:02 -0500 (EST)
> > De: "ANGEL MARIA...." <angruiz@coomevamail.com>
> > Responder-A: "ANGEL MARIA...." <angruiz@coomevamail.com>
> > Asunto: KAIO con HPUX 11 [265]
> > Para: "iiug-esp@iiug.org" <iiug-esp@iiug.org>
> >
> > Hola todos
> >
> > Tengo una duda respecto al funcionanmiento del KAIO en HPUX,
> >
> > mi version de informix es 9.30FC4 y tengo un servidor HPseries 390. solo
> tengo
> > un solo procesador
> >
> > Yo reviso y este es el resultado, aunque no he tenido problemas, si me han
>
> > dicho que puedo tener problemas de performance.
> >
> >
> > AIO I/O vps:
> > class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup
> errors
> > kio 0 i 100.2 1846095 1736241 109854 0 2082092 0.9
> 0
> > msc 0 i 0.8 15596 0 0 0 15550 1.0
> 0
> > aio 0 i 0.1 2751 957 426 0 2751 1.0
> 0
> > aio 1 i 0.0 35 12 22 0 35 1.0
> 0
> > aio 2 i 0.0 0 0 0 0 0 0.0
> 0
> > aio 3 i 0.0 0 0 0 0 0 0.0
> 0
> > aio 4 i 0.0 0 0 0 0 0 0.0
> 0
> > pio 0 i 0.0 0 0 0 0 0 0.0
> 0
> > lio 0 i 0.0 0 0 0 0 0 0.0
> 0
> >
> > Mi CPU casi siempre esta al 100%
> >
> > que hago sigo usuando KAIO o cuales son sus experiencias
> >
> > Gracias por sus recomendaciones,
> >
> >
> > ----- Fin del mensaje reenviado -----
> >
> >
> > Ingeniero:
> > Angel M. Ruiz Garzon
> > Fundacion Clinica Valle del Lili
> > Cra 98 # 18-49 Cali - Colombia
> > Tel 57 2 3317474 ext 3291.
> > Enviado a traves de CorreoWeb Calipso Comunicaciones S.A.
> >
> > sending to informix-list
> >
> >
> > sending to informix-list
> Hola Angel,
>
> Bueno, si solo tienes un solo CPU, probablemente AIO es mejor para tu,
> porque va tener mas de un process que puede hacer el I/O.
>
> Tienes un onstat -d, para ver quantos chunks tienes?
>
> Es mas facil probar un AIO VP cada chunk con trabajo hasta 10 or 20
> chunks, pero necesito ver un onstat -d, or mejor un onstat -g ioa.
>
> Mi Espanol es horible, perdona me ;)
>
> JJ
>
Holas muy bien.. tengo una duda yo puedo tener varios kio (KAIO),? con un solo
procesador esto no lo encuentro en los manuales?.
JJ me puedes escribir en English :-),
Thanks you.
Chunks
address chk/dbs offset size free bpages flags pathname
c00000000796a028 1 1 0 143360 139444 PO-
/dev/inf1/rootdbs
c00000000796a4d0 2 2 0 4096 36 PO-
/dev/inf1/phyv1
c00000000796a658 3 3 0 129024 86971 PO-
/dev/inf1/logv1
c00000000796a7e0 4 4 0 153600 153199 PO-
/dev/inf1/tempdbs2
c00000000796a968 5 5 0 524288 0 PO-
/dev/inf1/hipoc
c00000000796aaf0 6 6 0 4096 4043 PO-
/dev/inf1/phyv2
c00000000796ac78 7 7 0 77824 1771 PO-
/dev/inf1/logv2
c00000000796ae00 8 8 0 153600 137799 PO-
/dev/inf1/tempdbs1
c0000000086f4028 9 5 0 239616 0 PO-
/dev/inf1/hipoc_e1
c0000000086f41b0 10 5 0 524288 1 PO-
/dev/inf1/hipoc_e2
c0000000086f4338 11 5 0 1048575 3 PO-
/dev/inf1/hipoc_e3
c0000000086f44c0 12 5 0 524288 3 PO-
/dev/inf1/hipoc_e4
c0000000086f4648 13 5 0 614400 0 PO-
/dev/inf1/hipoc_e5
c0000000086f47d0 14 5 0 1048575 3 PO-
/dev/inf1/hipoc_e6
c0000000086f4958 15 5 0 524288 1 PO-
/dev/inf1/hipoc_e7
c0000000086f4ae0 16 5 0 1048575 1 PO-
/dev/inf1/hipoc_e8
c0000000086f4c68 17 5 0 518144 3 PO-
/dev/inf1/hipoc_e9
c0000000086f4df0 18 5 0 1048575 3 PO-
/dev/inf1/hipoc_e10
c0000000086f5028 19 5 0 1048575 1 PO-
/dev/inf1/hipoc_e11
c0000000086f51b0 20 5 0 1048575 0 PO-
/dev/inf1/hipoc_e12
c0000000086f5338 21 5 0 1048575 11 PO-
/dev/inf1/hipoc_e13
c0000000086f54c0 22 5 0 1048575 52 PO-
/dev/inf1/hipoc_e14
c0000000086f5648 23 5 0 1048575 989688 PO-
/dev/inf1/hipoc_e15
Omicron1:/apli/hip/rep#onstat -g ioa
Informix Dynamic Server Version 9.30.FC4 -- On-Line -- Up 3 days 14:03:59 -
- 350252 Kbytes
AIO global info:
6 aio classes
26 open files
64 max global files
AIO I/O queues:
q name/id len maxlen totalops dskread dskwrite dskcopy
kio 0 0 33 2361464 2274009 87455 0
adt 0 0 0 0 0 0 0
msc 0 0 1 12105 0 0 0
aio 0 0 1 1908 357 436 0
pio 0 0 0 0 0 0 0
lio 0 0 0 0 0 0 0
gfd 3 0 0 0 0 0 0
gfd 4 0 0 0 0 0 0
gfd 5 0 0 0 0 0 0
gfd 6 0 0 0 0 0 0
gfd 7 0 0 0 0 0 0
gfd 8 0 0 0 0 0 0
gfd 9 0 0 0 0 0 0
gfd 10 0 0 0 0 0 0
gfd 11 0 0 0 0 0 0
gfd 12 0 0 0 0 0 0
gfd 13 0 0 0 0 0 0
gfd 14 0 0 0 0 0 0
gfd 15 0 0 0 0 0 0
gfd 16 0 0 0 0 0 0
gfd 17 0 0 0 0 0 0
gfd 18 0 0 0 0 0 0
gfd 19 0 0 0 0 0 0
gfd 20 0 0 0 0 0 0
gfd 21 0 0 0 0 0 0
gfd 22 0 0 0 0 0 0
gfd 23 0 0 0 0 0 0
gfd 24 0 0 0 0 0 0
gfd 25 0 0 0 0 0 0
AIO I/O vps:
class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
kio 0 i 87.8 1308003 1225949 82054 0 1933972 0.7 0
msc 0 i 0.8 12105
angruiz@coomevamail.com wrote:
> Mensaje citado por "TBP@Nospam.Nothere.Co.Uk" <TBP@Nospam.Nothere.Co.Uk>:
>
>
snip
>>
>
>
> Holas muy bien.. tengo una duda yo puedo tener varios kio (KAIO),? con un solo
> procesador esto no lo encuentro en los manuales?.
>
> JJ me puedes escribir en English :-),
>
> Thanks you.
>
>
> Chunks
> address chk/dbs offset size free bpages flags pathname
> c00000000796a028 1 1 0 143360 139444 PO- /dev/inf1/rootdbs
> c00000000796a4d0 2 2 0 4096 36 PO- /dev/inf1/phyv1
> c00000000796a658 3 3 0 129024 86971 PO- /dev/inf1/logv1
> c00000000796a7e0 4 4 0 153600 153199 PO- /dev/inf1/tempdbs2
> c00000000796a968 5 5 0 524288 0 PO- /dev/inf1/hipoc
> c00000000796aaf0 6 6 0 4096 4043 PO- /dev/inf1/phyv2
> c00000000796ac78 7 7 0 77824 1771 PO- /dev/inf1/logv2
> c00000000796ae00 8 8 0 153600 137799 PO- /dev/inf1/tempdbs1
> c0000000086f4028 9 5 0 239616 0 PO- /dev/inf1/hipoc_e1
> c0000000086f41b0 10 5 0 524288 1 PO- /dev/inf1/hipoc_e2
> c0000000086f4338 11 5 0 1048575 3 PO- /dev/inf1/hipoc_e3
> c0000000086f44c0 12 5 0 524288 3 PO- /dev/inf1/hipoc_e4
> c0000000086f4648 13 5 0 614400 0 PO- /dev/inf1/hipoc_e5
> c0000000086f47d0 14 5 0 1048575 3 PO- /dev/inf1/hipoc_e6
> c0000000086f4958 15 5 0 524288 1 PO- /dev/inf1/hipoc_e7
> c0000000086f4ae0 16 5 0 1048575 1 PO- /dev/inf1/hipoc_e8
> c0000000086f4c68 17 5 0 518144 3 PO- /dev/inf1/hipoc_e9
> c0000000086f4df0 18 5 0 1048575 3 PO- /dev/inf1/hipoc_e10
> c0000000086f5028 19 5 0 1048575 1 PO- /dev/inf1/hipoc_e11
> c0000000086f51b0 20 5 0 1048575 0 PO- /dev/inf1/hipoc_e12
> c0000000086f5338 21 5 0 1048575 11 PO- /dev/inf1/hipoc_e13
> c0000000086f54c0 22 5 0 1048575 52 PO- /dev/inf1/hipoc_e14
> c0000000086f5648 23 5 0 1048575 989688 PO- /dev/inf1/hipoc_e15
>
> Omicron1:/apli/hip/rep#onstat -g ioa
>
> Informix Dynamic Server Version 9.30.FC4 -- On-Line -- Up 3 days 14:03:59 -
> - 350252 Kbytes
>
> AIO global info:
> 6 aio classes
> 26 open files
> 64 max global files
>
> AIO I/O queues:
> q name/id len maxlen totalops dskread dskwrite dskcopy
> kio 0 0 33 2361464 2274009 87455 0
> adt 0 0 0 0 0 0 0
> msc 0 0 1 12105 0 0 0
> aio 0 0 1 1908 357 436 0
> pio 0 0 0 0 0 0 0
> lio 0 0 0 0 0 0 0
> gfd 3 0 0 0 0 0 0
> gfd 4 0 0 0 0 0 0
> gfd 5 0 0 0 0 0 0
> gfd 6 0 0 0 0 0 0
> gfd 7 0 0 0 0 0 0
> gfd 8 0 0 0 0 0 0
> gfd 9 0 0 0 0 0 0
> gfd 10 0 0 0 0 0 0
> gfd 11 0 0 0 0 0 0
> gfd 12 0 0 0 0 0 0
> gfd 13 0 0 0 0 0 0
> gfd 14 0 0 0 0 0 0
> gfd 15 0 0 0 0 0 0
> gfd 16 0 0 0 0 0 0
> gfd 17 0 0 0 0 0 0
> gfd 18 0 0 0 0 0 0
> gfd 19 0 0 0 0 0 0
> gfd 20 0 0 0 0 0 0
> gfd 21 0 0 0 0 0 0
> gfd 22 0 0 0 0 0 0
> gfd 23 0 0 0 0 0 0
> gfd 24 0 0 0 0 0 0
> gfd 25 0 0 0 0 0 0
>
> AIO I/O vps:
> class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
> kio 0 i 87.8 1308003 1225949 82054 0 1933972 0.7 0
> msc 0 i 0.8 12105 0 0 0 12040 1.0 0
> aio 0 i 0.5 7585 3204 3270 0 7586 1.0 0
> aio 1 i 0.0 203 93 106 0 202 1.0 0
> aio 2 i 0.0 0 0 0 0 0 0.0 0
> aio 3 i 0.0 0 0 0 0 0 0.0 0
> aio 4 i 0.0 0 0 0 0 0 0.0 0
> pio 0 i 0.0 0 0 0 0 0 0.0 0
> lio 0 i 0.0 0 0 0 0 0 0.0 0
>
> AIO global files:
> gfd pathname totalops dskread dskwrite io/s
> 3 rootdbs 1339 892 447 0.1
> 4 /dev/inf1/phyv1 1524 4 1520 0.1
> 5 /dev/inf1/logv1 4 4 0 0.0
> 6 tempdbs2 2781 747 2034 0.2
> 7 /dev/inf1/hipoc 143730 142290 1440 9.6
> 8 /dev/inf1/phyv2 3 3 0 0.0
> 9 /dev/inf1/logv2 4001 1811 2190 0.3
> 10 tempdbs1 37970 16597 21373 2.5
> 11 hipoc_e1 20709 19412 1297 1.4
> 12 hipoc_e2 36507 35936 571 2.5
> 13 hipoc_e3 93262 91097 2165 6.3
> 14 hipoc_e4 60937 60256 681 4.1
> 15 hipoc_e5 68626 68215 411 4.6
> 16 hipoc_e6 112492 106905 5587 7.6
> 17 hipoc_e7 13106 10991 2115 0.9
> 18 hipoc_e8 4626 3651 975 0.3
> 19 hipoc_e9 4697 3988 709 0.3
> 20 hipoc_e10 10709 10242 467 0.7
> 21 hipoc_e11 38967 36322 2645 2.6
> 22 hipoc_e12 229689 226946 2743 15.4
> 23 hipoc_e13 244636 237309 7327 16.4
> 24 hipoc_e14 157274 141026 16248 10.6
> 25 hipoc_e15 20414 11305 9109 1.4
>
> AIO big buffer usage summary:
> class reads writes
> pages ops pgs/op holes hl-ops hls/op pages ops pgs/op
> kio 5635858 1225949 4.60 535822 77400 6.92 282427 82054 3.44
> adt 0 0 0.00 0 0 0.00 0 0 0.00
> msc 0 0 0.00 0 0 0.00 0 0 0.00
> aio 27168 2940 9.24 0 0 0.00 27168 2940 9.24
> pio 0 0 0.00 0 0 0.00 0
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape