Re: [pmacct-discussion] nfacctd: mysql Plugin -- DB Writer [total]

Thanks Paolo, I'll see how i can enhance this setup. Kind regards, Luc On Fri, Mar 3, 2017 at 8:23 AM, Paolo Lucente wrote: > > Hi Luc, > > At a glance it looks a case where you are overwhelming the RDBMS 1) you > write data to a static table, ie. acct, likely making the

Re: [pmacct-discussion] nfacctd: mysql Plugin -- DB Writer [total]

Hi Luc, At a glance it looks a case where you are overwhelming the RDBMS 1) you write data to a static table, ie. acct, likely making the table and its index(es) big; 2) you make use of UPDATE queries, which are expensive; whereas you should try to aim at an INSERT-only environment (*); 3) the