Re: Spin locks bringing system to a crawl

On Mon, 21 Jul 2003 10:01:28 -0400, Jay wrote: You're getting some moderate LRU contention (BR ~7% & some LRU mutex spins >15), try increasing LRUS and CLEANERS to 48. RA_THRESHOLD is too high even for JBOD disk farm, try dropping that to 8 or 12 from 30. See if that helps. Art S. Kagel PS: I know it's pain but please do not use 'NOSPAM' style email addresses. > Hi, > > I'm having a major decrease in performance, and I'm wondering if the > number of spin locks (725 entries in onstat -g spi of "fast mutex, > bhash") are contributing to this. > > Enviroment > Informix 7.24 (I know we must upgrade, but unfortunatly it's not my > descion to as when), AIX 4.3.3, 4 CPUs, 1GB RAM, 8 disks no mirror or > stripes and volitile tables fragmented by round robin across 4 disks > (indexes for these tables are on seperate a disk). > > I am really hoping someone can help me! > > Thanks in advance > > J. <SNIP>