Poor OnLine Workgroup Server Performace
This is a multi-part message in MIME format.
--------------6BBF66C177E
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Hi all:
I installed OWS 7.20.UC2 recently on SCO OpenServer. While importing a
database from INFORMIX-SE I saw that the performance was too poor.
I drop some indexes before load, and tried putting the database in no
logging mode, without any sastifactory result.
Attached, you will find a profile obtained using onstat.
Based on it, could you give some sugestions about the onconfig
parameters?
--
+---------------------------------------------------------------+
| Ing. Melvin Perez Cedano INFORMIX Authorized Distributor |
| Technical Vicepresident Santo Domingo, Dominican Rep. |
| CAM Informatica, S. A. mailto:cam@codetel.net.do |
+---------------------------------------------------------------+
--------------6BBF66C177E
Content-Type: text/plain; charset=us-ascii; name="stat.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline; filename="stat.txt"
INFORMIX-OnLine Version 7.20.UC2 -- On-Line -- Up 04:46:06 -- 10248 Kbytes
Userthreads
address flags sessid user tty wait tout locks nreads nwrites
10438014 ---P--D 1 root - 0 0 0 1280 16785
10438448 ---P--F 0 root - 0 0 0 0 309255
1043887c ---P--F 0 root - 0 0 0 0 134388
10438cb0 ---P--F 0 root - 0 0 0 0 149507
104390e4 ---P--F 0 root - 0 0 0 0 144894
10439518 ---P--B 9 root - 0 0 0 83 2
1043994c ---P--D 11 root - 0 0 0 0 0
1043a5e8 ---PX-- 244 informix - 0 0 3 241782 203680
8 active, 128 total, 20 maximum concurrent
Profile
dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached
580336 629429 16840091 96.55 782972 1365898 6975154 88.77
isamtot open start read write rewrite delete commit rollbk
13392024 9070 12536 428604 3771223 168 272 41150 1
ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes
5 0 0 985.27 450.49 400 859
bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans
35104 0 4085133 0 0 405 39207 997
ixda-RA idx-RA da-RA RA-pgsused lchwaits
506 0 57996 58372 2275
--------------6BBF66C177E--