RE: Slow reposnse
Pretty strange looking. No I/O bottleneck(if there was the scan thread
would be waiting on the I/O, not MC1), not waiting on a lock or a checkpoint
and plenty of CPU resources available. But the primary thread just sleeps.
Something with the priority of the oninit processes maybe? Try re-nicing
them. Just a guess..
Regards,
Bill
> -----Original Message-----
> From: Neil Truby [SMTP:neil.truby@ardenta.com]
> Sent: Friday, January 30, 2004 10:58 AM
> To: informix-list@iiug.org
> Subject: Re: Slow reposnse
>
> "Neil Truby" <neil.truby@ardenta.com> wrote in message
> news:bvdt8c$qpn8p$1@ID-162943.news.uni-berlin.de...
> > 7.31 FD5 on HP-UX 11.0
>
> In fact, more generally, any select.
> I've created a test table, inserted a single row (instantaneous), then
> tried
> to select it -... takes about 5 or 10 minutes:
> Very curious!
>
> regards
> Neil
>
> $ onstat -g sql 2285>
> Informix Dynamic Server Version 7.31.FD5 -- On-Line -- Up 05:40:40 --
> 2993496 Kbytes
>
> Sess SQL Current Iso Lock SQL ISAM F.E.
> Id Stmt type Database Lvl Mode ERR ERR Vers
> 2285 SELECT con_pub_mart CR Not Wait 0 0 7.31
>
> Current statement name : slctcur
>
> Current SQL statement :
> select * from ardenta_test>
> Last parsed SQL statement :
> select * from ardenta_test>
> $ onstat -g ses 2285>
> Informix Dynamic Server Version 7.31.FD5 -- On-Line -- Up 05:40:46 --
> 2993496 Kbytes
>
> session #RSAM total used
> id user tty pid hostname threads memory memory
> 2285 informix ti 1240 info01 2 65536 60512
>
> tid name rstcb flags curstk status
> 189847 sqlexec c0000000a43edcd0 ---P--- 267584 sleeping(secs: 1)
> 189848 scan_1.0 c00000009dc62888 Y------ 268416 cond wait(await_MC1)
>
> Memory pools count 1
> name class addr totalsize freesize #allocfrag
> #freefrag
> 2285 V c0000000a77c3028 65536 5024 319 1
>
> name free used name free used
> overhead 0 184 scb 0 144
> opentable 0 3760 filetable 0 1680
> log 0 4336 temprec 0 1776
> keys 0 96 ralloc 0 8192
> gentcb 0 14024 ostcb 0 3368
> sqscb 0 10488 rdahead 0 864
> xchg_desc 0 1200 xchg_port 0 1112
> xchg_packet 0 408 xchg_group 0 104
> xchg_priv 0 320 hashfiletab 0 1104
> osenv 0 3080 sqtcb 0 3520
> fragman 0 392 shmblklist 0 360
>
> Sess SQL Current Iso Lock SQL ISAM F.E.
> Id Stmt type Database Lvl Mode ERR ERR Vers
> 2285 SELECT con_pub_mart CR Not Wait 0 0 7.31
>
> Current statement name : slctcur
>
> Current SQL statement :
> select * from ardenta_test>
> Last parsed SQL statement :
> select * from ardenta_test>
sending to informix-list