recommended overview format ...

Jaye Mathisen mrcpu at
Sat Dec 30 04:28:09 UTC 2000

reviewing some old mail...

One solution that worked for me was to get my system all quiescent.

clean out the overview dir, start, wait until the ov* files
are created (few seconds), then stop, move the ov* files to
whatever drives you want, then symlink them back into the main overview

Then you don't have to RAID anything, the load can be split up, and 
you don't have to mess with the DB_CONFIG file, which doesn't quite
do what you want, since any new files that ovdb create go in the first
datapath, and aren't evenly distributed over all the data dirs that you
can configure.

In my case, I dropped my ov* files on the end of each cycbuff drive,
with 16 data drives, 16 ov files, and then the logs and such in the
main spool/overview, I didn't see any load problems.


On Tue, Sep 12, 2000 at 02:06:24AM -0300, The Hermit Hacker wrote:
> On Tue, 12 Sep 2000, Katsuhiro Kondou wrote:
> > 
> > In article <Pine.BSF.4.21.0009112300140.1305-100000 at>,
> > 	The Hermit Hacker <scrappy at> wrote;
> > 
> > } what is currently the "recommended" overview format?  buffindexed or
> > } ovdb?  drawback/advantages to each?
> > 
> > For buffindexed, drawback, I think, is recovery may take
> > while.  Here is a real data when I did late last night
> > because of CPU failure. 3571026 entries are rebuilt in
> > 2.5hr, about 400ent/sec, whilst innd is stopped.
> okay, with ovdb, innd has to be running in order to rebuild ... what about
> buffindexed?  can the server be running while doing the rebuild, or does
> innd have to be down?
> I'm liking the features that ovdb is providing, the ability to check stats
> and whatnot, so will most likely be moving my large server to it when I
> get a new drive ... one major disadvantage of ovdb vs buffindexed is
> (unless I'm missing something), ovdb can't span file systems ... for
> 5million articles, it says you need 5.5gig, and unless I'm missing
> something, that means 5.5gig on one file system ... my news server right
> now is 10million articles, so barin gany other growth, to go to ovdb, I
> will need to dedicate ~10gig of contiguous file system just for overviews,
> instead of spreading it over multiple spindles :(

More information about the inn-workers mailing list