On Tue 29 Aug 2006 12:23, zulkarnain wrote: > Hi gregor, > > Thanks for your reply. This directives out "sql_history" and > "sql_history_roundoff" only solve my problem with database size and number > of row increase issue. And now pmacct result become inaccurate since > pmacct keep continue calculating traffic from the first time pmacctd > started. Is there any tricks to get the last 5 minutes data for each ip > address without getting database size and number of row increase? any help > would be great.
Sure. Delete the old rows! You should be able to do this quite easily with a cron script.. -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc
pgpBKeoFOMIrk.pgp
Description: PGP signature
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
