So, if you remove the "LIMIT" restriction, it then just runs longer, 
with no other adverse effects?  That aside, I assume you want to run the 
cleanup application at night because the load is generally a lot lower.  
Just to get an idea what you're up against, how many messages are we 
talking about per day and what is the configuration of your server in 
terms of CPU(s), memory and disks that results in its working so hard to 
keep up?

Nate wrote:
> I've noticed that under a high volume mail server using policyd, with 
> the cleanup app running each hour, the operation can take some time 
> to complete, which bogs down the database server considerably.  I 
> would like to change the cleanup script to run once daily instead in 
> the middle of the night.
>
> Although, in the source code all the cleanup queries have LIMIT 
> 100000 on them.  Not a problem when running it hourly, but daily this 
> could cause issues becuase the database may grow faster than 100000 
> entries per day.
>
> example line 74 of cleanup.c: "DELETE QUICK FROM triplet WHERE 
> _datelast < %d LIMIT 100000",
>
> The limit command seems counterproductive.  I can remove it from the 
> source of my installation easy enough, but I would suggest it be 
> removed from the distributable source as well unless there's a great 
> reason to keep the limits.
>
> - Nate
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> policyd-users mailing list
> policyd-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/policyd-users
>   



-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
policyd-users mailing list
policyd-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/policyd-users

Reply via email to