Re: bayes DB in CDB format
Asif Iqbal wrote: > Hi All > > I see notes on using MySQL/PgSQL and other SQL database and migration > from Berkeley DB to MySQL. I was wondering if anyone knows how to > migrate to DAN's CDB from Berkeley DB for bayes DB. I like to use that (CDB) > as the > bayes DB. > > Thanks for any help/suggestion/tip > CDB would be rather difficult to support for SA's bayes system. It's designed for "constant databases", ie: those which are built once and read many times without change. To this end, CDB does not support single-record inserts or deletes, which are very key operations to SpamAssassin's learning and expiry. Any learning or expiry operation would require deleting the entire bayes database and rebuilding the whole thing.
Re: bayes DB in CDB format
Rick Macdougall wrote: Asif Iqbal wrote: Hi All I see notes on using MySQL/PgSQL and other SQL database and migration from Berkeley DB to MySQL. I was wondering if anyone knows how to migrate to DAN's CDB from Berkeley DB for bayes DB. I like to use that (CDB) as the bayes DB. Thanks for any help/suggestion/tip Hi, While I do not know the answer to that (I believe it's going to be "Sorry, CDB is not currently supported"), you should really look at MySQL or PgSQL for bayes if you are going to migrate. On a heavily loaded server you almost have to run bayes with MySQL or suffer the consequences of bayes locking / expiry. Not to mention when having > 1 spamd servers scanning the same "stream." of messages and thus should share the same data. Arvinn
Re: bayes DB in CDB format
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Asif Iqbal wrote: > Hi All > > I see notes on using MySQL/PgSQL and other SQL database and > migration from Berkeley DB to MySQL. I was wondering if anyone > knows how to migrate to DAN's CDB from Berkeley DB for bayes DB. I > like to use that (CDB) as the bayes DB. > > Thanks for any help/suggestion/tip > Doesn't CDB work best in a read only situation? or is that TDB? If it's got a perl module that follows the same interface as the other *_File (ie DB_File, SDBM_File, etc) modules, it could be tested I suppose. FYI, 3.1 has native support for SDBM, as well as Berkeley DB. It also has PgSQL and MySQL specific modules that offer features specific to those databases. Michael -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (Darwin) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCm/X3G4km+uS4gOIRAnREAKCbDCj/cpMAXq/hidhH/TgDjnNDuQCgmjaY Ulrcs902hDp4QzgxVlilLpo= =j1Sr -END PGP SIGNATURE-
Re: bayes DB in CDB format
Asif Iqbal wrote: Hi All I see notes on using MySQL/PgSQL and other SQL database and migration from Berkeley DB to MySQL. I was wondering if anyone knows how to migrate to DAN's CDB from Berkeley DB for bayes DB. I like to use that (CDB) as the bayes DB. Thanks for any help/suggestion/tip Hi, While I do not know the answer to that (I believe it's going to be "Sorry, CDB is not currently supported"), you should really look at MySQL or PgSQL for bayes if you are going to migrate. On a heavily loaded server you almost have to run bayes with MySQL or suffer the consequences of bayes locking / expiry. CDB may actually be worse then Berkeley DB for Bayes use, even if it was/is supported because of the method it uses for updates. With a real DB backend, those problems go away. Just my $0.02 with a couple of hundred thousand messages scanned a day. Regards, Rick
Re: bayes DB in CDB format
On Mon, May 30, 2005 at 07:18:31PM -0400, Asif Iqbal wrote: > from Berkeley DB to MySQL. I was wondering if anyone knows how to > migrate to DAN's CDB from Berkeley DB for bayes DB. I like to use that (CDB) > as the > bayes DB. There's no native support for CDB, so you'd have to do up your own BayesStore backend module, etc. -- Randomly Generated Tagline: Is it progress if a cannibal uses a knife and fork? pgpZC7tZDkRmu.pgp Description: PGP signature
bayes DB in CDB format
Hi All I see notes on using MySQL/PgSQL and other SQL database and migration from Berkeley DB to MySQL. I was wondering if anyone knows how to migrate to DAN's CDB from Berkeley DB for bayes DB. I like to use that (CDB) as the bayes DB. Thanks for any help/suggestion/tip -- Asif Iqbal PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu "..there are two kinds of people: those who work and those who take the credit...try to be in the first group;...less competition there." - Indira Gandhi