Question about onstat -g ioq?
Posted in 2011
Varaporn Veravithaya migrated IDS 9.40.FC7 from Solaris 9 to 10 on raw devices and found it slower, with 25 CPU VPs and 16 AIO VPs. Obnoxio the Clown asked whether hardware changed. Art Kagel said there were far too many AIO VPs, only 3-4 are needed, and idle ones in onstat -g iov (io/wkup 0.0) can go. Alexandre Marini asked about update statistics after the import. No confirmed outcome.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Topics: Platform-Specific Issues
Hello ,
I have some problem about IDS9.40FC7 on solaris9 and solaris10.
We have just migrate all database from IDS9.40Fc7 on solaris9 to solaris10.
It work OK. All DB is RAW-DEVICE.
I have also tuned some parameter as follow
NUMCPUVP from 16 to 25
NETTYPE TCPIP from 16*300 to 25*300
other is the same. Problem occur is it work on solaris10 slower than solaris9.
I also keep output from ioq command and found the difference.
in "aio" .
Question :
Any problem about I/O system ?
what should I do next? tunning AIO ? (now NUMAIOVPs =16)
Here are output : on Solaris9
AIO I/O queues:
q name/id len maxlen totalops dskread dskwrite dskcopy
sqli_dbg 0 0 0 0 0 0 0
kio 0 0 35 54725169 51695967 3029202 0
kio 1 0 33 54549058 51634426 2914632 0
kio 2 0 35 42543355 39969828 2573527 0
kio 3 0 35 52637742 49880635 2757107 0
kio 4 0 35 45853601 43314115 2539486 0
kio 5 0 35 33381826 31184329 2197497 0
kio 6 0 35 37633933 35281852 2352081 0
kio 7 0 35 30361438 28241291 2120147 0
kio 8 0 35 23182191 21552832 1629359 0
kio 9 0 37 19696708 18469797 1226911 0
kio 10 0 35 27120918 25224541 1896377 0
kio 11 0 35 16042761 15134660 908101 0
kio 12 0 35 13796483 13020932 775551 0
kio 13 0 35 9837110 9302937 534173 0
kio 14 0 35 8803804 8315078 488726 0
kio 15 0 35 8285299 7789820 495479 0
kio 16 0 35 12168988 11527099 641889 0
kio 17 0 35 7471780 6999295 472485 0
adt 0 0 0 0 0 0 0
msc 0 0 5 2797073 0 0 0
aio 0 0 15 395 66 10 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
gfd 26 0 0 0 0 0 0
gfd 27 0 0 0 0 0 0
gfd 28 0 0 0 0 0 0
gfd 29 0 0 0 0 0 0
gfd 30 0 0 0 0 0 0
gfd 31 0 0 0 0 0 0
gfd 32 0 0 0 0 0 0
gfd 33 0 0 0 0 0 0
gfd 34 0 0 0 0 0 0
gfd 35 0 0 0 0 0 0
gfd 36 0 0 0 0 0 0
gfd 37 0 0 0 0 0 0
gfd 38 0 0 0 0 0 0
gfd 39 0 0 0 0 0 0
gfd 40 0 0 0 0 0 0
gfd 41 0 0 0 0 0 0
gfd 42 0 0 0 0 0 0
gfd 43 0 0 0 0 0 0
gfd 44 0 0 0 0 0 0
gfd 45 0 0 0 0 0 0
gfd 46 0 0 0 0 0 0
gfd 47 0 0 0 0 0 0
gfd 48 0 0 0 0 0 0
gfd 49 0 0 0 0 0 0
gfd 50 0 0 0 0 0 0
gfd 51 0 0 0 0 0 0
gfd 52 0 0 0 0 0 0
gfd 53 0 0 0 0 0 0
gfd 54 0 0 0 0 0 0
gfd 55 0 0 0 0 0 0
gfd 56 0 0 0 0 0 0
gfd 57 0 0 0 0 0 0
gfd 58 0 0 0 0 0 0
gfd 59 0 0 0 0 0 0
gfd 60 0 0 0 0 0 0
gfd 61 0 0 0 0 0 0
gfd 62 0 0 0 0 0 0
gfd 63 0 0 0 0 0 0
gfd 64 0 0 0 0 0 0
gfd 65 0 0 0 0 0 0
gfd 66 0 0 0 0 0 0
gfd 67 0 0 0 0 0 0
gfd 68 0 0 0 0 0 0
gfd 69 0 0 0 0 0 0
gfd 70 0 0 0 0 0 0
gfd 71 0 0 0 0 0 0
gfd 72 0 0 0 0 0 0
gfd 73 0 0 0 0 0 0
gfd 74 0 0 0 0 0 0
gfd 75 0 0 0 0 0 0
gfd 76 0 0 0 0 0 0
gfd 77 0 0 0 0 0 0
gfd 78 0 0 0 0 0 0
gfd 79 0 0 0 0 0 0
gfd 80 0 0 0 0 0 0
gfd 81 0 0 0 0 0 0
gfd 82 0 0 0 0 0 0
gfd 83 0 0 0 0 0 0
gfd 84 0 0 0 0 0 0
gfd 85 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 s 445.3 40994852 37992802 3002050 0 73323685 0.6 0
kio 1 i 476.8 43889661 40998778 2890883 0 78363138 0.6 0
kio 2 b 357.6 32914615 30367574 2547041 0 57339723 0.6 0
kio 3 s 454.9 41872354 39138233 2734121 0 74379364 0.6 0
kio 4 s 389.6 35865347 33343136 2522211 0 63070115 0.6 0
kio 5 s 272.1 25047597 22865578 2182019 0 42937308 0.6 0
kio 6 i 311.4 28669797 26337738 2332059 0 49572626 0.6 0
kio 7 i 244.9 22541415 20437858 2103557 0 38243115 0.6 0
kio 8 i 179.6 16529812 14917943 1611869 0 27498577 0.6 0
kio 9 s 149.2 13733359 12518652 1214707 0 22740635 0.6 0
kio 10 i 214.7 19765263 17879848 1885415 0 33238267 0.6 0
kio 11 i 114.8 10565644 9667598 898046 0 17171349 0.6 0
kio 12 i 97.5 8971772 8212605 759167 0 14509994 0.6 0
kio 13 i 67.8 6241082 5717806 523276 0 9906288 0.6 0
kio 14 s 61.2 5631644 5150876 480768 0 8894041 0.6 0
kio 15 i 59.3 5462267 4980768 481499 0 8629154 0.6 0
kio 16 s 86.0 7914771 7282480 632291 0 12776659 0.6 0
kio 17 i 53.5 4926551 4462110 464441 0 7676771 0.6 0
msc 0 s 30.4 2797084 0 0 0 2750345 1.0 0
aio 0 i 3.0 279826 137836 141702 0 269210 1.0 0
aio 1 i 1.1 98121 50475 47630 0 103204 1.0 0
aio 2 i 0.2 21923 11308 10612 0 25648 0.9 0
aio 3 i 0.0 3226 1651 1574 0 4844 0.7 0
aio 4 i 0.0 25 8 15 0 207 0.1 0
aio 5 i 0.0 5 1 2 0 11 0.5 0
aio 6 i 0.0 2 0 0 0 3 0.7 0
aio 7 i 0.0 2 0 0 0 1 2.0 0
aio 8 i 0.0 2 0 0 0 1 2.0 0
aio 9 i 0.0 1 0 0 0 1 1.0 0
aio 10 i 0.0 0 0 0 0 1 0.0 0
aio 11 i 0.0 0 0 0 0 1 0.0 0
aio 12 i 0.0 0 0 0 0 1 0.0 0
aio 13 i 0.0 0 0 0 0 1 0.0 0
aio 14 i 0.0 0 0 0 0 1 0.0 0
aio 15 i 0.0 0 0 0 0 1 0.0 0
pio 0 i 0.0 0 0 0 0 1 0.0 0
lio 0 i 0.0 0 0 0 0 1 0.0 0
and Output on Solaris10 :
AIO I/O queues:
q name/id len maxlen totalops dskread dskwrite dskcopy
sqli_dbg 0 0 0 0 0 0 0
kio 0 0 33 26979429 26709571 269858 0
kio 1 0 35 35295087 34913732 381355 0
kio 2 0 34 22680703 22418601 262102 0
kio 3 0 33 28207965 27886300 321665 0
kio 4 0 45 18770661 18519212 251449 0
kio 5 0 35 6546432 6374127 172305 0
kio 6 0 33 15709457 15478911 230546 0
kio 7 0 33 4807920 4662439 145481 0
kio 8 0 33 8182706 7970828 211878 0
kio 9 0 34 10184606 9966479 218127 0
kio 10 0 34 5615462 5454854 160608 0
kio 11 0 34 8276324 8079227 197097 0
kio 12 0 34 7829620 7658351 171269 0
kio 13 0 33 5538105 5397366 140739 0
kio 14 0 33 5214106 5067384 146722 0
kio 15 0 33 4356281 4220383 135898 0
kio 16 0 33 4087949 3958888 129061 0
kio 17 0 35 3785493 3658046 127447 0
kio 18 0 34 2800605 2699416 101189 0
kio 19 0 34 3264195 3148095 116100 0
kio 20 0 33 2105706 2019947 85759 0
kio 21 0 34 3118483 3009526 108957 0
kio 22 0 37 2544910 2451226 93684 0
kio 23 0 33 2391409 2302558 88851 0
kio 24 0 33 2238788 2152451 86337 0
adt 0 0 0 0 0 0 0
msc 0 0 53 1525384 0 0 0
aio 0 0 85 273219 66 68253 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
gfd 26 0 0 0 0 0 0
gfd 27 0 0 0 0 0 0
gfd 28 0 0 0 0 0 0
gfd 29 0 0 0 0 0 0
gfd 30 0 0 0 0 0 0
gfd 31 0 0 0 0 0 0
gfd 32 0 0 0 0 0 0
gfd 33 0 0 0 0 0 0
gfd 34 0 0 0 0 0 0
gfd 35 0 0 0 0 0 0
gfd 36 0 0 0 0 0 0
gfd 37 0 0 0 0 0 0
gfd 38 0 0 0 0 0 0
gfd 39 0 0 0 0 0 0
gfd 40 0 0 0 0 0 0
gfd 41 0 0 0 0 0 0
gfd 42 0 0 0 0 0 0
gfd 43 0 0 0 0 0
On 13/07/2011 18:51, VARAPORN VERAVITHAYA wrote: > Hello , > > I have some problem about IDS9.40FC7 on solaris9 and solaris10. > We have just migrate all database from IDS9.40Fc7 on solaris9 to solaris10. > It work OK. All DB is RAW-DEVICE. > I have also tuned some parameter as follow Did you change hardware at all, or did you just upgrade the operating system? -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish.
You have way too many AIO VPs. You probably need only 3 or 4 if all of your
chunks are raw. In the onstat -g iov report look at the io/wkup column and
drop any aio VPs that have a value of 0.0. If you don't have at least one
aio vp with io/wkup that is less than 1.0 you need more of them. In your
case four aio vps have io/wkup that are non-zero, all the rest of the vps
(12) are unused and taking up resources.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Wed, Jul 13, 2011 at 1:51 PM, VARAPORN VERAVITHAYA
<varaporn.v@cdg.co.th>wrote:
> Hello ,
>
> I have some problem about IDS9.40FC7 on solaris9 and solaris10.
> We have just migrate all database from IDS9.40Fc7 on solaris9 to solaris10.
> It work OK. All DB is RAW-DEVICE.
> I have also tuned some parameter as follow
>
> NUMCPUVP from 16 to 25
> NETTYPE TCPIP from 16*300 to 25*300>
> other is the same. Problem occur is it work on solaris10 slower than
> solaris9.
> I also keep output from ioq command and found the difference.
> in "aio" .
>
> Question :
> Any problem about I/O system ?
> what should I do next? tunning AIO ? (now NUMAIOVPs =16)
>
> Here are output : on Solaris9
>
> AIO I/O queues:
> q name/id len maxlen totalops dskread dskwrite dskcopy
> sqli_dbg 0 0 0 0 0 0 0
> kio 0 0 35 54725169 51695967 3029202 0
> kio 1 0 33 54549058 51634426 2914632 0
> kio 2 0 35 42543355 39969828 2573527 0
> kio 3 0 35 52637742 49880635 2757107 0
> kio 4 0 35 45853601 43314115 2539486 0
> kio 5 0 35 33381826 31184329 2197497 0
> kio 6 0 35 37633933 35281852 2352081 0
> kio 7 0 35 30361438 28241291 2120147 0
> kio 8 0 35 23182191 21552832 1629359 0
> kio 9 0 37 19696708 18469797 1226911 0
> kio 10 0 35 27120918 25224541 1896377 0
> kio 11 0 35 16042761 15134660 908101 0
> kio 12 0 35 13796483 13020932 775551 0
> kio 13 0 35 9837110 9302937 534173 0
> kio 14 0 35 8803804 8315078 488726 0
> kio 15 0 35 8285299 7789820 495479 0
> kio 16 0 35 12168988 11527099 641889 0
> kio 17 0 35 7471780 6999295 472485 0
> adt 0 0 0 0 0 0 0
> msc 0 0 5 2797073 0 0 0
> aio 0 0 15 395 66 10 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
> gfd 26 0 0 0 0 0 0
> gfd 27 0 0 0 0 0 0
> gfd 28 0 0 0 0 0 0
> gfd 29 0 0 0 0 0 0
> gfd 30 0 0 0 0 0 0
> gfd 31 0 0 0 0 0 0
> gfd 32 0 0 0 0 0 0
> gfd 33 0 0 0 0 0 0
> gfd 34 0 0 0 0 0 0
> gfd 35 0 0 0 0 0 0
> gfd 36 0 0 0 0 0 0
> gfd 37 0 0 0 0 0 0
> gfd 38 0 0 0 0 0 0
> gfd 39 0 0 0 0 0 0
> gfd 40 0 0 0 0 0 0
> gfd 41 0 0 0 0 0 0
> gfd 42 0 0 0 0 0 0
> gfd 43 0 0 0 0 0 0
> gfd 44 0 0 0 0 0 0
> gfd 45 0 0 0 0 0 0
> gfd 46 0 0 0 0 0 0
> gfd 47 0 0 0 0 0 0
> gfd 48 0 0 0 0 0 0
> gfd 49 0 0 0 0 0 0
> gfd 50 0 0 0 0 0 0
> gfd 51 0 0 0 0 0 0
> gfd 52 0 0 0 0 0 0
> gfd 53 0 0 0 0 0 0
> gfd 54 0 0 0 0 0 0
> gfd 55 0 0 0 0 0 0
> gfd 56 0 0 0 0 0 0
> gfd 57 0 0 0 0 0 0
> gfd 58 0 0 0 0 0 0
> gfd 59 0 0 0 0 0 0
> gfd 60 0 0 0 0 0 0
> gfd 61 0 0 0 0 0 0
> gfd 62 0 0 0 0 0 0
> gfd 63 0 0 0 0 0 0
> gfd 64 0 0 0 0 0 0
> gfd 65 0 0 0 0 0 0
> gfd 66 0 0 0 0 0 0
> gfd 67 0 0 0 0 0 0
> gfd 68 0 0 0 0 0 0
> gfd 69 0 0 0 0 0 0
> gfd 70 0 0 0 0 0 0
> gfd 71 0 0 0 0 0 0
> gfd 72 0 0 0 0 0 0
> gfd 73 0 0 0 0 0 0
> gfd 74 0 0 0 0 0 0
> gfd 75 0 0 0 0 0 0
> gfd 76 0 0 0 0 0 0
> gfd 77 0 0 0 0 0 0
> gfd 78 0 0 0 0 0 0
> gfd 79 0 0 0 0 0 0
> gfd 80 0 0 0 0 0 0
> gfd 81 0 0 0 0 0 0
> gfd 82 0 0 0 0 0 0
> gfd 83 0 0 0 0 0 0
> gfd 84 0 0 0 0 0 0
> gfd 85 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 s 445.3 40994852 37992802 3002050 0 73323685 0.6 0
> kio 1 i 476.8 43889661 40998778 2890883 0 78363138 0.6 0
> kio 2 b 357.6 32914615 30367574 2547041 0 57339723 0.6 0
> kio 3 s 454.9 41872354 39138233 2734121 0 74379364 0.6 0
> kio 4 s 389.6 35865347 33343136 2522211 0 63070115 0.6 0
> kio 5 s 272.1 25047597 22865578 2182019 0 42937308 0.6 0
> kio 6 i 311.4 28669797 26337738 2332059 0 49572626 0.6 0
> kio 7 i 244.9 22541415 20437858 2103557 0 38243115 0.6 0
> kio 8 i 179.6 16529812 14917943 1611869 0 27498577 0.6 0
> kio 9 s 149.2 13733359 12518652 1214707 0 22740635 0.6 0
> kio 10 i 214.7 19765263 17879848 1885415 0 33238267 0.6 0
> kio 11 i 114.8 10565644 9667598 898046 0 17171349 0.6 0
> kio 12 i 97.5 8971772 8212605 759167 0 14509994 0.6 0
> kio 13 i 67.8 6241082 5717806 523276 0 9906288 0.6 0
> kio 14 s 61.2 5631644 5150876 480768 0 8894041 0.6 0
> kio 15 i 59.3 5462267 4980768 481499 0 8629154 0.6 0
> kio 16 s 86.0 7914771 7282480 632291 0 12776659 0.6 0
> kio 17 i 53.5 4926551 4462110 464441 0 7676771 0.6 0
> msc 0 s 30.4 2797084 0 0 0 2750345 1.0 0
> aio 0 i 3.0 279826 137836 141702 0 269210 1.0 0
> aio 1 i 1.1 98121 50475 47630 0 103204 1.0 0
> aio 2 i 0.2 21923 11308 10612 0 25648 0.9 0
> aio 3 i 0.0 3226 1651 1574 0 4844 0.7 0
> aio 4 i 0.0 25 8 15 0 207 0.1 0
> aio 5 i 0.0 5 1 2 0 11 0.5 0
> aio 6 i 0.0 2 0 0 0 3 0.7 0
> aio 7 i 0.0 2 0 0 0 1 2.0 0
> aio 8 i 0.0 2 0 0 0 1 2.0 0
> aio 9 i 0.0 1 0 0 0 1 1.0 0
> aio 10 i 0.0 0 0 0 0 1 0.0 0
> aio 11 i 0.0 0 0 0 0 1 0.0 0
> aio 12 i 0.0 0 0 0 0 1 0.0 0
> aio 13 i 0.0 0 0 0 0 1 0.0 0
> aio 14 i 0.0 0 0 0 0 1 0.0 0
> aio 15 i 0.0 0 0 0 0 1 0.0 0
> pio 0 i 0.0 0 0 0 0 1 0.0 0
> lio 0 i 0.0 0 0 0 0 1 0.0 0
>
> and Output on Solaris10 :
>
> AIO I/O queues:
> q name/id len maxlen totalops dskread dskwrite dskcopy
> sqli_dbg 0 0 0 0 0 0 0
> kio 0 0 33 26979429 26709571 269858 0
> kio 1 0 35 35295087 34913732 381355 0
> kio 2 0 34 22680703 22418601 262102 0
> kio 3 0 33 28207965 27886300 321665 0
> kio 4 0 45 18770661 18519212 251449 0
> kio 5 0 35 6546432 6374127 172305 0
> kio 6 0 33 15709457 15478911 230546 0
> kio 7 0 33 4807920 4662439 145481 0
> kio 8 0 33 8182706 7970828 211878 0
> kio 9 0 34 10184606 9966479 218127 0
> kio 10 0 34 5615462 5454854 160608 0
> kio 11 0 34 8276324 8079227 197097 0
> kio 12 0 34 7829620 7658351 171269 0
> kio 13 0 33 5538105 5397366 140739 0
> kio 14 0 33 5214106 5067384 146722 0
> kio 15 0 33 4356281 422
Hello.
Had you run update statistics after the import process???
Regards.
Em 13/07/2011 13:51, VARAPORN VERAVITHAYA escreveu:
> Hello ,
>
> I have some problem about IDS9.40FC7 on solaris9 and solaris10.
> We have just migrate all database from IDS9.40Fc7 on solaris9 to solaris10.
> It work OK. All DB is RAW-DEVICE.
> I have also tuned some parameter as follow
>
> NUMCPUVP from 16 to 25
> NETTYPE TCPIP from 16*300 to 25*300>
> other is the same. Problem occur is it work on solaris10 slower than
solaris9.
> I also keep output from ioq command and found the difference.
> in "aio" .
>
> Question :
> Any problem about I/O system ?
> what should I do next? tunning AIO ? (now NUMAIOVPs =16)
>
> Here are output : on Solaris9
>
> AIO I/O queues:
> q name/id len maxlen totalops dskread dskwrite dskcopy
> sqli_dbg 0 0 0 0 0 0 0
> kio 0 0 35 54725169 51695967 3029202 0
> kio 1 0 33 54549058 51634426 2914632 0
> kio 2 0 35 42543355 39969828 2573527 0
> kio 3 0 35 52637742 49880635 2757107 0
> kio 4 0 35 45853601 43314115 2539486 0
> kio 5 0 35 33381826 31184329 2197497 0
> kio 6 0 35 37633933 35281852 2352081 0
> kio 7 0 35 30361438 28241291 2120147 0
> kio 8 0 35 23182191 21552832 1629359 0
> kio 9 0 37 19696708 18469797 1226911 0
> kio 10 0 35 27120918 25224541 1896377 0
> kio 11 0 35 16042761 15134660 908101 0
> kio 12 0 35 13796483 13020932 775551 0
> kio 13 0 35 9837110 9302937 534173 0
> kio 14 0 35 8803804 8315078 488726 0
> kio 15 0 35 8285299 7789820 495479 0
> kio 16 0 35 12168988 11527099 641889 0
> kio 17 0 35 7471780 6999295 472485 0
> adt 0 0 0 0 0 0 0
> msc 0 0 5 2797073 0 0 0
> aio 0 0 15 395 66 10 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
> gfd 26 0 0 0 0 0 0
> gfd 27 0 0 0 0 0 0
> gfd 28 0 0 0 0 0 0
> gfd 29 0 0 0 0 0 0
> gfd 30 0 0 0 0 0 0
> gfd 31 0 0 0 0 0 0
> gfd 32 0 0 0 0 0 0
> gfd 33 0 0 0 0 0 0
> gfd 34 0 0 0 0 0 0
> gfd 35 0 0 0 0 0 0
> gfd 36 0 0 0 0 0 0
> gfd 37 0 0 0 0 0 0
> gfd 38 0 0 0 0 0 0
> gfd 39 0 0 0 0 0 0
> gfd 40 0 0 0 0 0 0
> gfd 41 0 0 0 0 0 0
> gfd 42 0 0 0 0 0 0
> gfd 43 0 0 0 0 0 0
> gfd 44 0 0 0 0 0 0
> gfd 45 0 0 0 0 0 0
> gfd 46 0 0 0 0 0 0
> gfd 47 0 0 0 0 0 0
> gfd 48 0 0 0 0 0 0
> gfd 49 0 0 0 0 0 0
> gfd 50 0 0 0 0 0 0
> gfd 51 0 0 0 0 0 0
> gfd 52 0 0 0 0 0 0
> gfd 53 0 0 0 0 0 0
> gfd 54 0 0 0 0 0 0
> gfd 55 0 0 0 0 0 0
> gfd 56 0 0 0 0 0 0
> gfd 57 0 0 0 0 0 0
> gfd 58 0 0 0 0 0 0
> gfd 59 0 0 0 0 0 0
> gfd 60 0 0 0 0 0 0
> gfd 61 0 0 0 0 0 0
> gfd 62 0 0 0 0 0 0
> gfd 63 0 0 0 0 0 0
> gfd 64 0 0 0 0 0 0
> gfd 65 0 0 0 0 0 0
> gfd 66 0 0 0 0 0 0
> gfd 67 0 0 0 0 0 0
> gfd 68 0 0 0 0 0 0
> gfd 69 0 0 0 0 0 0
> gfd 70 0 0 0 0 0 0
> gfd 71 0 0 0 0 0 0
> gfd 72 0 0 0 0 0 0
> gfd 73 0 0 0 0 0 0
> gfd 74 0 0 0 0 0 0
> gfd 75 0 0 0 0 0 0
> gfd 76 0 0 0 0 0 0
> gfd 77 0 0 0 0 0 0
> gfd 78 0 0 0 0 0 0
> gfd 79 0 0 0 0 0 0
> gfd 80 0 0 0 0 0 0
> gfd 81 0 0 0 0 0 0
> gfd 82 0 0 0 0 0 0
> gfd 83 0 0 0 0 0 0
> gfd 84 0 0 0 0 0 0
> gfd 85 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 s 445.3 40994852 37992802 3002050 0 73323685 0.6 0
> kio 1 i 476.8 43889661 40998778 2890883 0 78363138 0.6 0
> kio 2 b 357.6 32914615 30367574 2547041 0 57339723 0.6 0
> kio 3 s 454.9 41872354 39138233 2734121 0 74379364 0.6 0
> kio 4 s 389.6 35865347 33343136 2522211 0 63070115 0.6 0
> kio 5 s 272.1 25047597 22865578 2182019 0 42937308 0.6 0
> kio 6 i 311.4 28669797 26337738 2332059 0 49572626 0.6 0
> kio 7 i 244.9 22541415 20437858 2103557 0 38243115 0.6 0
> kio 8 i 179.6 16529812 14917943 1611869 0 27498577 0.6 0
> kio 9 s 149.2 13733359 12518652 1214707 0 22740635 0.6 0
> kio 10 i 214.7 19765263 17879848 1885415 0 33238267 0.6 0
> kio 11 i 114.8 10565644 9667598 898046 0 17171349 0.6 0
> kio 12 i 97.5 8971772 8212605 759167 0 14509994 0.6 0
> kio 13 i 67.8 6241082 5717806 523276 0 9906288 0.6 0
> kio 14 s 61.2 5631644 5150876 480768 0 8894041 0.6 0
> kio 15 i 59.3 5462267 4980768 481499 0 8629154 0.6 0
> kio 16 s 86.0 7914771 7282480 632291 0 12776659 0.6 0
> kio 17 i 53.5 4926551 4462110 464441 0 7676771 0.6 0
> msc 0 s 30.4 2797084 0 0 0 2750345 1.0 0
> aio 0 i 3.0 279826 137836 141702 0 269210 1.0 0
> aio 1 i 1.1 98121 50475 47630 0 103204 1.0 0
> aio 2 i 0.2 21923 11308 10612 0 25648 0.9 0
> aio 3 i 0.0 3226 1651 1574 0 4844 0.7 0
> aio 4 i 0.0 25 8 15 0 207 0.1 0
> aio 5 i 0.0 5 1 2 0 11 0.5 0
> aio 6 i 0.0 2 0 0 0 3 0.7 0
> aio 7 i 0.0 2 0 0 0 1 2.0 0
> aio 8 i 0.0 2 0 0 0 1 2.0 0
> aio 9 i 0.0 1 0 0 0 1 1.0 0
> aio 10 i 0.0 0 0 0 0 1 0.0 0
> aio 11 i 0.0 0 0 0 0 1 0.0 0
> aio 12 i 0.0 0 0 0 0 1 0.0 0
> aio 13 i 0.0 0 0 0 0 1 0.0 0
> aio 14 i 0.0 0 0 0 0 1 0.0 0
> aio 15 i 0.0 0 0 0 0 1 0.0 0
> pio 0 i 0.0 0 0 0 0 1 0.0 0
> lio 0 i 0.0 0 0 0 0 1 0.0 0
>
> and Output on Solaris10 :
>
> AIO I/O queues:
> q name/id len maxlen totalops dskread dskwrite dskcopy
> sqli_dbg 0 0 0 0 0 0 0
> kio 0 0 33 26979429 26709571 269858 0
> kio 1 0 35 35295087 34913732 381355 0
> kio 2 0 34 22680703 22418601 262102 0
> kio 3 0 33 28207965 27886300 321665 0
> kio 4 0 45 18770661 18519212 251449 0
> kio 5 0 35 6546432 6374127 172305 0
> kio 6 0 33 15709457 15478911 230546 0
> kio 7 0 33 4807920 4662439 145481 0
> kio 8 0 33 8182706 7970828 211878 0
> kio 9 0 34 10184606 9966479 218127 0
> kio 10 0 34 5615462 5454854 160608 0
> kio 11 0 34 8276324 8079227 197097 0
> kio 12 0 34 7829620 7658351 171269 0
> kio 13 0 33 5538105 5397366 140739 0
> kio 14 0 33 5214106 5067384 146722 0
> kio 15 0 33 4356281 4220383 135898 0
> kio 16 0 33 4087949 3958888 129061 0
> kio 17 0 35 3785493 3658046 127447 0
> kio 18 0 34 2800605 2699416 101189 0
> kio 19 0 34 3264195 3148095 116100 0
> kio 20 0 33 2105706 2019947 85759 0
> kio 21 0 34 3118483 3009526 108957 0
> kio 22 0 37 2544910 2451226 93684 0
> kio 23 0 33 2391409 2302558 88851 0
> kio 24 0 33 2238788 2152451 86337 0
> adt 0 0 0 0 0 0 0
> msc 0 0 53 1525384 0 0 0
> aio 0 0 85 273219 66 68253 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
>
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g