[Greylist-users] Huge Greylist MySQL table

[Paul Venezia]

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