[Greylist-users] Huge Greylist MySQL table

[The Dragon]

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), denio at desktop.com.br 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, denio at desktop.com.br 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
>> Greylist-users at lists.puremagic.com
>> http://lists.puremagic.com/cgi-bin/mailman/listinfo/greylist-users
>>
>
> _______________________________________________
> Greylist-users mailing list
> Greylist-users at lists.puremagic.com
> http://lists.puremagic.com/cgi-bin/mailman/listinfo/greylist-users

-- The Dragon, dragon at dragonskeep.org on 12/13/2005