> So diagnosis is confirmed. You should investigate why MySQL is taking
> that 90%-ish CPU - which is not OK kind of behaviour. 
> 
> I can very well guess performing a 'src_host, dst_host' aggregation
> with monthly time-bins (sql_history: 1M) and updating content every
> minute (sql_refresh_time: 60, sql_dont_try_update set to false) can
> lead to some intensive amount of work.
> 
> > What else can I provide for information?
> What is the end goal of your deployment?

Accounting all the traffic (IPv4/6) with history.
Traffic inside our network has full ip_dst and ip_src.
Traffic outside our netwerk has a ip_dst or ip_src with 0.0.0.0/::

I want traffic per IP per month.

-- 
Met vriendelijke groet,


Dennis Koster

"I take no responsibility if it formats your server, defrosts your fridge, or 
touches your cat inappropriately."


_______________________________________________
pmacct-discussion mailing list
http://www.pmacct.net/#mailinglists

Reply via email to