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