[Greylist-users] disk usage

[Alan Batie]

On Mon, Aug 25, 2003 at 12:31:02PM -0700, scott at spamwolf.com wrote:
> One server I manage has 409 email addresses that have been using 
> greylisting for over 30 days.  Currently, they have 151164 records.
> The exact number varies with time, but not much after the first 3 days.
> At 32 bytes per record, that's a little more than 4 megabytes.

My system is not much larger, but processes between 40,000 and 50,000
messages/day ("from=" lines in maillog), and 35-45K "Milter" entries.
I'm assuming the diff is the legitimate mail...

Here's the mysql database dir:

ls -l /var/db/mysql/relaydelay
total 506614
-rw-rw----  1 mysql  mysql         40 Jul  2 00:23 db.opt
-rw-rw----  1 mysql  mysql   10156320 Aug 26 12:07 dns_name.MYD
-rw-rw----  1 mysql  mysql    5022720 Aug 26 12:07 dns_name.MYI
-rw-rw----  1 mysql  mysql       8654 Jul  2 00:23 dns_name.frm
-rw-rw----  1 mysql  mysql          0 Jul  2 00:23 mail_log.MYD
-rw-rw----  1 mysql  mysql       1024 Jul  2 00:23 mail_log.MYI
-rw-rw----  1 mysql  mysql       8842 Jul  2 00:23 mail_log.frm
-rw-rw----  1 mysql  mysql  304936400 Aug 26 03:15 relayreport.MYD
-rw-rw----  1 mysql  mysql  133196800 Aug 26 03:16 relayreport.MYI
-rw-rw----  1 mysql  mysql       9056 Jul  2 00:23 relayreport.frm
-rw-rw----  1 mysql  mysql   46323336 Aug 26 12:07 relaytofrom.MYD
-rw-rw----  1 mysql  mysql   18766848 Aug 26 12:07 relaytofrom.MYI
-rw-rw----  1 mysql  mysql       9056 Jul  2 00:23 relaytofrom.frm

The db_maintenance script is run nightly.

-- 
Alan Batie                   ______    alan.batie.org                Me
alan at batie.org            \    /    www.qrd.org         The Triangle
PGPFP DE 3C 29 17 C0 49 7A    \  /     www.pgpi.com   The Weird Numbers
27 40 A5 3C 37 4A DA 52 B9     \/      spamassassin.taint.org  NO SPAM!

To announce that there must be no criticism of the President, or that we
are to stand by the President, right or wrong, is not only unpatriotic
and servile, but is morally treasonable to the American public.
-Theodore Roosevelt, 26th US President (1858-1919)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 305 bytes
Desc: not available
Url : http://lists.puremagic.com/pipermail/greylist-users/attachments/20030826/5e9b7319/attachment.bin