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