- 论坛徽章:
- 0
|
===========------------- - - - - - -
/home/informix/bin/onstat -s:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:06 -- 246840 Kbytes
Latches with lock or userthread set
name address lock wait userthread
===========------------- - - - - - -
/home/informix/bin/onstat -k:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
Locks
address wtlist owner lklist type tblsnum rowid key#/bsiz
0 active, 100000 total, 32768 hash buckets, 0 lock table overflows
===========------------- - - - - - -
/home/informix/bin/onstat -b:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
Buffers
address userthread flgs pagenum memaddr nslots pgflgs xflgs owner waitlist
10b930b0 0 0 3:749925 115d7800 16685 f220 80 1db61018 0
0 modified, 100000 total, 131072 hash buckets, 2048 buffer size
===========------------- - - - - - -
/home/informix/bin/onstat -t:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
Tblspaces
n address flgs ucnt tblnum physaddr npages nused npdata nrows nextns
0 active, 0 total
===========------------- - - - - - -
/home/informix/bin/onstat -d:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
Dbspaces
address number flags fchunk nchunks flags owner name
0 active, 2047 maximum
Chunks
address chunk/dbs offset size free bpages flags pathname
0x1da53928 1 1 0 2000000 1398046 PO-B /dev/INFORMIXDATA
0x1dba0b28 2 1 2000000 2000000 24 PO-B /dev/INFORMIXDATA
0x1dba0cb0 3 1 4000000 2000000 1236770 PO-B /dev/INFORMIXDATA
0x1dba0e38 4 1 6000000 2000000 1999997 PO-B /dev/INFORMIXDATA
0x1da53af0 5 1 8000000 2000000 1999997 PO-B /dev/INFORMIXDATA
5 active, 32766 maximum
Expanded chunk capacity mode: always
===========------------- - - - - - -
/home/informix/bin/onstat -l:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-1 0 32 0 0 0.00
phybegin physize phypos phyused %used
1:263 100000 61990 0 0.00
Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 0 32 0 0 0 0.0 0.0
Subsystem numrecs Log Space used
address number flags uniqid begin size used %used
0x1dba08a8 1 U-B---- 1 1:100263 50000 9261 18.52
0x1dba08e8 2 U---C-L 2 1:150263 50000 17801 35.60
0x1dba0928 3 A------ 0 1:200263 50000 0 0.00
0x1dba0968 4 A------ 0 1:250263 50000 0 0.00
0x1dba09a8 5 A------ 0 1:300263 50000 0 0.00
0x1dba09e8 6 A------ 0 1:350263 50000 0 0.00
0x1dba0a28 7 A------ 0 1:400263 50000 0 0.00
0x1dba0a68 8 A------ 0 1:450263 50000 0 0.00
0x1dba0aa8 9 A------ 0 1:500263 50000 0 0.00
0x1dba0ae8 10 A------ 0 1:550263 50000 0 0.00
10 active, 10 total
===========------------- - - - - - -
/home/informix/bin/onstat -p:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
0 0 0 0.00 0 0 0 0.00
isamtot open start read write rewrite delete commit rollbk
0 0 0 0 0 0 0 0 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 0.48 1.23 0 0
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
0 0 0 0 0 0 0 0
ixda-RA idx-RA da-RA RA-pgsused lchwaits
0 0 0 0 0
===========------------- - - - - - -
/home/informix/bin/onstat -x:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
Transactions
address flags userthread locks beginlg curlog logposit isol retrys coord
1db92018 A---- 1db61018 0 0 0 0x0 COMMIT 0
1db921e8 A---- 1db61628 0 0 0 0x0 COMMIT 0
2 active, 128 total, 0 maximum concurrent
===========------------- - - - - - -
/home/informix/bin/onstat -f:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
dataskip is OFF for all dbspaces
Changing data structure forced command termination.
===========------------- - - - - - -
/home/informix/bin/onstat -h:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
buffer hash chain length histogram
# of chains of len
131066 0
6 1
131072 total chains
6 hashed buffs
100000 total buffs
===========------------- - - - - - -
/home/informix/bin/onstat -C:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
Btree Cleaner Info
BT scanner profile Information
==============================
Changing data structure forced command termination.
===========------------- - - - - - -
/home/informix/bin/onstat -F:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
Fg Writes LRU Writes Chunk Writes
0 0 0
address flusher state data
1db61628 0 I 0 = 0X0
states: Exit Idle Chunk Lru
===========------------- - - - - - -
/home/informix/bin/onstat -R:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
8 buffer LRU queue pairs priority levels
# f/m pair total % of length LOW HIGH
0 F 12500 100.0% 12500 12500 0
1 m 0.0% 0 0 0
2 f 12500 100.0% 12500 12500 0
3 m 0.0% 0 0 0
4 f 12500 100.0% 12500 12500 0
5 m 0.0% 0 0 0
6 f 12500 100.0% 12500 12500 0
7 m 0.0% 0 0 0
8 f 12500 100.0% 12500 12500 0
9 m 0.0% 0 0 0
10 f 12500 100.0% 12500 12500 0
11 m 0.0% 0 0 0
12 f 12499 100.0% 12499 12499 0
13 m 0.0% 0 0 0
14 f 12500 100.0% 12500 12500 0
15 m 0.0% 0 0 0
0 dirty, 99999 queued, 100000 total, 131072 hash buckets, 2048 buffer size
start clean at 60.000% (of pair total) dirty, or 7500 buffs dirty, stop at 50.000%
===========------------- - - - - - -
/home/informix/bin/onstat -g glo:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
MT global info:
sessions threads vps lngspins
0 9 7 0
sched calls thread switches yield 0 yield n yield forever
total: 197 195 6 5 87
per sec: 0 0 0 0 0
Virtual processor summary:
class vps usercpu syscpu total
cpu 1 0.48 1.21 1.69
aio 2 0.00 0.01 0.01
lio 1 0.00 0.00 0.00
pio 1 0.00 0.01 0.01
adm 1 0.00 0.00 0.00
msc 1 0.00 0.00 0.00
total 7 0.48 1.23 1.71
Individual virtual processors:
vp pid class usercpu syscpu total
1 7442 cpu 0.48 1.21 1.69
2 7443 adm 0.00 0.00 0.00
3 7444 lio 0.00 0.00 0.00
4 7445 pio 0.00 0.01 0.01
5 7446 aio 0.00 0.01 0.01
6 7447 msc 0.00 0.00 0.00
7 7448 aio 0.00 0.00 0.00
tot 0.48 1.23 1.71
===========------------- - - - - - -
/home/informix/bin/onstat -g qst:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
Queue statistics not enabled
===========------------- - - - - - -
/home/informix/bin/onstat -g wst:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
Wait statistics not enabled
===========------------- - - - - - -
/home/informix/bin/onstat -g lmx:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
Locked mutexes:
mid addr name holder lkcnt waiter waittime
Number of mutexes on VP free lists: 0
===========------------- - - - - - -
/home/informix/bin/onstat -g wmx:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
Mutexes with waiters:
mid addr name holder lkcnt waiter waittime
Number of mutexes on VP free lists: 0
===========------------- - - - - - -
/home/informix/bin/onstat -g con:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
Conditions with waiters:
cid addr name waiter waittime
===========------------- - - - - - -
/home/informix/bin/onstat -g stk all:
Informix Dynamic Server Version 9.40.UC1G2 -- Initialization -- Up 00:00:07 -- 246840 Kbytes
Stack for thread: 10 flush_sub(0)
base: 0x1e14c000
len: 36864
pc: 0x085ab2c4
tos: 0x1e154ec0
state: sleeping
vp: 1
0x085ab2c4 (oninit)yield_processor_svp(0x1dba0830, 0x7, 0x100853b8, 0x0, 0x0, 0x0)
0x085ad77c (oninit)mt_yield(0xffffffff, 0x0, 0x0, 0x0, 0xa, 0x7)
0x0841dbda (oninit)flush_sub(0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x085b4c90 (oninit)startup (0x1b, 0x1e155818, 0x1e011c30, 0x818, 0x3c167c61, 0x0)
0x00000000 (*nosymtab*)0x0
Stack for thread: 9 soctcplst
base: 0x1e129000
len: 36864
pc: 0x085ab2c4
tos: 0x1e1310f0
state: sleeping
vp: 1
0x085ab2c4 (oninit)yield_processor_svp(0x1e106448, 0x1e106448, 0x5, 0x0, 0x0, 0x0)
0x085ad77c (oninit)mt_yield(0xffffffff, 0x1, 0x0, 0x0, 0x1e131244, 0x0)
0x085f085a (oninit)net_wait_for_io(0x1e106448, 0x1, 0x1e106448, 0x18, 0x1e106838, 0x1e102e00)
0x085f273b (oninit)accpsocket(0x1e102e10, 0x1e132018, 0x1e13170c, 0x1e10a304, 0x1e106838, 0x1e102e00)
0x08612469 (oninit)tlAccept(0x1e10a304, 0x1e132018, 0x1e13170c, 0x0, 0x1e13ae00, 0x1e13a8b0)
0x0860f603 (oninit)slSQIind(0x1e10a304, 0x1e132018, 0x1e131708, 0x1e13170c, 0x1e132090, 0x1e10a304)
0x0860aad5 (oninit)pfConInd(0x1e10a304, 0x1e132018, 0x1e131bcc, 0x1e1320fc, 0x1e10ac28, 0x1e10a090)
0x086033f2 (oninit)cmConInd(0x1e10a304, 0x1e132018, 0x1e131bcc, 0x85c4e10, 0x40, 0x4)
0x08601616 (oninit)ascInd (0x1e10a304, 0x1e10a090, 0x1e131bc8, 0x85e3bdf, 0x1e131e00, 0x1e131b84)
0x085e3bfe (oninit)gcc2_compiled.(0x1e131e00, 0x1e131bc8, 0x1e131fc8, 0x85ea0e7, 0x1e131bc8, 0xffffffff)
0x085ea0fd (oninit)sql_listener(0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x085b4c90 (oninit)startup (0x18, 0x1e132aa0, 0x1e10aed0, 0xaa0, 0x3c23e411, 0x0)
0x00000000 (*nosymtab*)0x0
Stack for thread: 8 soctcppoll
base: 0x1e120000
len: 36864
pc: 0x085ab2c4
tos: 0x1e128ed0
state: sleeping
vp: 1
0x085ab2c4 (oninit)yield_processor_svp(0x1d94c0d4, 0x1dfd0e40, 0x1e128fc8, 0x85fe85e, 0xa, 0x1e128fbc)
0x085af322 (oninit)mt_poll_yield(0xa, 0x1e128fbc, 0x1e128fc8, 0x85fe7c3, 0x6, 0x7)
0x085fe85e (oninit)soc_poll_thread(0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x085b4c90 (oninit)startup (0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x00000000 (*nosymtab*)0x0
Stack for thread: 7 main_loop()
base: 0x1e10f000
len: 69632
pc: 0x085b2c59
tos: 0x1e11ed70
state: running
vp: 1
0x085b2c59 (oninit)mt_system(0x1e11ef18, 0x0, 0x0, 0x3e6, 0x0, 0x8972ae0)
0x085cf539 (oninit)afhandler(0x2, 0x8972080, 0x8972ae0, 0x0, 0x401, 0x1)
0x085cecdc (oninit)affail_interface(0x8972080, 0x8972ae0, 0x0, 0x1, 0x883d27e, 0x3e6)
0x08438490 (oninit)bffail (0x1000, 0x87e0e80, 0x0, 0x1db61474, 0x10b92d70, 0x
0x080fc245 (oninit)initchunk(0x0, 0x0, 0x1e11f580, 0x1, 0x7, 0x10088794)
0x080f9430 (oninit)initseg (0x1e11ff28, 0x10088788, 0x1, 0x80f2d4f, 0xa, 0x6)
0x080f3138 (oninit)main_loop(0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x085b4c90 (oninit)startup (0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
0x00000000 (*nosymtab*)0x0
Stack for thread: 6 aio vp 1
base: 0x1e0ef000
len: 36864
pc: 0x085b4814
tos: 0x1e0f7e70
state: sleeping
vp: 7
0x085b4814 (oninit)yield_processor_mvp(0x1e0c1ba8, 0x1e097830, 0x1e0c1ba8, 0x85ad62e, 0x1e0e5140, 0x0)
0x085ad785 (oninit)mt_yield(0xffffffff, 0x1e0e5140, 0x1e0f8018, 0x0, 0x0, 0x0)
0x085bdfcd (oninit)ioidle (0x1e0c1ba8, 0x85b4c00, 0x6000, 0x0, 0x1e097830, 0x1e0c1ba
0x085bde69 (oninit)iowork (0x1e0c1ba8, 0x1, 0x2, 0x0, 0x0, 0x0)
0x085bdf41 (oninit)iothread(0x1e0c1ba8, 0x0, 0x0, 0x0, 0x0, 0x0)
0x085b4c90 (oninit)startup (0x28, 0x1e0fa128, 0x1e0e52b8, 0x2128, 0x3c1e1509, 0x0)
0x00000000 (*nosymtab*)0x0
Stack for thread: 5 msc vp 0
base: 0x1e0c2000
len: 135168
pc: 0x085b4814
tos: 0x1e0e2e70
state: sleeping
vp: 6
0x085b4814 (oninit)yield_processor_mvp(0x1e0ac9b8, 0x1e0ac830, 0x1e0ac9b8, 0x85aff14, 0x1d94a66c, 0xb75fe710)
0x085ad785 (oninit)mt_yield(0xffffffff, 0x1e0b8140, 0x1e0e3018, 0x0, 0x0, 0x1e0ac830)
0x085bdfcd (oninit)ioidle (0x1e0ac9b8, 0x0, 0x1e0e2f98, 0x85bde49, 0x1e0ac830, 0x1e0ac9b
0x085bde69 (oninit)iowork (0x1e0ac9b8, 0x9, 0x102, 0x0, 0x0, 0x7)
0x085bdf41 (oninit)iothread(0x1e0ac9b8, 0x0, 0x0, 0x0, 0x0, 0x0)
0x085b4c90 (oninit)startup (0x28, 0x1e0e5128, 0x1e0b82b8, 0x2128, 0x3c19f509, 0x0)
0x00000000 (*nosymtab*)0x0 |
|