I'm trying to use pmacct in my network (2x 1G and 1x100M). I've noticed a very high cpu usage wich is normal in this case .. But I'm just wondering if it is possible to INSERT into table such information as: ipaddress incoming_traffic outgoing_traffic but in one row ? Now I can see hundrets of rows with ip addresses from my network AND with addresses from the whole internet (>500 dedicated servers + 6 for shared hosting) so after 10 minutes I've got 500 000 rows with all ip addresses wich ware connected to our servers.
-- what I need is sth like this --
src dst bytes
192.168.1.1 0.0.0.0 923480324
0.0.0.0 192.168.1.1 5042341
--------------------------------------------
My configuration :
pmacct : 0.11.0rc1
mysql: mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386)
system: debian sarge
cpu: p4 2gz
-- cut --
! pmacctd configuration
!
!
!
daemonize: true
pidfile: /var/run/pmacctd.pid
syslog: daemon
aggregate: src_host,dst_host
pcap_filter: net 80.87.0.0/16
interface: eth1
plugins : mysql
sql_db : bwstat
sql_table : acct
sql_table_version : 1
sql_passwd : secretpassword
sql_user : bwstat
sql_refresh_time : 60
sql_history : 1h
sql_history_roundoff : mh
-- cut --
Any clues would be really appreciated :-)
Thanks for any help.
--
Marek Kroemeke
_______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
