Sent: Thursday, September 18, 2014 8:44 AM
To: Scott Pettit - Vorco
Cc: pmacct-discussion@pmacct.net
Subject: Re: [pmacct-discussion] mySQL ATON/NTOA and pmacct performance
Hi Scott,
Great. Let me know how your testing goes. Should you hit any bugs or gaps, feel
free to contact me privately to solve
-
From: pmacct-discussion [mailto:pmacct-discussion-boun...@pmacct.net] On
Behalf Of Paolo Lucente
Sent: Thursday, September 18, 2014 8:44 AM
To: Scott Pettit - Vorco
Cc: pmacct-discussion@pmacct.net
Subject: Re: [pmacct-discussion] mySQL ATON/NTOA and pmacct performance
Hi Scott,
Great
Hi Scott,
Great. Let me know how your testing goes. Should you hit any bugs
or gaps, feel free to contact me privately to solve them. Then we
can summarize on the list.
Cheers,
Paolo
On Wed, Sep 17, 2014 at 04:35:05AM +, Scott Pettit - Vorco wrote:
In MySQL (any SQL actually), string
Hi Scott,
You are looking for sql_num_hosts: true. This is tested to work
with IPv4 addresses. I'm reasonably sure it won't work with IPv6:
i seem to recall INET6_ATON was not available in 2011, the time of
the original implementation of the feature. Should not be a biggie
to introduce it.
, September 17, 2014 7:29 AM
To: pmacct-discussion@pmacct.net
Subject: Re: [pmacct-discussion] mySQL ATON/NTOA and pmacct performance
Hi Scott,
You are looking for sql_num_hosts: true. This is tested to work with IPv4
addresses. I'm reasonably sure it won't work with IPv6:
i seem to recall INET6_ATON
In MySQL (any SQL actually), string searches are computationally very
expensive when compared with integers. If you’re dealing with a relatively
small number of rows then the difference isn’t a problem.
It’s like asking “show me all the rows where the number is between 1 and
1000” versus “show me
Hi,
I've been running pmacct for a while with PostgreSQL and it works well with
lots of netflow data presumably due to inbuilt handling of CIDR.
For various reasons we're migrating to a mySQL backend to integrate with our
billing/customer portal environment better and mySQL does not appear to