Re: [pmacct-discussion] question about sql_refresh

2017-04-22 Thread Farshid Abediny
Hi, i am using netflow and nfacctd and sql_dont_try_update is set to true (because update query take too much cpu usage) so in this case i do not lost any flows ? thanks, On Sat, Apr 22, 2017 at 7:52 PM, Paolo Lucente wrote: > > Hi Farshid, > > The question is generic. What daemon are you using?

Re: [pmacct-discussion] question about sql_refresh

2017-04-22 Thread Paolo Lucente
Hi Farshid, The question is generic. What daemon are you using? Since you mentioned flows, the following holds if you are using NetFlow/IPFIX and hence nfacctd as daemon. Also the assumption is sql_dont_try_update is not set to true (defaults to false). Granted nothing gets lost. What you will b

[pmacct-discussion] question about sql_refresh

2017-04-18 Thread Farshid Abediny
Hello, we set sql_refresh_time to 900 seconds due to high network list filter that write flows to mysql every 900 seconds so i want know when my routers send flows to pmacct it will save flow to its memory and every 900 seconds it will update database right ? so i do not lost flows between this int