Re: Huge Greylist MySQL table
| Newsgroups | gmane.mail.spam.greylist.user |
|---|---|
| Message-ID | <[email protected]> |
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 >