Re: Poor Performance with 7.31.uc6

From: "Ty O'Kelly" <tokelly@maxor.invalid.com> > >Obnoxio The Clown wrote: > > > From: "Ty O'Kelly" <tokelly@maxor.invalid.com> > > >After the upgrade I performed the "Update Statistics" as noted in > > >the documentation, but I have seen a post from Clown suggesting "UPDATE > > >STATISTICS DROP DISTRIBUTIONS". Would this make a significant > > >difference? Using recent posts as a guide I am including output from > > > > Of course not! I made the suggestion purely out of spite. > >Ok, let me rephrase the question. Will the performance increase be >significant enough to justify my staying up late for however many nights it >will take to do this, since we typically do this sort of thing when the >user >load is light? Of course, if I wind up having to drop and recreate the all >indexes this might not really matter... You'll probably have to do it anyway. > > >onstat -P | tail -5:> > > > > >Percentages: > > >Data 6.77 > > >Btree 92.40 > > >Other 0.82 > > > > This looks ugly. What is the output of > > > > onstat -B | grep " d0 " | wc -l> > 0 Hmmmm...what's the smiley for raised eyebrows. > > It really looks like you've run into the LRU priority scheduling bug? I > > could have sworn this was fixed. Can you try dropping and recreating >your > > indexes, as well as USLDD? > >I may not have much choice but to drop and recreate indexes. Sounds like I >will get to enjoy quite a few late nights. What is USLDD? I don't find a >reference to that abbreviation anywhere. Update Statistics Low Drop Distributions. IIRC, there's some grief withbadly formed distributions when you migrate. That's why you might have to do it whether you want to or not. This kind of thing is exactly why I'm a big fan of dbexport/dbimport data migrations. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com