Hi all,
I have pmacctd running on a dedicated machine listening on a gigabit
Ethernet port. It is only collecting half of the data that the router
is passing to it. For example, at this time, the 5 minute average from
the router (confirmed with ifconfig) is 136,087,000 bits/sec and pmacctd
is reporting only 70,212,327 bits/sec.
All I'm trying to do is produce 5 minute usage reports by IP address
for both source and destination traffic. When I have
sql_dont_try_update disabled, it brings the CPU on the MySQL server to
99%, so I have it enabled until I can put in a stronger MySQL server. I
have done this with and without sql_optimize_clauses with no difference.
Has anyone else gotten this working with this volume of traffic? If
so, I would appreciate knowing what you did to get it working.
Thanks,
Dave
P.S. - Here is the config for pmacctd:
debug: false
daemonize: false
aggregate: src_host,dst_host
plugins: mysql
plugin_buffer_size: 32768
plugin_pipe_size: 33554432
interface: eth0
interface_wait: true
promisc: true
syslog: local6
networks_file: /usr/local/pmacct/etc/networks.lst
network_cache_entries: 4091
sql_host: <hidden>
sql_user: <hidden>
sql_passwd: <hidden>
sql_db: pmacct
sql_table: acct_v2
sql_table_version: 2
sql_refresh_time: 5
sql_optimize_clauses: false
sql_history: 5m
sql_history_roundoff: m
sql_recovery_logfile: /usr/local/pmacct/var/log/recover
sql_cache_entries: 7919
sql_dont_try_update: true
post_tag: %%LGINSTANCE%%
sampling_rate: 1
--
Dave Maple
Senior Network Engineer
GMTI, Foundation Engineering
(757)624-2471
[EMAIL PROTECTED]
