[HELP] What my Informix is doing?
I wrote a esql/c program, which read about 100,000 records from a
plain data file one bye one while inserted(or updated) them into a
local database.
When the progress go to about 20,000 records, the program seems halt(
ver very slow!), and the hard disk keeps flashing for about 2 hours.
The sar -u reports:
17:47:16 %usr %sys %wio %idle (-u)
17:47:17 0 2 98 0
17:47:18 0 0 100 0
17:47:20 0 3 97 0
17:47:23 0 1 99 0
17:47:24 0 2 65 33
17:47:25 1 3 64 32
17:47:26 0 1 42 57
17:47:27 0 6 94 0
sar -d reports:
17:49:06 device %busy avque r+w/s blks/s avwait
avserv (-d)
17:49:07 wd-0 95.05 1.08 830.69 6693.07 0.10
1.14
17:49:08 wd-0 97.03 1.08 837.62 6700.99 0.09
1.16
17:49:09 wd-0 99.01 1.00 790.10 6320.79 0.00
1.25
17:49:10 wd-0 100.00 1.25 280.20 2225.74 0.88
3.57
17:49:11 wd-0 98.02 1.01 343.56 2748.51 0.03
2.85
sar -r reports:
17:49:46 freemem freeswp availrmem availsmem (-r)
17:49:47 1245 224576 11548 23929
17:49:48 953 229240 11548 23929
17:49:49 1394 225128 11548 23929
17:49:50 1175 226896 11548 23929
17:49:51 1001 228248 11548 23929
17:49:52 840 229544 11548 23929
17:49:53 703 230664 11548 23929
17:49:54 1196 224192 11548 23929
My system is SCO OSR5 + Informix Online 7.x with 128M ram. The
database is created w/o loging.
Is any method here let me know what the Informix is doing?
Thans in advance.
--
steven@lczmsoft.com
On 11 Sep 2003 02:54:04 -0700, steven@steven4u.net (steven) wrote:
>My system is SCO OSR5 + Informix Online 7.x with 128M ram. The
>database is created w/o loging.
>
>Is any method here let me know what the Informix is doing?
>
Try with some "onstats":
onstat -p
onstat -u
onstat -g sql session_id
onstat -g ses session_id
nebojsa
------------------------------------
Remove spam block (DELETE_) to reply
steven@steven4u.net (steven) wrote in message news:<1e7ef8d0.0309110154.29fa2925@posting.google.com>...
> I wrote a esql/c program, which read about 100,000 records from a
> plain data file one bye one while inserted(or updated) them into a
> local database.
>
> When the progress go to about 20,000 records, the program seems halt(
> ver very slow!), and the hard disk keeps flashing for about 2 hours.
> The sar -u reports:
>
Google through c.d.i and look for words like performance, slow, and
tuning. Take particular notice of the onstat commands that are
requested. Run those commands on your engine and post the results
here. Post the hardware configuration and OS that the engine is
running on. You haven't posted enough information for anyone to help
you.
Dave Thacker
Well,
Since your wio percentage is so high, I suspect that your page flusher are
rather busy. Do you have LRU Min set to zero?
"steven" <steven@steven4u.net> wrote in message
news:1e7ef8d0.0309110154.29fa2925@posting.google.com...
> I wrote a esql/c program, which read about 100,000 records from a
> plain data file one bye one while inserted(or updated) them into a
> local database.
>
> When the progress go to about 20,000 records, the program seems halt(
> ver very slow!), and the hard disk keeps flashing for about 2 hours.
> The sar -u reports:
>
> 17:47:16 %usr %sys %wio %idle (-u)
> 17:47:17 0 2 98 0
> 17:47:18 0 0 100 0
> 17:47:20 0 3 97 0
> 17:47:23 0 1 99 0
> 17:47:24 0 2 65 33
> 17:47:25 1 3 64 32
> 17:47:26 0 1 42 57
> 17:47:27 0 6 94 0>
> sar -d reports:
> 17:49:06 device %busy avque r+w/s blks/s avwait
> avserv (-d)
> 17:49:07 wd-0 95.05 1.08 830.69 6693.07 0.10
> 1.14
> 17:49:08 wd-0 97.03 1.08 837.62 6700.99 0.09
> 1.16
> 17:49:09 wd-0 99.01 1.00 790.10 6320.79 0.00
> 1.25
> 17:49:10 wd-0 100.00 1.25 280.20 2225.74 0.88
> 3.57
> 17:49:11 wd-0 98.02 1.01 343.56 2748.51 0.03
> 2.85>
> sar -r reports:
> 17:49:46 freemem freeswp availrmem availsmem (-r)
> 17:49:47 1245 224576 11548 23929
> 17:49:48 953 229240 11548 23929
> 17:49:49 1394 225128 11548 23929
> 17:49:50 1175 226896 11548 23929
> 17:49:51 1001 228248 11548 23929
> 17:49:52 840 229544 11548 23929
> 17:49:53 703 230664 11548 23929
> 17:49:54 1196 224192 11548 23929>
> My system is SCO OSR5 + Informix Online 7.x with 128M ram. The
> database is created w/o loging.
>
> Is any method here let me know what the Informix is doing?
>
>
> Thans in advance.
> --
> steven@lczmsoft.com