K
Keith Sudbury
Guest
Running idxcompact on modern versions of OE is fine. If they are running an older version make sure to check the KB because there were some bugs in the past. I have run weekly/monthly idxcompacts on very large (2TB+) databases in the past with no issues. YMMV based on the app but I usually look for indexes with 80% or lower Util with at least a thousand blocks, priority placed on indexes that are heavily used (based on _IndexStat info). Small indexes usually don't compact very well because of skew of data and the index structures. There are a couple of things to watch out for though... 1) Don't try and compact an index to 100%. The default of 80% is almost always fine. Setting it higher can make the next X updates slower as it splits the index blocks down to a realistic level. 2) If you have a large and very fragmented index the compact can cause quite a bit of activity when it is running. Large is relative to your database and system size. Running the compacts on a regular basis usually prevents this but going from fragmented to "optimal" that first time can be intense.
Continue reading...
Continue reading...