Re: AWL Database Cleanup

2008-04-29 Thread Theo Van Dinter
On Tue, Apr 29, 2008 at 09:27:49AM +0100, Justin Mason wrote: > To be honest, at this stage I'd be happy to see just a simple AWL expiry > mechanism -- the over-arching solution sounds like it just got bogged down > in too much generality. KISS. Perhaps. The issue is that it's basically going to

Re: AWL Database Cleanup

2008-04-29 Thread Justin Mason
Theo Van Dinter writes: > On Mon, Apr 28, 2008 at 03:52:02PM -0400, Kris Deugau wrote: > > There is no way I know of to shrink BerkelyDB files in-place. >:( > > In case anyone's wondering, this is why the Bayes expire system creates a new > DB file and copies over the entries that should be kept

Re: AWL Database Cleanup

2008-04-28 Thread Theo Van Dinter
On Mon, Apr 28, 2008 at 03:52:02PM -0400, Kris Deugau wrote: > There is no way I know of to shrink BerkelyDB files in-place. >:( In case anyone's wondering, this is why the Bayes expire system creates a new DB file and copies over the entries that should be kept, then deletes/renames the files.

Re: AWL Database Cleanup

2008-04-28 Thread Kris Deugau
listmail wrote: I noticed that the AWL database was getting rather large, so I used the check_whitelist script to remove the stale entries. While this seems to have removed a lot of entries from the database, it did not reduce the database size. Does anyone know what kind of a database this is,

Re: AWL Database Cleanup

2008-04-28 Thread Aaron Bennett
listmail wrote: I noticed that the AWL database was getting rather large, so I used the check_whitelist script to remove the stale entries. While this seems to have removed a lot of entries from the database, it did not reduce the database size. If you are using MySQL with the Innodb backend

Re: AWL Database Cleanup

2008-04-25 Thread Theo Van Dinter
On Fri, Apr 25, 2008 at 04:32:23PM -0700, listmail wrote: > Does anyone know what kind of a database this is, and in particular, how to do > a cleanup that will remove unused records? The database is currently located > on a RAM drive, so space is important due to scarcity as well as the potential

Re: AWL Database Cleanup

2008-04-25 Thread Steven Stern
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/25/2008 06:57 PM, listmail wrote: | This looks like a good way of dealing with the AWL database, but I don't | see anything in the documentation - did you hack in the MySQL support | yourself, or is there an option that I missed? | | For the mom

Re: AWL Database Cleanup

2008-04-25 Thread Matt Kettler
listmail wrote: This looks like a good way of dealing with the AWL database, but I don't see anything in the documentation - did you hack in the MySQL support yourself, or is there an option that I missed? There's MySQL support built into SA for the AWL, as well as Bayes. If you try hard en

Re: AWL Database Cleanup

2008-04-25 Thread listmail
This looks like a good way of dealing with the AWL database, but I don't see anything in the documentation - did you hack in the MySQL support yourself, or is there an option that I missed? For the moment, I'm trying to find a simple solution, such as locating a tool that is capable of managing

Re: AWL Database Cleanup

2008-04-25 Thread Steven Stern
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/25/2008 06:32 PM, listmail wrote: | I noticed that the AWL database was getting rather large, so I used the | check_whitelist script to remove the stale entries. While this seems to have | removed a lot of entries from the database, it did not r

AWL Database Cleanup

2008-04-25 Thread listmail
I noticed that the AWL database was getting rather large, so I used the check_whitelist script to remove the stale entries. While this seems to have removed a lot of entries from the database, it did not reduce the database size. Does anyone know what kind of a database this is, and in particular