Re: The stats of "aio" VP on SingleProc machine in KAIO mode
In article <KSN_3.11459$K%.256066@news.tpnet.pl>, Piotr Wróblewski
<ptrwrb@kki.net.pl> writes
>I am running IDS 7.30.UC2 server on HP-UX10.20.
>My statistics for G50 says, that millions of disk writes go through 'aio', but
TRUE.
>when we compare 'onstat -g iov' with 'onstat -g iof', the sum of disk writes
>(-g iof) is nearly equal the count of 'kio' disk writes (-g iov),
>and similarly for disk reads.
>
TRUE, all I/O to chunks is going via KAIO, BUT...
FILESYSTEMS WRITES GO THROUGH AIO VPs...
>AIO I/O vps:
>class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
> aio 0 i 42.0 192905 1 192887 0 26795 7.2 0
> aio 1 i 29.9 137227 3 137215 0 35779 3.8 0
> aio 2 i 23.9 109471 5 109465 0 38511 2.8 0
> aio 3 s 23.8 109121 0 109120 0 38404 2.8 0
> aio 4 s 32.4 148528 0 148527 0 38929 3.8 0
> aio 5 s 63.0 288853 0 288852 0 39883 7.2 0
> aio 6 s 86.5 396957 0 396956 0 42903 9.3 0
> aio 7 s 105.2 482577 0 482576 0 47344 10.2 0
Lots of I/O, all writes.. (Aside, when using temp dbspaces I've seen
mostly writes)...there's more...
>
>
>Informix Dynamic Server Version 7.30.UC2 -- On-Line -- Up 01:16:29 -- 40864 Kb
>ytes
>
>AIO global files:
>gfd pathname totalops dskread dskwrite io/s
> 3 rootdbs.0 133 72 61 0.0
> 4 rootdbs.1 94037 90619 3418 20.5
> 5 temp1dbs.0 970 577 393 0.2
> 6 temp2dbs.0 1220 726 494 0.3
OooH! Little I/O to temp dbspaces!!!
>
> ^^^^^^^^^^^^^^^^^^^^^^^^^ sums of these equal to kio
> ^^^^^^^^^^^^^^^^^^^^^^^^^ statistics above
>
Again ALL I/O to chunk via KAIO.
>VP Scheduler Statistics:
> vp pid class semops busy waits spins/wait
> 1 11471 cpu 15 0 0
> 2 11472 adm 0 0 0
> 3 11473 lio 2 0 0
> 4 11474 pio 2 0 0
> 5 11475 aio 29067 0 0
> 6 11476 msc 497 0 0
> 7 11477 aio 38518 0 0
> 8 11478 aio 41490 0 0
> 9 11479 aio 41584 0 0
> 10 11480 aio 42226 0 0
> 11 11481 aio 43378 0 0
> 12 11482 aio 46961 0 0
> 13 11483 aio 51939 0 0
> 14 11484 soc 2 0 0
>
Lots of AIO..
>AIO I/O queues:
>q name/id len maxlen totalops dskread dskwrite dskcopy
> kio 0 0 0 0 0 0 0
> kio 1 0 34 300828 282098 18730 0
Some KAIO reads
> kio 2 0 0 0 0 0 0
> adt 0 0 0 0 0 0 0
> msc 0 0 1 509 0 0 0
> aio 0 0 7 2084846 8 2084806 0
Lots of AIO writes (probably not reads since temp tables cached
in buffers, you have 10000 BUFFERS!).
> pio 0 0 0 0 0 0 0
> lio 0 0 0 0 0 0 0
..No logging
>
># DBSPACETEMP:
># Dynamic Server equivalent of DBTEMP for SE. This is the list of dbspaces
># that the Dynamic Server SQL Engine will use to create temp tables etc.
># If specified it must be a colon separated list of dbspaces that exist
># when the Dynamic Server system is brought online. If not specified, or if
># all dbspaces specified are invalid, various ad hoc queries will create
># temporary files in /tmp instead.
>
>DBSPACETEMP temp1dbs:temp2dbs # Default temp dbspaces
>
Tada! Shouldn't this be temp1dbs,temp2dbs
^
??
--
David Williams