Re: onstat -g sch

}>From ilist@rmy.emory.edu Mon Jun 2 13:30:44 1997 }>Received: from rmy.rmy.emory.edu by hobbes.dbintellect.com via ESMTP (950413.SGI.8.6.12/930416.SGI.AUTO) }> for <settler@dbintellect.com> id NAA15009; Mon, 2 Jun 1997 13:29:47 -0600 }>Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id NAA16904 for informix-list-out; Mon, 2 Jun 1997 13:25:01 -0400 (EDT) }>Message-ID: <3393000E.6DA0@earthlink.net> }>Date: Mon, 02 Jun 1997 12:17:02 -0500 }>From: Kernoal Stephens <kernoals@earthlink.net> }>Reply-To: kernoals@earthlink.net }>Organization: First Data Corporation }>X-Mailer: Mozilla 3.0Gold (Win95; I) }>MIME-Version: 1.0 }>To: informix-list@rmy.emory.edu }>Subject: onstat -g sch }>Content-Type: text/plain; charset=us-ascii }>Content-Transfer-Encoding: 7bit }>Sender: informix-list-owner@rmy.emory.edu }>X-Informix-List-Id: <list.14742> }> }>I am running 7.22.uc1 on Solaris 2.5, 8CPU, 7CPUVP's the following is }>the output from onstat -g sch. }> }>Notice I have 7CUPVP's but vp 8 seems to be doing all the work. ANYONE }>know what the heck is going on. }>I just happen to notice this one day. I have been suffering from poor }>performance since the upgrade from 7.13 but I can't quit figure out what }>the problem is. }> }> }>INFORMIX-OnLine Version 7.22.UC1X8 -- On-Line -- Up 4 days 00:16:42 -- }>477584 Kb }>ytes }> }>VP Scheduler }>Statistics: }> }> vp pid class semops busy waits }>spins/wait }> 1 9708 cpu 58 248 }>4017 }> 2 9709 adm 0 }>0 0 }> 3 9710 cpu 1411 2065 }>8040 }> 4 9711 cpu 1444 2117 }>8136 }> 5 9712 cpu 1377 1969 }>8248 }> 6 9713 cpu 1244 1821 }>8186 }> 7 9714 cpu 1284 1871 }>8098 }> 8 9715 cpu 346519 461490 }>8746 }> 9 9716 lio 0 }>0 0 }> 10 9717 pio 0 }>0 0 }> 11 9718 aio 6390 }>0 0 }> 12 9719 msc 20812 }>0 0 }> 13 9720 shm 0 }>0 0 }> 14 9721 shm 0 }>0 0 }> 15 9852 lio 0 }>0 0 }> 16 9853 pio 0 }>0 0 }> It is likely that VP #8 is the CPU VP that is handling the Socket polling. We have seen this also. It seems as if the Socket TCP poll thread (assuming you have a single poll thread) runs on the a dedicated CPU VP. You can see what is running on VP8 by executing onstat -g act -r 1. If you think the poll thread is a bottleneck, you could add additional poll threads by adding a line like NETTYPE soctcp,4,10,CPU to your onconfig. In this example, Informix would start four soctcppoll threads, and each could accommodate ten connections. ------------------------------------------------------------------- Jeff Craig | dbINTELLECT Technologies, Inc. Senior Consultant | Golden, CO | (303) 275-6954 ext. 8008 | email: settler@dbintellect.com | fax: (303) 275-2134 -------------------------------------------------------------------