Re: Huge Greylist MySQL table

The Dragon <[email protected]>
Newsgroups gmane.mail.spam.greylist.user
Message-ID <20051213223856.829768@Gwenn>
Denio,
it's actually part of the 0.04 codebase as well as part of the
CVS (pre-0.05) tree. Check here:
http://projects.puremagic.com/greylisting/downloads.html

	Frank

On Tue, 13 Dec 2005 20:34:47 -0200 (BRST), [email protected] wrote:
> Thanks Paul.
>
> Where can I find this db_maintenance script ? Or shall I write it
> on my own ?
>
> Regards,
>
> Denio
>
>> On Tue, 2005-12-13 at 17:13 -0200, [email protected] wrote:
>>> Hi,
>>>
>>> I am using greylist with qmail successfully for some time, but
>>> I have
>>> noticed that the MySQL tables keeps growing and growing. Now it
>>> has more
>>> than 1GByte already. I think this will probably slow down my
>>> server.
>>>
>>> Is there some kind of "maintenance script" for greylist
>>> available ? If
>>> not, what records can I delete from the database myself ?
>>>
>> There's a db_maintenance script that should be run nightly. IIRC,
>> it
>> moves anything older than 30 days into a reporting table. I added
>> some
>> code to roll stuff out of the reporting table after 90 days to
>> keep my
>>> 20MB/day tables from getting out of control.
>>>
>> -Paul
>>
>> _______________________________________________
>> Greylist-users mailing list
>> [email protected]
>> http://lists.puremagic.com/cgi-bin/mailman/listinfo/greylist-users
>>
>
> _______________________________________________
> Greylist-users mailing list
> [email protected]
> http://lists.puremagic.com/cgi-bin/mailman/listinfo/greylist-users

-- The Dragon, [email protected] on 12/13/2005
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.